{"id":15099,"date":"2020-03-02T12:05:51","date_gmt":"2020-03-02T12:05:51","guid":{"rendered":"https:\/\/dbtut.com\/?p=15099"},"modified":"2020-03-02T12:06:48","modified_gmt":"2020-03-02T12:06:48","slug":"far-sync-in-oracle-12c","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/","title":{"rendered":"Far Sync in Oracle 12c"},"content":{"rendered":"<p>Far SYNC is a feature introduced with 12c.<\/p>\n<p>It is the dummy instance that sends the Redos from the Primary Database to other Standby Databases in the Data Guard configuration.<\/p>\n<p>It has only standby control file, password file, standby redo log and archived logs. Since there are no Datafiles on it, there is no Redo Apply process.<\/p>\n<p>By sending redos to the nearby location as SYNC, it guarantees zero data loss. It also preserves the availability of the Primary Database.<\/p>\n<p>After guaranteeing zero data loss, redos can be sent as SYNC or ASYNC to up to 30 locations via Far SYNC instance.<\/p>\n<p>Its architectural structure is as follows.<\/p>\n<p id=\"sGkoMGP\"><img loading=\"lazy\" decoding=\"async\" width=\"516\" height=\"338\" class=\"size-full wp-image-15100  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/img_5e5cbb574cbdc.png\" alt=\"\" \/><\/p>\n<p>As the database will run in Mount mode, you will likely pay license money to Oracle per core.<\/p>\n<p>Redos can be sent to Standby Databases as compressed.<\/p>\n<p>An alternative &#8220;Far SYNC&#8221; can be used for High Availability.<\/p>\n<p>In Cascade Standby structures in versions prior to 12c, Redos can be sent from Primary to the first Standby as SYNC. However, Redos could not be sent to other Standby Databases as SYNC.<\/p>\n<p>In Cascade structures in 12c, Redos can be sent as SYNC to Far SYNC instances and Physical Standbys.<\/p>\n<p>With this feature, you can have multiple SYNC Standby Databases.<\/p>\n<h3>How To Create Far SYNC Instance?<\/h3>\n<h4>Step1:<\/h4>\n<p>Create PFILE from SPFILE in the primary database.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; create pfile='\/tmp\/initprmyFS.ora' from spfile;\n\nFile created.<\/pre>\n<h4>Step2:<\/h4>\n<p>Create Control File for Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter database create far sync instance controlfile as '\/tmp\/prmyFS.ctl';\n\nDatabase altered.<\/pre>\n<h4>Step3:<\/h4>\n<p>Move Control File, PFILE and Password File to Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@primary tmp]$ scp initprmyFS.ora prmyFS:\/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\noracle@prmyfs's password: \ninitprmyFS.ora                           100% 1383     1.4KB\/s   00:00    \n[oracle@primary tmp]$ scp prmyFS.ctl prmyFS:\/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\noracle@prmyfs's password: \nprmyFS.ctl                               100% 9808KB   9.6MB\/s   00:00    \n[oracle@primary tmp]$ scp \/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\/orapwprimary prmyFS:\/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\/orapwprmyFS\noracle@prmyfs's password: \norapwprimary                             100% 7680     7.5KB\/s   00:00<\/pre>\n<h4>Step4:<\/h4>\n<p>Check if the files go to Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[root@prmyFS ~]# su - oracle\n[oracle@prmyFS ~]$ cd $ORACLE_HOME\/dbs\n[oracle@prmyFS dbs]$ ls\ninit.ora  initprmyFS.ora  orapwprmyFS  prmyFS.ctl<\/pre>\n<h4>Step5:<\/h4>\n<p>Create the necessary directories in the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS dbs]$ mkdir -p \/u01\/app\/oracle\/admin\/prmyFS\/adump\n[oracle@prmyFS dbs]$ mkdir -p \/u01\/app\/oracle\/oradata\/prmyFS\n[oracle@prmyFS dbs]$ mkdir -p \/u01\/app\/oracle\/recovery_area\/prmyFS<\/pre>\n<h4>Step6:<\/h4>\n<p>Edit the PFILE file according to the behavior of the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS dbs]$ vi initprmyFS.ora<\/pre>\n<p>Update the PFILE parameter file by running <code>:%s\/primary\/prmyFS\/g<\/code> command as follows.<\/p>\n<pre class=\"lang:default decode:true \">prmyFS.__data_transfer_cache_size=0\nprmyFS.__db_cache_size=2583691264\nprmyFS.__java_pool_size=16777216\nprmyFS.__large_pool_size=33554432\nprmyFS.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\nprmyFS.__pga_aggregate_target=1157627904\nprmyFS.__sga_target=3472883712\nprmyFS.__shared_io_pool_size=167772160\nprmyFS.__shared_pool_size=654311424\nprmyFS.__streams_pool_size=0\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/prmyFS\/adump'\n*.audit_trail='db'\n*.compatible='12.1.0.2.0'\n*.control_files='\/u01\/app\/oracle\/oradata\/prmyFS\/control01.ctl','\/u01\/app\/oracle\/recovery_area\/prmyFS\/control02.ctl'\n*.db_block_size=8192\n*.db_domain=''\n*.db_name='prmyFS'\n*.db_recovery_file_dest='\/u01\/app\/oracle\/recovery_area'\n*.db_recovery_file_dest_size=10737418240\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=prmyFSXDB)'\n*.log_archive_config='dg_config=(prmyFS,prmyFS,physical,physclFS,logical)'\n*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=prmyFS'\n*.log_archive_dest_2='SERVICE=physical ASYNC REOPEN=15 valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=physical'\n*.log_archive_max_processes=8\n*.open_cursors=300\n*.pga_aggregate_target=1100m\n*.processes=300\n*.remote_login_passwordfile='EXCLUSIVE'\n*.sga_target=3302m\n*.standby_file_management='auto'\n*.undo_tablespace='UNDOTBS1'\n<\/pre>\n<p>After the necessary arrangements in the PFILE parameter file, the final version of the current PFILE file is as follows.<\/p>\n<pre class=\"lang:default decode:true \">prmyFS.__data_transfer_cache_size=0\nprmyFS.__db_cache_size=2583691264\nprmyFS.__java_pool_size=16777216\nprmyFS.__large_pool_size=33554432\nprmyFS.__oracle_base='\/u01\/app\/oracle'#ORACLE_BASE set from environment\nprmyFS.__pga_aggregate_target=1157627904\nprmyFS.__sga_target=3472883712\nprmyFS.__shared_io_pool_size=167772160\nprmyFS.__shared_pool_size=654311424\nprmyFS.__streams_pool_size=0\n*.audit_file_dest='\/u01\/app\/oracle\/admin\/prmyFS\/adump'\n*.audit_trail='db'\n*.compatible='12.1.0.2.0'\n*.control_files='\/u01\/app\/oracle\/oradata\/prmyFS\/prmyFS01.ctl','\/u01\/app\/oracle\/recovery_area\/prmyFS\/prmyFS02.ctl'\n*.db_block_size=8192\n*.db_domain=''\n*.db_name='primary'\n*.db_unique_name=prmyFS\n*.fal_server=primary\n*.log_file_name_convert='primary','prmyFS'\n*.db_recovery_file_dest='\/u01\/app\/oracle\/recovery_area'\n*.db_recovery_file_dest_size=10737418240\n*.diagnostic_dest='\/u01\/app\/oracle'\n*.dispatchers='(PROTOCOL=TCP) (SERVICE=prmyFSXDB)'\n*.log_archive_config='dg_config=(primary,prmyFS,physical,physclFS,logical)'\n*.log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=prmyFS'\n*.log_archive_dest_2='SERVICE=physical SYNC REOPEN=15 valid_for=(STANDBY_LOGFILES,STANDBY_ROLE) db_unique_name=physical'\n*.log_archive_max_processes=8\n*.open_cursors=300\n*.pga_aggregate_target=1100m\n*.processes=300\n*.remote_login_passwordfile='EXCLUSIVE'\n*.sga_target=3302m\n*.standby_file_management='auto'\n*.undo_tablespace='UNDOTBS1'<\/pre>\n<h4>Step7:<\/h4>\n<p>Copy the Control File file to the locations specified in the Parameter file.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS dbs]$ cp prmyFS.ctl \/u01\/app\/oracle\/oradata\/prmyFS\/prmyFS01.ctl\n[oracle@prmyFS dbs]$ cp prmyFS.ctl \/u01\/app\/oracle\/fast_recovery_area\/prmyFS\/prmyFS02.ctl\n[oracle@prmyFS dbs]$ rm -rf prmyFS.ctl<\/pre>\n<h4>Step8:<\/h4>\n<p>Create SPFILE from PFILE on the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS dbs]$ sqlplus \/ as sysdba\n\nSQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 8 15:30:46 2017\n\nCopyright (c) 1982, 2014, Oracle.  All rights reserved.\n\nConnected to an idle instance.\n\n[PrimaryFS] SQL&gt; create spfile from pfile='\/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\/initprmyFS.ora';\n\nFile created.<\/pre>\n<h4>Step9:<\/h4>\n<p>Mount the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; startup mount;\nORACLE instance started.\n\nTotal System Global Area 3472883712 bytes\nFixed Size                  2930272 bytes\nVariable Size             822086048 bytes\nDatabase Buffers         2634022912 bytes\nRedo Buffers               13844480 bytes\nDatabase mounted.\n<\/pre>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; select status from v$instance;\n\nSTATUS\n------------\nMOUNTED\n<\/pre>\n<h4>Step10:<\/h4>\n<p>Check the Database Role.<\/p>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; select database_role, open_mode, protection_mode from v$database;\n\nDATABASE_ROLE    OPEN_MODE            PROTECTION_MODE\n---------------- -------------------- --------------------\nFAR SYNC         MOUNTED              MAXIMUM PERFORMANCE<\/pre>\n<h4>Step11:<\/h4>\n<p>Update the Primary Database&#8217;s LOG_ARCHIVE_DEST_2 parameter to send the logs to the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system set log_archive_dest_2='SERVICE=prmyFS SYNC REOPEN=15 valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=prmyFS' scope=both;\n\nSystem altered.<\/pre>\n<h4>Step12:<\/h4>\n<p>Check if Archives go to Far SYNC instance by performing Log Switch operation.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            14          1\n<\/pre>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            14          1<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            14          1<\/pre>\n<p>You can see if Standby Redo Logs are created in Far SYNC instance as below.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS dbs]$ ls -la \/u01\/app\/oracle\/oradata\/prmyFS\/stdby*\n-rw-r----- 1 oracle oinstall 52429312 Feb  8 15:38 \/u01\/app\/oracle\/oradata\/prmyFS\/stdbyredo01.log\n-rw-r----- 1 oracle oinstall 52429312 Feb  8 15:36 \/u01\/app\/oracle\/oradata\/prmyFS\/stdbyredo02.log\n-rw-r----- 1 oracle oinstall 52429312 Feb  8 15:36 \/u01\/app\/oracle\/oradata\/prmyFS\/stdbyredo03.log\n-rw-r----- 1 oracle oinstall 52429312 Feb  8 15:36 \/u01\/app\/oracle\/oradata\/prmyFS\/stdbyredo04.log<\/pre>\n<h4>Step13:<\/h4>\n<p>Test it. To do this, create a new table in Primary and see if it is transferred to Physical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK<\/pre>\n<pre class=\"lang:default decode:true\">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK<\/pre>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; create table test.regions as select * from hr.regions;\n\nTable created.\n\n[Primary] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\nREGIONS\n<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\n<\/pre>\n<p>We saw that the created table was not transferred to Physical Standby. The reason is that the Log Transport attribute in the LOG_ARCHIVE_DEST_2 parameter in the Far SYNC instance is SYNC.<\/p>\n<p>In order for Redos to be transferred in Real-Time, this parameter must be set as ASYNC.<\/p>\n<h4>Step14:<\/h4>\n<p>Update the LOG_ARCHIVE_DEST_2 parameter in the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; alter system set log_archive_dest_2='SERVICE=physical ASYNC NOAFFIRM REOPEN=15 valid_for=(STANDBY_LOGFILES,STANDBY_ROLE) db_unique_name=physical' scope=both;\n\nSystem altered.\n<\/pre>\n<h4>Step15:<\/h4>\n<p>Check if the created table is transferred to Physical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK<\/pre>\n<p>Although we updated the LOG_ARCHIVE_DEST_2 parameter, the table was not transferred. This is because the Redo Transport mode will be enabled after the Log Switch operation.<\/p>\n<h4>Step16:<\/h4>\n<p>Perform Log Switch.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            15          1<\/pre>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            15          1<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            15          1\n<\/pre>\n<h4>Step17:<\/h4>\n<p>Check if the created table is transferred to Physical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\nREGIONS<\/pre>\n<h4>Step18:<\/h4>\n<p>Test it again.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; drop table test.regions;\n\nTable dropped.\n\n[Primary] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\n<\/pre>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; create table test.locations_yedek as select * from hr.locations;\n\nTable created.\n\n[Primary] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\nLOCATIONS_YEDEK<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\nLOCATIONS_YEDEK<\/pre>\n<h3>Determine Alternative Redo Transport Location<\/h3>\n<p>In systems where Far SYNC is used, when Far SYNC instance is inaccessible, it is necessary to send Redos directly to Standby Database in order to maintain the availability of Primary Database.<\/p>\n<p>When the access problem resolves, Oracle Data Guard automatically re-synchronizes the Far SYNC instance, arranging the Redo stream to go from Primary to Far SYNC and then to Standby.<\/p>\n<p>You can do alternative Redo Transport as follows.<\/p>\n<h4>Step1:<\/h4>\n<p>Update the archive destination parameter that sends the logs to Far SYNC.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system set log_archive_dest_2='SERVICE=prmyFS SYNC AFFIRM MAX_FAILURE=1 REOPEN=15 ALTERNATE=LOG_ARCHIVE_DEST_3 valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=prmyFS' scope=both;\n\nSystem altered.\n<\/pre>\n<h4>Step2:<\/h4>\n<p>Update the dest_state parameter that will send the Redos to the alternate location.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system set LOG_ARCHIVE_DEST_STATE_3='ALTERNATE' scope = both;\n\nSystem altered.<\/pre>\n<h4>Step3:<\/h4>\n<p>Update the archive destination parameter that will send the Redos to the alternate location.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system set log_archive_dest_3='SERVICE=physical ASYNC NOAFFIRM REOPEN=15 ALTERNATE=LOG_ARCHIVE_DEST_2 valid_for=(ONLINE_LOGFILES,PRIMARY_ROLE) db_unique_name=physical' scope=both;\n\nSystem altered.<\/pre>\n<p>Let&#8217;s test the system&#8217;s functionality.<\/p>\n<h4>Step1:<\/h4>\n<p>Check the existing sequences in Primary, Far SYNC and Physical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            24          1\n<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            24          1\n<\/pre>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            24          1<\/pre>\n<h4>Step2:<\/h4>\n<p>Perform Log Switch.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            25          1<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            25          1<\/pre>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            25          1\n<\/pre>\n<h4>Step3:<\/h4>\n<p>Shut down Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; shu immediate;\nORA-01109: database not open\n\n\nDatabase dismounted.\nORACLE instance shut down.<\/pre>\n<h4>Step4:<\/h4>\n<p>Check the data to see if the changes are transfferred to the Physical Standby.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\nLOCATIONS_YEDEK<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK\nLOCATIONS_YEDEK\n<\/pre>\n<h4>Step5:<\/h4>\n<p>Drop the table.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; drop table test.LOCATIONS_YEDEK;\n\nTable dropped.\n\n[Primary] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select table_name from dba_tables where owner='TEST';\n\nTABLE_NAME\n--------------------------------------------------------------------------------\nJOBS_YEDEK\nEMPLOYEES_YEDEK<\/pre>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            27          1\n<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            27          1<\/pre>\n<h4>Step6:<\/h4>\n<p>Check if the archives are transferred to Standby by performing Log Switch operation.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            29          1\n<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            29          1<\/pre>\n<h4>Step7:<\/h4>\n<p>Check if the logs have been transferred to the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS ~]$ cd \/u01\/app\/oracle\/recovery_area\/prmyFS\/\n[oracle@prmyFS prmyFS]$ ls\nprmyFS02.ctl\n[oracle@prmyFS prmyFS]$ cd ..\n[oracle@prmyFS recovery_area]$ ls\nprmyFS  PRMYFS\n[oracle@prmyFS recovery_area]$ cd PRMYFS\/\n[oracle@prmyFS PRMYFS]$ ls\narchivelog  onlinelog\n[oracle@prmyFS PRMYFS]$ cd archivelog\n[oracle@prmyFS archivelog]$ ls\n2017_02_08  2017_02_09\n[oracle@prmyFS archivelog]$ cd 2017_02_09\n[oracle@prmyFS 2017_02_09]$ ls\no1_mf_1_21_d9qtbtgn_.arc  o1_mf_1_24_d9rjzr6q_.arc\no1_mf_1_22_d9r1c9xw_.arc  o1_mf_1_25_d9rk7dk1_.arc\no1_mf_1_23_d9r1dbvm_.arc\n[oracle@prmyFS 2017_02_09]$ ls\no1_mf_1_21_d9qtbtgn_.arc  o1_mf_1_24_d9rjzr6q_.arc\no1_mf_1_22_d9r1c9xw_.arc  o1_mf_1_25_d9rk7dk1_.arc\no1_mf_1_23_d9r1dbvm_.arc<\/pre>\n<h4>Step8:<\/h4>\n<p>I assume that the access problem in Far SYNC instance has solved. Then I open the instance.<\/p>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; startup mount;\nORACLE instance started.\n\nTotal System Global Area 3472883712 bytes\nFixed Size                  2930272 bytes\nVariable Size             822086048 bytes\nDatabase Buffers         2634022912 bytes\nRedo Buffers               13844480 bytes\nDatabase mounted.\n[PrimaryFS] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            25          1\n<\/pre>\n<h4>Step9:<\/h4>\n<p>Check if the archives are transferred to the Far SYNC instance by performing Log Switch operation.<\/p>\n<pre class=\"lang:default decode:true \">[Primary] SQL&gt; alter system switch logfile;\n\nSystem altered.\n\n[Primary] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            31          1<\/pre>\n<pre class=\"lang:default decode:true \">[PrimaryFS] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            31          1<\/pre>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; SELECT MAX(SEQUENCE#), THREAD# FROM V$ARCHIVED_LOG GROUP BY THREAD#;\n\nMAX(SEQUENCE#)    THREAD#\n-------------- ----------\n            31          1\n<\/pre>\n<h4>Step10:<\/h4>\n<p>Check if the missing archives are transferred to the Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS 2017_02_09]$ ls\no1_mf_1_21_d9qtbtgn_.arc  o1_mf_1_27_d9rkpsl6_.arc\no1_mf_1_22_d9r1c9xw_.arc  o1_mf_1_28_d9rkpskd_.arc\no1_mf_1_23_d9r1dbvm_.arc  o1_mf_1_29_d9rkpslf_.arc\no1_mf_1_24_d9rjzr6q_.arc  o1_mf_1_30_d9rkpshr_.arc\no1_mf_1_25_d9rk7dk1_.arc  o1_mf_1_31_d9rkq54c_.arc\no1_mf_1_26_d9rkpsn1_.arc\n<\/pre>\n<h3>Deleting Unnecessary Archives in Far SYNC Instance<\/h3>\n<p>Since Far SYNC instance transfers Redos to Standby Databases, archives do not need to be stored in Far SYNC instance after the archives are processed to Standby Databases. For this reason, archives processed in Standby Databases can be deleted from Far SYNC instance.<\/p>\n<p>You can delete arciheve logs from Far SYNC instance as follows.<\/p>\n<h4>Step1:<\/h4>\n<p>Connect to RMAN from Far SYNC instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS 2017_02_09]$ rman target \/\n\nRecovery Manager: Release 12.1.0.2.0 - Production on Thu Feb 9 12:48:57 2017\n\nCopyright (c) 1982, 2014, Oracle and\/or its affiliates.  All rights reserved.\n\nconnected to target database: PRIMARY (DBID=1772883609, not open)\n\nRMAN&gt;<\/pre>\n<h4>Step2:<\/h4>\n<p>List the archives in the instance.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; list archivelog all;\n\nusing target database control file instead of recovery catalog\nList of Archived Log Copies for database with db_unique_name PRMYFS\n=====================================================================\n\nKey     Thrd Seq     S Low Time \n------- ---- ------- - ---------\n1       1    14      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_14_d9p7p3r1_.arc\n\n2       1    15      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_15_d9p9oz02_.arc\n\n5       1    16      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_16_d9ptoy8r_.arc\n\n7       1    17      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_17_d9py6ov7_.arc\n\n9       1    18      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_18_d9py7kf1_.arc\n\n11      1    19      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_19_d9py9gdx_.arc\n\n13      1    20      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_20_d9q1v3lh_.arc\n\n15      1    21      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_21_d9qtbtgn_.arc\n\n17      1    22      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_22_d9r1c9xw_.arc\n\n19      1    23      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_23_d9r1dbvm_.arc\n\n21      1    24      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_24_d9rjzr6q_.arc\n\n23      1    25      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_25_d9rk7dk1_.arc\n\n28      1    26      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_26_d9rkpsn1_.arc\n\n26      1    27      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_27_d9rkpsl6_.arc\n\n25      1    28      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_28_d9rkpskd_.arc\n\n27      1    29      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_29_d9rkpslf_.arc\n\n24      1    30      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_30_d9rkpshr_.arc\n\n30      1    31      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_31_d9rkq54c_.arc<\/pre>\n<h4>Step3:<\/h4>\n<p>Check all parameters to make the necessary configuration.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; show all;\n\nRMAN configuration parameters for database with db_unique_name PRMYFS are:\nCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\nCONFIGURE BACKUP OPTIMIZATION OFF; # default\nCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default\nCONFIGURE CONTROLFILE AUTOBACKUP OFF; # default\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default\nCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\nCONFIGURE MAXSETSIZE TO UNLIMITED; # default\nCONFIGURE ENCRYPTION FOR DATABASE OFF; # default\nCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default\nCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default\nCONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default\nCONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\/snapcf_prmyFS.f'; # default<\/pre>\n<h4>Step4:<\/h4>\n<p>Update the parameter so that archives can be deleted after applied in all Standby&#8217;s.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\n\nnew RMAN configuration parameters:\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nnew RMAN configuration parameters are successfully stored<\/pre>\n<h4>Step5:<\/h4>\n<p>Check if the parameter has changed.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; show all;\n\nRMAN configuration parameters for database with db_unique_name PRMYFS are:\nCONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default\nCONFIGURE BACKUP OPTIMIZATION OFF; # default\nCONFIGURE DEFAULT DEVICE TYPE TO DISK; # default\nCONFIGURE CONTROLFILE AUTOBACKUP OFF; # default\nCONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default\nCONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default\nCONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\nCONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default\nCONFIGURE MAXSETSIZE TO UNLIMITED; # default\nCONFIGURE ENCRYPTION FOR DATABASE OFF; # default\nCONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default\nCONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default\nCONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default\nCONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;\nCONFIGURE SNAPSHOT CONTROLFILE NAME TO '\/u01\/app\/oracle\/product\/12.1.0\/db_1\/dbs\/snapcf_prmyFS.f'; # default<\/pre>\n<h4>Step6:<\/h4>\n<p>Perform the CROSSCHECK.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; crosscheck archivelog all;\n\nStarting implicit crosscheck backup at 09-FEB-17\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=366 device type=DISK\nFinished implicit crosscheck backup at 09-FEB-17\n\nStarting implicit crosscheck copy at 09-FEB-17\nusing channel ORA_DISK_1\nFinished implicit crosscheck copy at 09-FEB-17\n\nsearching for all files in the recovery area\ncataloging files...\nno files cataloged\n\nreleased channel: ORA_DISK_1\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=366 device type=DISK\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_14_d9p7p3r1_.arc RECID=1 STAMP=935422563\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_15_d9p9oz02_.arc RECID=2 STAMP=935424607\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_16_d9ptoy8r_.arc RECID=5 STAMP=935442014\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_17_d9py6ov7_.arc RECID=7 STAMP=935445622\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_18_d9py7kf1_.arc RECID=9 STAMP=935445649\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_19_d9py9gdx_.arc RECID=11 STAMP=935445710\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_20_d9q1v3lh_.arc RECID=13 STAMP=935449347\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_21_d9qtbtgn_.arc RECID=15 STAMP=935474427\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_22_d9r1c9xw_.arc RECID=17 STAMP=935481610\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_23_d9r1dbvm_.arc RECID=19 STAMP=935481642\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_24_d9rjzr6q_.arc RECID=21 STAMP=935497624\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_25_d9rk7dk1_.arc RECID=23 STAMP=935497868\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_26_d9rkpsn1_.arc RECID=28 STAMP=935498361\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_27_d9rkpsl6_.arc RECID=26 STAMP=935498361\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_28_d9rkpskd_.arc RECID=25 STAMP=935498361\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_29_d9rkpslf_.arc RECID=27 STAMP=935498361\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_30_d9rkpshr_.arc RECID=24 STAMP=935498361\nvalidation succeeded for archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_31_d9rkq54c_.arc RECID=30 STAMP=935498373\nCrosschecked 18 objects<\/pre>\n<h4>Step7:<\/h4>\n<p>Delete applied archives on standby&#8217;s.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; delete archivelog all;\n\nreleased channel: ORA_DISK_1\nallocated channel: ORA_DISK_1\nchannel ORA_DISK_1: SID=366 device type=DISK\nRMAN-08120: WARNING: archived log not deleted, not yet applied by standby\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_26_d9rkpsn1_.arc thread=1 sequence=26\nRMAN-08120: WARNING: archived log not deleted, not yet applied by standby\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_27_d9rkpsl6_.arc thread=1 sequence=27\nRMAN-08120: WARNING: archived log not deleted, not yet applied by standby\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_28_d9rkpskd_.arc thread=1 sequence=28\nRMAN-08120: WARNING: archived log not deleted, not yet applied by standby\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_29_d9rkpslf_.arc thread=1 sequence=29\nRMAN-08120: WARNING: archived log not deleted, not yet applied by standby\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_30_d9rkpshr_.arc thread=1 sequence=30\nRMAN-08120: WARNING: archived log not deleted, not yet applied by standby\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_31_d9rkq54c_.arc thread=1 sequence=31\nList of Archived Log Copies for database with db_unique_name PRMYFS\n=====================================================================\n\nKey     Thrd Seq     S Low Time \n------- ---- ------- - ---------\n1       1    14      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_14_d9p7p3r1_.arc\n\n2       1    15      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_15_d9p9oz02_.arc\n\n5       1    16      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_16_d9ptoy8r_.arc\n\n7       1    17      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_17_d9py6ov7_.arc\n\n9       1    18      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_18_d9py7kf1_.arc\n\n11      1    19      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_19_d9py9gdx_.arc\n\n13      1    20      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_20_d9q1v3lh_.arc\n\n15      1    21      A 08-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_21_d9qtbtgn_.arc\n\n17      1    22      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_22_d9r1c9xw_.arc\n\n19      1    23      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_23_d9r1dbvm_.arc\n\n21      1    24      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_24_d9rjzr6q_.arc\n\n23      1    25      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_25_d9rk7dk1_.arc\n\n\nDo you really want to delete the above objects (enter YES or NO)? yes\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_14_d9p7p3r1_.arc RECID=1 STAMP=935422563\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_15_d9p9oz02_.arc RECID=2 STAMP=935424607\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_16_d9ptoy8r_.arc RECID=5 STAMP=935442014\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_17_d9py6ov7_.arc RECID=7 STAMP=935445622\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_18_d9py7kf1_.arc RECID=9 STAMP=935445649\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_19_d9py9gdx_.arc RECID=11 STAMP=935445710\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_08\/o1_mf_1_20_d9q1v3lh_.arc RECID=13 STAMP=935449347\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_21_d9qtbtgn_.arc RECID=15 STAMP=935474427\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_22_d9r1c9xw_.arc RECID=17 STAMP=935481610\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_23_d9r1dbvm_.arc RECID=19 STAMP=935481642\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_24_d9rjzr6q_.arc RECID=21 STAMP=935497624\ndeleted archived log\narchived log file name=\/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_25_d9rk7dk1_.arc RECID=23 STAMP=935497868\nDeleted 12 objects\n<\/pre>\n<h4>Step8:<\/h4>\n<p>Check the current archives.<\/p>\n<pre class=\"lang:default decode:true \">RMAN&gt; list archivelog all;\n\nList of Archived Log Copies for database with db_unique_name PRMYFS\n=====================================================================\n\nKey     Thrd Seq     S Low Time \n------- ---- ------- - ---------\n28      1    26      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_26_d9rkpsn1_.arc\n\n26      1    27      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_27_d9rkpsl6_.arc\n\n25      1    28      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_28_d9rkpskd_.arc\n\n27      1    29      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_29_d9rkpslf_.arc\n\n24      1    30      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_30_d9rkpshr_.arc\n\n30      1    31      A 09-FEB-17\n        Name: \/u01\/app\/oracle\/recovery_area\/PRMYFS\/archivelog\/2017_02_09\/o1_mf_1_31_d9rkq54c_.arc\n<\/pre>\n<h4>Step9:<\/h4>\n<p>List which archives are stored at the location where the archives are stored.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@prmyFS 2017_02_09]$ ls\no1_mf_1_26_d9rkpsn1_.arc  o1_mf_1_29_d9rkpslf_.arc\no1_mf_1_27_d9rkpsl6_.arc  o1_mf_1_30_d9rkpshr_.arc\no1_mf_1_28_d9rkpskd_.arc  o1_mf_1_31_d9rkq54c_.arc\n<\/pre>\n<h4>Step10:<\/h4>\n<p>Check if all of the archives are applied.<\/p>\n<pre class=\"lang:default decode:true \">[Physical] SQL&gt; select sequence#,thread#,archived from v$archived_log order by thread#, sequence#;\n\n SEQUENCE#    THREAD# ARC\n---------- ---------- ---\n        10          1 YES\n        11          1 YES\n        12          1 YES\n        13          1 YES\n        14          1 YES\n        15          1 YES\n        16          1 YES\n        17          1 YES\n        18          1 YES\n        19          1 YES\n        20          1 YES\n\n SEQUENCE#    THREAD# ARC\n---------- ---------- ---\n        21          1 YES\n        22          1 YES\n        23          1 YES\n        24          1 YES\n        25          1 YES\n        26          1 YES\n        27          1 YES\n        28          1 YES\n        29          1 YES\n        30          1 YES\n        31          1 YES\n\n22 rows selected.\n<\/pre>\n<h3>Create Far SYNC Instance For Role Change<\/h3>\n<h4>Step1:<\/h4>\n<p>The first step is the same as the steps for creating a normal Far SYNC Instance.<\/p>\n<h4>Step2:<\/h4>\n<p>Check for an error in the LOG.<\/p>\n<p><span style=\"color: #ff0000;\"><em>PING[ARC2]: Heartbeat failed to connect to standby &#8216;primary&#8217;. Error is 16009.<\/em><\/span><\/p>\n<p>The reason for this error is that FAR SYNC Instance cannot connect to Primary. This error will go away after Role Change. It can be ignored at this stage.<\/p>\n<h4>Step3:<\/h4>\n<p>Check if Standby Redo Logs are created in Far SYNC Instance.<\/p>\n<pre class=\"lang:default decode:true \">[oracle@physclFS physclFS]$ ls -la \/u01\/app\/oracle\/oradata\/physclFS\/\ntotal 9844\ndrwxr-xr-x 2 oracle oinstall     4096 Mar  3 10:11 .\ndrwxr-xr-x 3 oracle oinstall     4096 Mar  3 10:02 ..\n-rw-r----- 1 oracle oinstall 10043392 Mar  3 10:35 physclFS01.ctl<\/pre>\n<p>We have seen that Standby Redo Logs are not created. The reason is that there is no log flow due to the Physical Standby not being in the Primary Role. Standby Redo Log will be created after the role change.<\/p>\n<h4>Step4:<\/h4>\n<p>Check the LOG_ARCHIVE_DEST_n parameters to ensure successful log transfer after Role Exchange.<\/p>\n<pre class=\"lang:default decode:true\">[Physical - 03-03-2017 10:39:50] SQL&gt; show parameter log_archive_dest_2\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_2                   string      SERVICE=physclFS SYNC REOPEN=1\n                                                 5 valid_for=(ONLINE_LOGFILES,P\n                                                 RIMARY_ROLE) db_unique_name=ph\n                                                 ysclFS\n\n[Physical Far SYNC - 03-03-2017 10:40:53] SQL&gt; show parameter log_archive_dest_2\n\nNAME                                 TYPE        VALUE\n------------------------------------ ----------- ------------------------------\nlog_archive_dest_2                   string      SERVICE=primary ASYNC REOPEN=1\n                                                 5 valid_for=(STANDBY_LOGFILES,\n                                                 STANDBY_ROLE) db_unique_name=p\n                                                 rimary\n<\/pre>\n<h4>Step5:<\/h4>\n<p>Check if Physical Standby is suitable for Switchover and perfom switchover operation.<\/p>\n<pre class=\"lang:default decode:true \">[Primary - 03-03-2017 10:41:02] SQL&gt; alter database switchover to 'physical' verify;\n\nDatabase altered.\n\n\n[Primary]-----&gt;ALERT LOG\nFri Mar 03 10:42:20 2017\nalter database switchover to 'physical' verify\nFri Mar 03 10:42:20 2017\nThis is cascading configuration.\nConfiguring a new LOG_ARCHIVE_DEST to switchover target physical.\nUsing STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST\nFri Mar 03 10:42:20 2017\nALTER SYSTEM SET log_archive_dest_31='service=physical ASYNC db_unique_name=physical' SCOPE=MEMORY SID='*';\nSWITCHOVER VERIFY: Send VERIFY request to switchover target physical\nSWITCHOVER VERIFY COMPLETE\nUsing STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST\nFri Mar 03 10:42:20 2017\nALTER SYSTEM SET log_archive_dest_31='' SCOPE=MEMORY SID='*';\nCompleted: alter database switchover to 'physical' verify\nFri Mar 03 10:42:21 2017\nLGWR: Standby redo logfile selected for thread 1 sequence 23 for destination LOG_ARCHIVE_DEST_2\nFri Mar 03 10:42:21 2017\nThread 1 advanced to log sequence 23 (LGWR switch)\n  Current log# 2 seq# 23 mem# 0: \/u01\/app\/oracle\/oradata\/primary\/redo02.log\nFri Mar 03 10:42:21 2017\nArchived Log entry 24 added for thread 1 sequence 22 ID 0x69cd176c dest 1:\n\n\n[Primary Far SYNC]-----&gt;ALERT LOG\nFri Mar 03 10:42:21 2017\nRFS[2]: Selected log 4 for thread 1 sequence 23 dbid 1775091820 branch 937609135\nFri Mar 03 10:42:21 2017\nArchived Log entry 17 added for thread 1 sequence 22 ID 0x69cd176c dest 1:\nFri Mar 03 10:42:21 2017\nTT00: Standby redo logfile selected for thread 1 sequence 23 for destination LOG_ARCHIVE_DEST_2\n\n[Physical]-----&gt;ALERT LOG\nFri Mar 03 10:42:20 2017\nSWITCHOVER VERIFY BEGIN\nSWITCHOVER VERIFY COMPLETE\nFri Mar 03 10:42:21 2017\nArchived Log entry 12 added for thread 1 sequence 22 ID 0x69cd176c dest 1:\nFri Mar 03 10:42:21 2017\nRFS[7]: Selected log 4 for thread 1 sequence 23 dbid 1775091820 branch 937609135\nFri Mar 03 10:42:21 2017\nMedia Recovery Waiting for thread 1 sequence 23 (in transit)\nFri Mar 03 10:42:21 2017\nRecovery of Online Redo Log: Thread 1 Group 4 Seq 23 Reading mem 0\n  Mem# 0: \/u01\/app\/oracle\/oradata\/physical\/stdbyredo01.log<\/pre>\n<h3>Determine Alternative Location If Far SYNC Cannot Receive Instance Redos<\/h3>\n<p>If Far SYNC instance cannot receive Redos due to any situation, we determine Alternative Location to provide High Availability.<\/p>\n<p>Lest test it.<\/p>\n<h4>Step1:<\/h4>\n<p>Check the Broker Configuration.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show configuration\n\nConfiguration - Broker_Configuration\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      physical - Physical standby database \n      logical  - Logical standby database \n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nSUCCESS   (status updated 22 seconds ago)<\/pre>\n<h4>Step2:<\/h4>\n<p>We set MaxFailue property. If we set 1, the Redos are sent to the Alternative Location after 1 failed redo transfer.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; edit far_sync 'prmyFS' set property 'MaxFailure'=1;\nProperty \"MaxFailure\" updated\n<\/pre>\n<h4>Step3:<\/h4>\n<p>Set Alternative Locations.<\/p>\n<pre class=\"lang:default decode:true\">DGMGRL&gt; edit database 'primary' set property 'RedoRoutes'='(LOCAL:prmyFS SYNC ALT=(physical,logical SYNC))';\nError: ORA-16680: value contains unbalanced set of parentheses\n\nFailed.\n<\/pre>\n<p>You will see this error. \ud83d\ude42<\/p>\n<p><em><span style=\"color: #ff0000;\">Error: ORA-16680: value contains unbalanced set of parentheses<\/span><\/em><\/p>\n<p>Set a single Alternative Location.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; edit database 'primary' set property 'RedoRoutes'='(LOCAL:prmyFS SYNC ALT=(physical SYNC))';\nProperty \"RedoRoutes\" updated<\/pre>\n<h4>Step4:<\/h4>\n<p>Set Broker Configuration.<\/p>\n<pre class=\"lang:default decode:true \">DGMGRL&gt; show configuration\n\nConfiguration - Broker_Configuration\n\n  Protection Mode: MaxPerformance\n  Members:\n  primary  - Primary database\n    prmyFS   - Far sync instance \n      physical - Physical standby database \n      logical  - Logical standby database \n        Warning: ORA-16686: database may not receive redo data if redo source is an alternate destination\n\n\n  Members Not Receiving Redo:\n  physclFS - Far sync instance \n\nFast-Start Failover: DISABLED\n\nConfiguration Status:\nWARNING   (status updated 16 seconds ago)<\/pre>\n<p>We came to the end of our article. You can ask your questions as comments.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15099\" class=\"pvc_stats all  \" data-element-id=\"15099\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Far SYNC is a feature introduced with 12c. It is the dummy instance that sends the Redos from the Primary Database to other Standby Databases in the Data Guard configuration. It has only standby control file, password file, standby redo log and archived logs. Since there are no Datafiles on it, there is no Redo &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_15099\" class=\"pvc_stats all  \" data-element-id=\"15099\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":484,"featured_media":15114,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[8925,8938,8943,8941,8940,8950,8944,8948,8949,8959,8956,8955,8921,8932,8934,8937,8960,8920,8929,8930,8933,8923,8924,8954,8939,8958,8936,8942,8945,8931,8926,8935,8927,8928,8953,8952,8951,8946,8947,8957,8922],"class_list":["post-15099","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle","tag-12c-far-sync-standby","tag-active-data-guard-far-sync","tag-alter-database-create-far-sync","tag-create-far-sync","tag-create-far-sync-instance","tag-create-far-sync-instance-for-role-change","tag-creating-far-sync-instance-step-by-step","tag-deleting-archive-log-files-in-far-sync-instance","tag-deleting-unnecessary-archives-in-far-sync-instance","tag-determine-alternative-location","tag-error-ora-16680","tag-error-ora-16680-value-contains-unbalanced-set-of-parentheses","tag-far-sync","tag-far-sync-12c","tag-far-sync-active-data-guard","tag-far-sync-configuration","tag-far-sync-in-oracle","tag-far-sync-in-oracle-12c","tag-far-sync-instance","tag-far-sync-instance-oracle","tag-far-sync-oracle-12c","tag-far-sync-standby","tag-far-sync-standby-database","tag-heartbeat-failed-to-connect-to-standby-primary","tag-how-to-create-far-sync-instance","tag-ora-16680","tag-oracle-12c-active-data-guard-far-sync","tag-oracle-12c-create-far-sync","tag-oracle-12c-data-guard-far-sync","tag-oracle-12c-far-sync-instance","tag-oracle-12c-far-sync-standby","tag-oracle-active-data-guard-far-sync","tag-oracle-data-guard-far-sync-standby","tag-oracle-far-sync-standby","tag-pingarc2","tag-pingarc2-heartbeat-failed-to-connect-to-standby-primary","tag-pingarc2-heartbeat-failed-to-connect-to-standby-primary-error-is-16009","tag-real-time","tag-using-far-sync-instances","tag-value-contains-unbalanced-set-of-parentheses","tag-what-is-far-sync"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Far Sync in Oracle 12c - Database Tutorials<\/title>\n<meta name=\"description\" content=\"Far Sync in Oracle 12c\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Far Sync in Oracle 12c - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"Far Sync in Oracle 12c\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-02T12:05:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-02T12:06:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png\" \/>\n\t<meta property=\"og:image:width\" content=\"539\" \/>\n\t<meta property=\"og:image:height\" content=\"321\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"28 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Far Sync in Oracle 12c\",\"datePublished\":\"2020-03-02T12:05:51+00:00\",\"dateModified\":\"2020-03-02T12:06:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\"},\"wordCount\":1165,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png\",\"keywords\":[\"12c far sync standby\",\"active data guard far sync\",\"alter database create far sync\",\"Create Far SYNC\",\"Create Far SYNC Instance\",\"Create Far SYNC Instance For Role Change\",\"Creating Far Sync instance step by step\",\"Deleting Archive Log files in Far Sync Instance\",\"Deleting Unnecessary Archives in Far SYNC Instance\",\"Determine Alternative Location\",\"Error: ORA-16680\",\"Error: ORA-16680: value contains unbalanced set of parentheses\",\"far sync\",\"far sync 12c\",\"far sync active data guard\",\"far sync configuration\",\"Far Sync in Oracle\",\"far sync in oracle 12c\",\"far sync instance\",\"far sync instance oracle\",\"far sync oracle 12c\",\"far sync standby\",\"far sync standby database\",\"Heartbeat failed to connect to standby 'primary'.\",\"How To Create Far SYNC Instance?\",\"ORA-16680\",\"oracle 12c active data guard far sync\",\"oracle 12c create far sync\",\"ORACLE 12C DATA GUARD: FAR SYNC\",\"oracle 12c far sync instance\",\"oracle 12c far sync standby\",\"oracle active data guard far sync\",\"oracle data guard far sync standby\",\"oracle far sync standby\",\"PING[ARC2]\",\"PING[ARC2]: Heartbeat failed to connect to standby 'primary'.\",\"PING[ARC2]: Heartbeat failed to connect to standby 'primary'. Error is 16009.\",\"REAL-TIME\",\"Using Far Sync Instances\",\"value contains unbalanced set of parentheses\",\"what is far sync\"],\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\",\"name\":\"Far Sync in Oracle 12c - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png\",\"datePublished\":\"2020-03-02T12:05:51+00:00\",\"dateModified\":\"2020-03-02T12:06:48+00:00\",\"description\":\"Far Sync in Oracle 12c\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png\",\"width\":539,\"height\":321},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Far Sync in Oracle 12c\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Far Sync in Oracle 12c - Database Tutorials","description":"Far Sync in Oracle 12c","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:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/","og_locale":"en_US","og_type":"article","og_title":"Far Sync in Oracle 12c - Database Tutorials","og_description":"Far Sync in Oracle 12c","og_url":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/","og_site_name":"Database Tutorials","article_published_time":"2020-03-02T12:05:51+00:00","article_modified_time":"2020-03-02T12:06:48+00:00","og_image":[{"width":539,"height":321,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"28 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Far Sync in Oracle 12c","datePublished":"2020-03-02T12:05:51+00:00","dateModified":"2020-03-02T12:06:48+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/"},"wordCount":1165,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png","keywords":["12c far sync standby","active data guard far sync","alter database create far sync","Create Far SYNC","Create Far SYNC Instance","Create Far SYNC Instance For Role Change","Creating Far Sync instance step by step","Deleting Archive Log files in Far Sync Instance","Deleting Unnecessary Archives in Far SYNC Instance","Determine Alternative Location","Error: ORA-16680","Error: ORA-16680: value contains unbalanced set of parentheses","far sync","far sync 12c","far sync active data guard","far sync configuration","Far Sync in Oracle","far sync in oracle 12c","far sync instance","far sync instance oracle","far sync oracle 12c","far sync standby","far sync standby database","Heartbeat failed to connect to standby 'primary'.","How To Create Far SYNC Instance?","ORA-16680","oracle 12c active data guard far sync","oracle 12c create far sync","ORACLE 12C DATA GUARD: FAR SYNC","oracle 12c far sync instance","oracle 12c far sync standby","oracle active data guard far sync","oracle data guard far sync standby","oracle far sync standby","PING[ARC2]","PING[ARC2]: Heartbeat failed to connect to standby 'primary'.","PING[ARC2]: Heartbeat failed to connect to standby 'primary'. Error is 16009.","REAL-TIME","Using Far Sync Instances","value contains unbalanced set of parentheses","what is far sync"],"articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/","url":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/","name":"Far Sync in Oracle 12c - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png","datePublished":"2020-03-02T12:05:51+00:00","dateModified":"2020-03-02T12:06:48+00:00","description":"Far Sync in Oracle 12c","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2020\/03\/Ads\u0131z.png","width":539,"height":321},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2020\/03\/02\/far-sync-in-oracle-12c\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Far Sync in Oracle 12c"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=15099"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/15099\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/15114"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=15099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=15099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=15099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}