{"id":14382,"date":"2020-07-01T14:59:18","date_gmt":"2020-07-01T12:59:18","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/"},"modified":"2023-06-15T16:37:15","modified_gmt":"2023-06-15T14:37:15","slug":"oracle-data-guard-redoroutes-what-is-priority-8","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/","title":{"rendered":"Oracle Data Guard RedoRoutes : What is Priority 8 ?"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property.
\nBy default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using the RedoRoutes property.
\nBasically the RedoRoutes property has this format<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
(redo_routing_rule_1) [(redo_routing_rule_n)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Where each routing rule contains a redo source field and a redo destination field separated by a colon:<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
(redo source : redo destination)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

One can have more information in Oracle documentation <\/a><\/p>\n

In this blog I am trying to simply explain how to configure the RedoRoutes property in a Data Guard environment with Far Sync Instance. See my previous blog <\/a> for far sync instance creation.<\/p>\n

I am using Oracle 20c.<\/p>\n

The first configuration we consider is the following one
\n\"\"<\/a><\/p>\n

We have
\n1 primary database: prod20_site1
\n2 standby databases: prod20_site2 and prod20_site4
\n1 far sync instance fs_site3<\/p>\n

For far sync creation with Oracle 20c see my previous blog <\/a><\/p>\n

Below the status of the broker configuration<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration<\/code><\/div>\n
<\/div>\n
Configuration - prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxAvailability<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>prod20_site1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>fs_site3\u00a0\u00a0\u00a0\u00a0 - Far sync instance<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS\u00a0\u00a0 (status updated 47 seconds ago)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Actually, there is no configured RedoRoutes<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
DGMGRL> show <\/code>database<\/code> prod20_site1 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>''<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> prod20_site2 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>''<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> prod20_site4 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>''<\/code><\/div>\n
DGMGRL> <\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

For this configuration I want the primary database to send the redo according following rules<\/p>\n

prod20_site2 will receive redo directly from prod20_site1
\nprod20_site1 =====> prod20_site2<\/p>\n

prod20_site4 will receive redo via fs_site3 which will forward redo to prod20_site4
\nprod20_site1 =====> fs_site3 =====> prod20_site4<\/p>\n

and if fs_site3 is not available, prod20_site4 will receive directly redo from prod20_site1
\nprod20_site1 =====> prod20_site4<\/p>\n

For this we have to first edit the primary database RedoRoutes property like<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit <\/code>database<\/code> prod20_site1 <\/code>set<\/code> property redoroutes=<\/code>'(local:prod20_site2,(fs_site3 priority=1,prod20_site4 priority=2))'<\/code>;<\/code><\/div>\n
Property <\/code>\"redoroutes\"<\/code> updated<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

In this rule we have these meanings<\/p>\n

local:prod20_site2<\/em>: if prod20_site1 is the primary database then redo will be sent to prod20_site2<\/p>\n

local: (fs_site3 priority=1,prod20_site4 priority=2 )<\/em>: if prod20_site1 is the primary database then redo will be sent to fs_site3 or to prod20_site4. As the priority of the fs_site3 is higher, indeed smaller priority numbers mean higher priority, redo will be sent first to fs_site3, and if fs_site3 is unavailable, changes will be sent to prod20_site4.
\nJust note that as fs_site3 has a higher priority, if fs_site3 becomes available, redo will be again sent to fs_site3.<\/p>\n

And then we have to tell to fs_site3 to forward redo received from prod20_site1 to prod20_site4.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit far_sync fs_site3 <\/code>set<\/code> property redoroutes=<\/code>'(prod20_site1:prod20_site4 ASYNC)'<\/code>;<\/code><\/div>\n
Property <\/code>\"redoroutes\"<\/code> updated<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Below the redoroutes we have configured for prod20_site1 and fs_site3<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
DGMGRL> show <\/code>database<\/code> prod20_site1 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>'(local:prod20_site2,(fs_site3 priority=1,prod20_site4 priority=2))'<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> prod20_site2 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>''<\/code><\/div>\n
DGMGRL> show <\/code>database<\/code> prod20_site4 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>''<\/code><\/div>\n
DGMGRL> show far_sync\u00a0 fs_site3 redoroutes;<\/code><\/div>\n
\u00a0\u00a0<\/code>RedoRoutes = <\/code>'(prod20_site1:prod20_site4 ASYNC)'<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And we can verify the status of our configuration<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration verbose<\/code><\/div>\n
<\/div>\n
<\/div>\n
Configuration - prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>prod20_site1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>fs_site3\u00a0\u00a0\u00a0\u00a0 - Far sync instance<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code> (alternate <\/code>of<\/code> fs_site3)<\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Let\u2019s now consider this configuration where we have two far syn instances. As in the first configuration, we want to send first the redo to far sync instances if possible, otherwise redo will be send directly to standby databases<\/p>\n

\"\"<\/a><\/p>\n

The RedoRoutes property of the primary can be configured as below<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit <\/code>database<\/code> prod20_site1 <\/code>set<\/code> property redoroutes=<\/code>'(local:(fs_site5 priority=1,prod20_site2 priority=2),(fs_site3 priority=1,prod20_site4 priority=2))'<\/code>;<\/code><\/div>\n
Warning: ORA-16677: Standby <\/code>database<\/code> has the same <\/code>or<\/code> higher priority than other members specified <\/code>in<\/code> the RedoRoutes <\/code>group<\/code>.<\/code><\/div>\n
<\/div>\n
Property <\/code>\"redoroutes\"<\/code> updated<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And the redoroutes for the far sysnc fs_site5 can be adjusted like<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit far_sync fs_site5 <\/code>set<\/code> property redoroutes=<\/code>'(prod20_site1:prod20_site2 ASYNC)'<\/code>;<\/code><\/div>\n
Property <\/code>\"redoroutes\"<\/code> updated<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can then verify the satus of the configuration<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration verbose<\/code><\/div>\n
<\/div>\n
Configuration - prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>prod20_site1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>fs_site5\u00a0\u00a0\u00a0\u00a0 - Far sync instance<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code> (alternate <\/code>of<\/code> fs_site5)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>fs_site3\u00a0\u00a0\u00a0\u00a0 - Far sync instance<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code> (alternate <\/code>of<\/code> fs_site3)<\/code><\/div>\n
<\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

As we can see when configuring RedoRoutes, we sometimes have to deal with the property PRIORITY.
\nThis property can have a value between 1 and 8. 1 as the highest priority and 8 the lowest priority.
\nLet\u2019s consider two destination A and B in the same group<\/p>\n

Case 1: A and B with the same prority<\/p>\n

Redo will be sent to A or B, let\u2019s say A. When A is unavailable, redo will be then sent to B. And when A become reachable again, redo will continue to be sent to B.<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
(<\/code>local<\/code>:(A priority=1,B priority=1))<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Case 2: A has a higher priority then B
\nRedo will be sent to A. If A becomes unavailable, redo will be sent to B. And if A becomes again reachable, redo will be sent to A as it has the highest priority<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
(<\/code>local<\/code>:(A priority=1,B priority=2))<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

But sometimes in the same group, we may want to send redo to both members. For example if we consider the following configuration, we just want that redo will be sent to fs_site3 if possible and if fs_site3 is not reachable then changes will be sent to both prod20_site2 et prod20_site4.<\/p>\n

\"\"<\/a><\/p>\n

In this case we can use the PRIORITY 8 which has a special meaning. If the primary sends redo to a member with PRIORITY 8, then it must also send these redo to each member with the PRIORITY 8 in the group<\/p>\n

In the configuration above, we want following rules<\/p>\n

prod20_site1 will send changes to fs_site3 which will forward to prod20_site2 and prod20_site4 and if fs_site3 is not avalaible, prod20_site1 will ship redo to both standby databases.<\/p>\n

And when fs_site3 becomes again available, redo will be send again to fs_site3<\/p>\n

The redoRoutes for the primary database can be like<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit <\/code>database<\/code> prod20_site1 <\/code>set<\/code> property redoroutes=<\/code>'(local:(fs_site3 priority=1,prod20_site2 priority=8,prod20_site4 priority=8))'<\/code>;<\/code><\/div>\n
Warning: ORA-16677: Standby <\/code>database<\/code> has the same <\/code>or<\/code> higher priority than other members specified <\/code>in<\/code> the RedoRoutes <\/code>group<\/code>.<\/code><\/div>\n
<\/div>\n
Property <\/code>\"redoroutes\"<\/code> updated<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And for the far sync instance<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
DGMGRL> edit far_sync fs_site3 <\/code>set<\/code> property redoroutes=<\/code>'(prod20_site1:prod20_site2 ASYNC,prod20_site4 ASYNC)'<\/code>;<\/code><\/div>\n
Property <\/code>\"redoroutes\"<\/code> updated<\/code><\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

The status of the configuration<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n<\/td>\n
\n
\n
DGMGRL> show configuration verbose<\/code><\/div>\n
<\/div>\n
Configuration - prod20<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Protection Mode: MaxPerformance<\/code><\/div>\n
\u00a0\u00a0<\/code>Members:<\/code><\/div>\n
\u00a0\u00a0<\/code>prod20_site1 - <\/code>Primary<\/code> database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>fs_site3\u00a0\u00a0\u00a0\u00a0 - Far sync instance<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site2 - Physical standby <\/code>database<\/code> (alternate <\/code>of<\/code> fs_site3)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>prod20_site4 - Physical standby <\/code>database<\/code> (alternate <\/code>of<\/code> fs_site3)<\/code><\/div>\n
\u2026<\/code><\/div>\n
\u2026<\/code><\/div>\n
<\/div>\n
Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n
<\/div>\n
Configuration Status:<\/code><\/div>\n
SUCCESS<\/code><\/div>\n
<\/div>\n
DGMGRL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

Depending to the configuration, the redo transport topology can be very complex. What I can recommend when dealing with far sync instances, is to think about all possible cases, including switchover and failover. And based of all possible cases to design an architecture for the redo transport. In this blog we just consider the case when prod20_site1 is the primary.<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using […]<\/p>\n","protected":false},"author":27,"featured_media":14383,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[1237,1707,221,2016,458,2017],"type_dbi":[],"class_list":["post-14382","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-oracle","tag-broker","tag-cascading","tag-data-guard","tag-far-sync-instance","tag-oracle-20c","tag-priority8"],"acf":[],"yoast_head":"\nOracle Data Guard RedoRoutes : What is Priority 8 ? - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle Data Guard RedoRoutes : What is Priority 8 ?\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-07-01T12:59:18+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:37:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1172\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle Data Guard RedoRoutes : What is Priority 8 ?\",\"datePublished\":\"2020-07-01T12:59:18+00:00\",\"dateModified\":\"2023-06-15T14:37:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\"},\"wordCount\":860,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png\",\"keywords\":[\"Broker\",\"cascading\",\"Data Guard\",\"Far Sync Instance\",\"Oracle 20c\",\"Priority=8\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\",\"name\":\"Oracle Data Guard RedoRoutes : What is Priority 8 ? - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png\",\"datePublished\":\"2020-07-01T12:59:18+00:00\",\"dateModified\":\"2023-06-15T14:37:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png\",\"width\":1172,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Data Guard RedoRoutes : What is Priority 8 ?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle Data Guard RedoRoutes : What is Priority 8 ? - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/","og_locale":"en_US","og_type":"article","og_title":"Oracle Data Guard RedoRoutes : What is Priority 8 ?","og_description":"By Mouhamadou Diaw When dealing with cascading or far sync in a Data Guard environment, it is important to understand how to configure the RedoRoutes property. By default, a primary database sends redo to each transport destination that is configured in the destination. We can create more complex transport topology, depending of our environment, using […]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/","og_site_name":"dbi Blog","article_published_time":"2020-07-01T12:59:18+00:00","article_modified_time":"2023-06-15T14:37:15+00:00","og_image":[{"width":1172,"height":500,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle Data Guard RedoRoutes : What is Priority 8 ?","datePublished":"2020-07-01T12:59:18+00:00","dateModified":"2023-06-15T14:37:15+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/"},"wordCount":860,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png","keywords":["Broker","cascading","Data Guard","Far Sync Instance","Oracle 20c","Priority=8"],"articleSection":["Database Administration & Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/","name":"Oracle Data Guard RedoRoutes : What is Priority 8 ? - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png","datePublished":"2020-07-01T12:59:18+00:00","dateModified":"2023-06-15T14:37:15+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/pic1-1.png","width":1172,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-data-guard-redoroutes-what-is-priority-8\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle Data Guard RedoRoutes : What is Priority 8 ?"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14382","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=14382"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14382\/revisions"}],"predecessor-version":[{"id":25948,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14382\/revisions\/25948"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14383"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14382"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14382"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14382"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14382"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}