{"id":2096,"date":"2022-04-14T09:40:52","date_gmt":"2022-04-14T07:40:52","guid":{"rendered":"http:\/\/www.ludovicocaldara.net\/dba\/?p=2096"},"modified":"2022-04-14T09:43:28","modified_gmt":"2022-04-14T07:43:28","slug":"farsync-and-fsfo","status":"publish","type":"post","link":"https:\/\/www.ludovicocaldara.net\/dba\/farsync-and-fsfo\/","title":{"rendered":"Far Sync and Fast-Start Failover Protection modes"},"content":{"rendered":"

Oracle advertises Far Sync as a solution for “Zero Data Loss at any distance”. This is because the primary sends its redo stream synchronously to the Far Sync, which relays it to the remote physical standby.<\/p>\n

\"\"<\/a>There are many reasons why Far Sync is an optimal solution for this use case, but that’s not the topic of this post \ud83d\ude42<\/p>\n

Some customers ask: Can I configure Far Sync to receive the redo stream asynchronously<\/strong>?<\/p>\n

Although a direct standby receiving asynchronously would be a better idea, Far Sync can receive asynchronously as well.<\/p>\n

And one reason might be to send asynchronously to one Far Sync member that redistributes locally to many standbys.<\/p>\n

\"\"<\/a>It is very simple to achieve: just changing the RedoRoutes property on the primary.<\/p>\n

RedoRoutes = '(LOCAL : cdgsima_farsync1 ASYNC)'<\/pre>\n
This will work seamlessly. The v$dataguard_process will show the async transport process:<\/p>\n
NAME PID TYP ACTION CLIENT_PID CLIENT_ROLE GROUP# RESETLOG_ID THREAD# SEQUENCE# BLOCK#\r\nTT02 440 KSV async ORL multi 0 none 2 1098480879 1 146 456<\/pre>\n
 <\/p>\n
What about Fast-Start Failover?<\/strong><\/p>\n
Up to and including 19c, ASYNC transport to Far Sync will not work with Fast-Start Failover (FSFO).<\/p>\n
ASYNC redo transport mandates Maximum Performance protection mode, and FSFO supports that in conjunction with Far Sync only starting with 21c.<\/p>\n
\"\"<\/a><\/p>\n
Before 21c, trying to enable FSFO with a Far Sync will fail with:<\/p>\n
effective redo transport mode is incompatible with the configuration protection mode<\/pre>\n
DGMGRL> show fast_start failover\r\n\r\nFast-Start Failover:  Disabled\r\n\r\n  Protection Mode:    MaxPerformance\r\n  Lag Limit:          30 seconds\r\n\r\n  Threshold:          30 seconds\r\n  Active Target:      (none)\r\n  Potential Targets:  \"cdgsima_lhr1bm\"\r\n    cdgsima_lhr1bm invalid - effective redo transport mode is incompatible with the configuration protection mode\r\n  Observer:           (none)\r\n  Shutdown Primary:   TRUE\r\n  Auto-reinstate:     TRUE\r\n  Observer Reconnect: (none)\r\n  Observer Override:  FALSE\r\n\r\nConfigurable Failover Conditions\r\n  Health Conditions:\r\n    Corrupted Controlfile          YES\r\n    Corrupted Dictionary           YES\r\n    Inaccessible Logfile            NO\r\n    Stuck Archiver                  NO\r\n    Datafile Write Errors          YES\r\n\r\n  Oracle Error Conditions:\r\n    (none)\r\n<\/pre>\n
So if you want FSFO with Far Sync in 19c, it has to be MaxAvailability (and SYNC redo transport to the FarSync).<\/p>\n

\n<\/a>If you don’t need FSFO<\/strong>, as we have seen, there is no problem. The only protection mode that will not work with Far Sync is Maximum Protection:<\/p>\n
\"\"<\/a>If FSFO is required<\/strong>, and you want Maximum Performance before 21c, or Maximum Protection<\/strong>, you have to remove Far Syn<\/strong>c from the redo route.<\/p>\n
\"\"<\/a><\/p>\n
—<\/p>\n
Ludovico<\/p>\n","protected":false},"excerpt":{"rendered":"
Oracle advertises Far Sync as a solution for “Zero Data Loss at any distance”. This is because the primary sends its redo stream synchronously to the Far Sync, which relays it to the remote physical standby. There are many reasons … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[329,3],"tags":[202,355,351,354,353],"class_list":["post-2096","post","type-post","status-publish","format-standard","hentry","category-oracle-dg","category-oracledb","tag-active-data-guard","tag-async","tag-far-sync","tag-fast-start-failover","tag-fsfo"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2096","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/comments?post=2096"}],"version-history":[{"count":4,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2096\/revisions"}],"predecessor-version":[{"id":2105,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/posts\/2096\/revisions\/2105"}],"wp:attachment":[{"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/media?parent=2096"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/categories?post=2096"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ludovicocaldara.net\/dba\/wp-json\/wp\/v2\/tags?post=2096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}