{"id":14210,"date":"2020-05-30T19:07:30","date_gmt":"2020-05-30T17:07:30","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/"},"modified":"2023-06-15T16:37:50","modified_gmt":"2023-06-15T14:37:50","slug":"oracle-20c-create-a-far-sync-instance-is-now-easy","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/","title":{"rendered":"Oracle 20c : Create a Far Sync Instance Is Now Easy"},"content":{"rendered":"<p><strong>By Mouhamadou Diaw<\/strong><\/p>\n<p>A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance, a far sync instance does not contain any datafiles and then can not be open for access. A far sync instance just manages a controlfile. A far sync instance cannot be converted to a primary instance or any other type of standby<br \/>\nFar sync instances are part of the Oracle Active Data Guard Far Sync feature, which requires an Oracle Active Data Guard license.<br \/>\nUntil Oracle 20c, the creation of a far sync install was manual. Until Oracle 20c the far sync install must be manually added to the broker.<\/p>\n<p>Starting with Oracke 20c, Oracle now can create a far sync instance for us and also add it in the broker configuration.<\/p>\n<p>In this blog I am showing how to use this functionnality. Below the actual configuration I am using<\/p>\n<div>\n<div id=\"highlighter_747349\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">DGMGRL&gt; show configuration<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">Configuration - prod20<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">Protection Mode: MaxAvailability<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">Members:<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site1 - <\/code><code class=\"sql keyword\">Primary<\/code> <code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site2 - Physical standby <\/code><code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site4 - Physical standby <\/code><code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql plain\">Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"sql plain\">Configuration Status:<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">SUCCESS\u00a0\u00a0 (status updated 55 seconds ago)<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"sql plain\">DGMGRL&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>And I am going to create a far sync instance fs_site3 to receive changes from the primary database prod20_site20 and to ship these changes to prod20_site4 as shown in this figure<\/p>\n<p><a href=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs_site-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-40276\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs_site-1.png\" alt=\"\" width=\"300\" height=\"128\" \/><\/a><\/p>\n<p>With Oracle there is a new CREATE FAR_SYNC command whichh will create the far sync instance for us. But before using this command there are some steps.<br \/>\nFirst we have to configure Secure External Password Store for the netalias we use.<\/p>\n<p>In our case we are using following aliases<br \/>\nprod20_site1<br \/>\nprod20_site2<br \/>\nprod20_site3<br \/>\nprod20_site4<\/p>\n<div>\n<div id=\"highlighter_87260\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">oracle@oraadserver:\/home\/oracle\/ [prod20 (CDB$ROOT)] tnsping prod20_site1<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Used TNSNAMES adapter <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">resolve the alias<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Attempting <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = prod20_site1_dgmgrl)))<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql plain\">OK (0 msec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div>\n<div id=\"highlighter_742229\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">oracle@oraadserver:\/home\/oracle\/ [prod20 (CDB$ROOT)] tnsping prod20_site2<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Used TNSNAMES adapter <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">resolve the alias<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Attempting <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver2)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = prod20_site2_dgmgrl)))<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div>\n<div id=\"highlighter_717045\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">oracle@oraadserver:\/home\/oracle\/ [prod20 (CDB$ROOT)] tnsping prod20_site3<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Used TNSNAMES adapter <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">resolve the alias<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Attempting <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver3)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = fs_site3_dgmgrl)))<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql plain\">OK (0 msec)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<div>\n<div id=\"highlighter_244262\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">oracle@oraadserver:\/home\/oracle\/ [prod20 (CDB$ROOT)] tnsping prod20_site4<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Used TNSNAMES adapter <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">resolve the alias<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Attempting <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = oraadserver4)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = prod20_site4_dgmgrl)))<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql plain\">OK (0 msec)<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql plain\">oracle@oraadserver:\/home\/oracle\/ [prod20 (CDB$ROOT)]<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Basically to configure Secure External Password Store<\/p>\n<div>\n<div id=\"highlighter_347942\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">mkstore -wrl wallet_location -<\/code><code class=\"sql keyword\">create<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">mkstore -wrl wallet_location -createCredential prod20_site1 sys <\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">mkstore -wrl wallet_location -createCredential prod20_site2 sys <\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">mkstore -wrl wallet_location -createCredential prod20_site3\u00a0 sys <\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">\u2026<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>And after you will have to update your sqlnet.ora file with the location of the wallet.<\/p>\n<p>If everything is OK, you normally should be able to connect using your tnsalias<\/p>\n<div>\n<div id=\"highlighter_97628\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">CDB$ROOT)] sqlplus \/@prod20_site1 <\/code><code class=\"sql keyword\">as<\/code> <code class=\"sql plain\">sysdba<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">SQL*Plus: Release 20.0.0.0.0 - Production <\/code><code class=\"sql keyword\">on<\/code> <code class=\"sql plain\">Sat May 30 19:20:21 2020<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Version 20.2.0.0.0<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql plain\">Copyright (c) 1982, 2019, Oracle.\u00a0 <\/code><code class=\"sql color1\">All<\/code> <code class=\"sql plain\">rights reserved.<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql plain\">Heure de la derniere connexion reussie : Sam. Mai\u00a0\u00a0 30 2020 18:36:15 +02:00<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"sql plain\">Connecte a :<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql plain\">Oracle <\/code><code class=\"sql keyword\">Database<\/code> <code class=\"sql plain\">20c Enterprise Edition Release 20.0.0.0.0 - Production<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"sql plain\">Version 20.2.0.0.0<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">SQL&gt; show parameter db_unique_name<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"sql keyword\">NAME<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <code class=\"sql plain\">TYPE\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"sql comments\">------------------------------------ ----------- ------------------------------<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"sql plain\">db_unique_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0 prod20_site1<\/code><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"sql plain\">SQL&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>After I have start instance fs_site3 in a no mount mode<\/p>\n<div>\n<div id=\"highlighter_260960\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">SQL&gt; startup nomount<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">ORACLE instance started.<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">Total System <\/code><code class=\"sql keyword\">Global<\/code> <code class=\"sql plain\">Area\u00a0 314570960 bytes<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Fixed <\/code><code class=\"sql keyword\">Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <code class=\"sql plain\">9566416 bytes<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql plain\">Variable <\/code><code class=\"sql keyword\">Size<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <code class=\"sql plain\">188743680 bytes<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql keyword\">Database<\/code> <code class=\"sql plain\">Buffers\u00a0\u00a0\u00a0\u00a0\u00a0 113246208 bytes<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql plain\">Redo Buffers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3014656 bytes<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql plain\">SQL&gt; show parameter db_unique_name<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql keyword\">NAME<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <code class=\"sql plain\">TYPE\u00a0\u00a0\u00a0 VALUE<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"sql comments\">------------------------------------ ----------- ------------------------------<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"sql plain\">db_unique_name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 string\u00a0 FS_SITE3<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">SQL&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>And then connection to the broker I can use the command CREATE FAR_SYNC<\/p>\n<div>\n<div id=\"highlighter_753541\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">oracle@oraadserver:\/u01\/ [prod20 (CDB$ROOT)] dgmgrl<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">DGMGRL <\/code><code class=\"sql keyword\">for<\/code> <code class=\"sql plain\">Linux: Release 20.0.0.0.0 - Production <\/code><code class=\"sql keyword\">on<\/code> <code class=\"sql plain\">Sat May 30 19:25:31 2020<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">Version 20.2.0.0.0<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Copyright (c) 1982, 2020, Oracle <\/code><code class=\"sql color1\">and<\/code><code class=\"sql plain\">\/<\/code><code class=\"sql color1\">or<\/code> <code class=\"sql plain\">its affiliates.\u00a0 <\/code><code class=\"sql color1\">All<\/code> <code class=\"sql plain\">rights reserved.<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql plain\">Welcome <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql plain\">DGMGRL, type <\/code><code class=\"sql string\">\"help\"<\/code> <code class=\"sql keyword\">for<\/code> <code class=\"sql plain\">information.<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql plain\">DGMGRL&gt; <\/code><code class=\"sql keyword\">connect<\/code> <code class=\"sql plain\">\/<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql plain\">Connected <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql string\">\"prod20_site1\"<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"sql plain\">Connected <\/code><code class=\"sql keyword\">as<\/code> <code class=\"sql plain\">SYSDG.<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql plain\">DGMGRL&gt; <\/code><code class=\"sql keyword\">CREATE<\/code> <code class=\"sql plain\">FAR_SYNC fs_site3 <\/code><code class=\"sql keyword\">AS<\/code> <code class=\"sql keyword\">CONNECT<\/code> <code class=\"sql plain\">IDENTIFIER <\/code><code class=\"sql keyword\">IS<\/code> <code class=\"sql string\">\"prod20_site3\"<\/code><code class=\"sql plain\">;<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"sql plain\">Creating far sync instance <\/code><code class=\"sql string\">\"fs_site3\"<\/code><code class=\"sql plain\">.<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"sql plain\">Connected <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql string\">\"prod20_site1\"<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">Connected <\/code><code class=\"sql keyword\">to<\/code> <code class=\"sql string\">\"FS_SITE3\"<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"sql plain\">far sync instance <\/code><code class=\"sql string\">\"fs_site3\"<\/code> <code class=\"sql plain\">created<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"sql plain\">far sync instance <\/code><code class=\"sql string\">\"fs_site3\"<\/code> <code class=\"sql plain\">added<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"sql plain\">DGMGRL&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>The far sync instance is created and added in the configuration as we can verify<\/p>\n<div>\n<div id=\"highlighter_343513\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">DGMGRL&gt; show configuration<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">Configuration - prod20<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">Protection Mode: MaxAvailability<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">Members:<\/code><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site1 - <\/code><code class=\"sql keyword\">Primary<\/code> <code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site2 - Physical standby <\/code><code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site4 - Physical standby <\/code><code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">fs_site3\u00a0\u00a0\u00a0\u00a0 - Far sync instance (disabled)<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">ORA-16905: The member was <\/code><code class=\"sql color1\">not<\/code> <code class=\"sql plain\">enabled yet.<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><\/div>\n<div class=\"line number13 index12 alt2\"><code class=\"sql plain\">Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n<div class=\"line number14 index13 alt1\"><\/div>\n<div class=\"line number15 index14 alt2\"><code class=\"sql plain\">Configuration Status:<\/code><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"sql plain\">SUCCESS\u00a0\u00a0 (status updated 31 seconds ago)<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><\/div>\n<div class=\"line number18 index17 alt1\"><code class=\"sql plain\">DGMGRL&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Let\u2019s enable the far sync instance<\/p>\n<div>\n<div id=\"highlighter_934728\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<div class=\"line number6 index5 alt1\">6<\/div>\n<div class=\"line number7 index6 alt2\">7<\/div>\n<div class=\"line number8 index7 alt1\">8<\/div>\n<div class=\"line number9 index8 alt2\">9<\/div>\n<div class=\"line number10 index9 alt1\">10<\/div>\n<div class=\"line number11 index10 alt2\">11<\/div>\n<div class=\"line number12 index11 alt1\">12<\/div>\n<div class=\"line number13 index12 alt2\">13<\/div>\n<div class=\"line number14 index13 alt1\">14<\/div>\n<div class=\"line number15 index14 alt2\">15<\/div>\n<div class=\"line number16 index15 alt1\">16<\/div>\n<div class=\"line number17 index16 alt2\">17<\/div>\n<div class=\"line number18 index17 alt1\">18<\/div>\n<div class=\"line number19 index18 alt2\">19<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">DGMGRL&gt; enable far_sync fs_site3;<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">Enabled.<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><code class=\"sql plain\">DGMGRL&gt; show configuration<\/code><\/div>\n<div class=\"line number4 index3 alt1\"><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Configuration - prod20<\/code><\/div>\n<div class=\"line number6 index5 alt1\"><\/div>\n<div class=\"line number7 index6 alt2\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">Protection Mode: MaxAvailability<\/code><\/div>\n<div class=\"line number8 index7 alt1\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">Members:<\/code><\/div>\n<div class=\"line number9 index8 alt2\"><code class=\"sql spaces\">\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site1 - <\/code><code class=\"sql keyword\">Primary<\/code> <code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number10 index9 alt1\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site2 - Physical standby <\/code><code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number11 index10 alt2\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">prod20_site4 - Physical standby <\/code><code class=\"sql keyword\">database<\/code><\/div>\n<div class=\"line number12 index11 alt1\"><code class=\"sql spaces\">\u00a0\u00a0\u00a0\u00a0<\/code><code class=\"sql plain\">fs_site3\u00a0\u00a0\u00a0\u00a0 - Far sync instance<\/code><\/div>\n<div class=\"line number13 index12 alt2\"><\/div>\n<div class=\"line number14 index13 alt1\"><code class=\"sql plain\">Fast-Start Failover:\u00a0 Disabled<\/code><\/div>\n<div class=\"line number15 index14 alt2\"><\/div>\n<div class=\"line number16 index15 alt1\"><code class=\"sql plain\">Configuration Status:<\/code><\/div>\n<div class=\"line number17 index16 alt2\"><code class=\"sql plain\">SUCCESS\u00a0\u00a0 (status updated 38 seconds ago)<\/code><\/div>\n<div class=\"line number18 index17 alt1\"><\/div>\n<div class=\"line number19 index18 alt2\"><code class=\"sql plain\">DGMGRL&gt;<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Now that the far sync is created, we can configure the redoroutes for the databases.<br \/>\nThe following configuration means<br \/>\n-If prod20_site1 is the primary database, it will send the changes to prod20_site2 and to fs_site3<br \/>\n-And the fs_site3 will send the changes to prod20_site4 if prod20_site1 is the primary database<\/p>\n<div>\n<div id=\"highlighter_575571\" class=\"syntaxhighlighter  sql\">\n<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n<tbody>\n<tr>\n<td class=\"gutter\">\n<div class=\"line number1 index0 alt2\">1<\/div>\n<div class=\"line number2 index1 alt1\">2<\/div>\n<div class=\"line number3 index2 alt2\">3<\/div>\n<div class=\"line number4 index3 alt1\">4<\/div>\n<div class=\"line number5 index4 alt2\">5<\/div>\n<\/td>\n<td class=\"code\">\n<div class=\"container\">\n<div class=\"line number1 index0 alt2\"><code class=\"sql plain\">DGMGRL&gt; edit <\/code><code class=\"sql keyword\">database<\/code> <code class=\"sql plain\">prod20_site1 <\/code><code class=\"sql keyword\">set<\/code> <code class=\"sql plain\">property redoroutes=<\/code><code class=\"sql string\">'(local:prod20_site2,fs_site3)'<\/code><code class=\"sql plain\">;<\/code><\/div>\n<div class=\"line number2 index1 alt1\"><code class=\"sql plain\">Property <\/code><code class=\"sql string\">\"redoroutes\"<\/code> <code class=\"sql plain\">updated<\/code><\/div>\n<div class=\"line number3 index2 alt2\"><\/div>\n<div class=\"line number4 index3 alt1\"><code class=\"sql plain\">DGMGRL&gt; edit far_sync fs_site3 <\/code><code class=\"sql keyword\">set<\/code> <code class=\"sql plain\">property redoroutes=<\/code><code class=\"sql string\">'(prod20_site1:prod20_site4 ASYNC)'<\/code><code class=\"sql plain\">;<\/code><\/div>\n<div class=\"line number5 index4 alt2\"><code class=\"sql plain\">Property <\/code><code class=\"sql string\">\"redoroutes\"<\/code> <code class=\"sql plain\">updated<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>We will talk in deep in redoroutes configuration in coming blogs<\/p>\n","protected":false},"excerpt":{"rendered":"<p>By Mouhamadou Diaw A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance, a far sync instance does not contain any datafiles and then can not be open [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":14212,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,59],"tags":[1381,221,1971,458],"type_dbi":[],"class_list":["post-14210","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-administration-monitoring","category-oracle","tag-active-data-guard","tag-data-guard","tag-far-sync","tag-oracle-20c"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle 20c : Create a Far Sync Instance Is Now Easy - 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-20c-create-a-far-sync-instance-is-now-easy\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle 20c : Create a Far Sync Instance Is Now Easy\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance, a far sync instance does not contain any datafiles and then can not be open [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-05-30T17:07:30+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-15T14:37:50+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs-3.png\" \/>\n\t<meta property=\"og:image:width\" content=\"834\" \/>\n\t<meta property=\"og:image:height\" content=\"329\" \/>\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=\"5 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-20c-create-a-far-sync-instance-is-now-easy\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle 20c : Create a Far Sync Instance Is Now Easy\",\"datePublished\":\"2020-05-30T17:07:30+00:00\",\"dateModified\":\"2023-06-15T14:37:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/\"},\"wordCount\":425,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/fs-3.png\",\"keywords\":[\"Active Data Guard\",\"Data Guard\",\"Far Sync\",\"Oracle 20c\"],\"articleSection\":[\"Database Administration &amp; Monitoring\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/\",\"name\":\"Oracle 20c : Create a Far Sync Instance Is Now Easy - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/fs-3.png\",\"datePublished\":\"2020-05-30T17:07:30+00:00\",\"dateModified\":\"2023-06-15T14:37:50+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/fs-3.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/sites\\\/2\\\/2022\\\/04\\\/fs-3.png\",\"width\":834,\"height\":329},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/oracle-20c-create-a-far-sync-instance-is-now-easy\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle 20c : Create a Far Sync Instance Is Now Easy\"}]},{\"@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 20c : Create a Far Sync Instance Is Now Easy - 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-20c-create-a-far-sync-instance-is-now-easy\/","og_locale":"en_US","og_type":"article","og_title":"Oracle 20c : Create a Far Sync Instance Is Now Easy","og_description":"By Mouhamadou Diaw A far sync instance is like a standby instance as it can receive redo from the primary database and can ship that redo to other members of the Data Guard configuration. But unlike a physical standby instance, a far sync instance does not contain any datafiles and then can not be open [&hellip;]","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/","og_site_name":"dbi Blog","article_published_time":"2020-05-30T17:07:30+00:00","article_modified_time":"2023-06-15T14:37:50+00:00","og_image":[{"width":834,"height":329,"url":"http:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs-3.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle 20c : Create a Far Sync Instance Is Now Easy","datePublished":"2020-05-30T17:07:30+00:00","dateModified":"2023-06-15T14:37:50+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/"},"wordCount":425,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs-3.png","keywords":["Active Data Guard","Data Guard","Far Sync","Oracle 20c"],"articleSection":["Database Administration &amp; Monitoring","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/","name":"Oracle 20c : Create a Far Sync Instance Is Now Easy - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs-3.png","datePublished":"2020-05-30T17:07:30+00:00","dateModified":"2023-06-15T14:37:50+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs-3.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/fs-3.png","width":834,"height":329},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-20c-create-a-far-sync-instance-is-now-easy\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle 20c : Create a Far Sync Instance Is Now Easy"}]},{"@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\/14210","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=14210"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14210\/revisions"}],"predecessor-version":[{"id":25950,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/14210\/revisions\/25950"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/14212"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=14210"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=14210"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=14210"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=14210"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}