Using Standby as an Alternate for Far Sync (12c): Limitations and Considerations
Based on Oracle 12.1 The Recommended Data Guard configuration is in Maximum Availability mode, when using Far Sync which is located near the Primary: Primary Database à Far Sync Instance - Network input/output (I/O) is synchronous (Sync). Far Sync Instance à Standby Database – Network I/O is asynchronous (Async). Primary Database à Standby Database – As an alternate (when Far Sync is not reachable), network I/O is asynchronous (Async). Using SQL If you do not use Data Guard Broker (dgmgrl), use the parameters specified below. · Primary On the Primary Database Mandatory Parameters Parameter Value Remarks LOG_ARCHIVE_DEST_2 point to Far Sync service Alternate log_archive_dest_3 Switches to the standby destination, after the number of failures specified in the next parameter is reached. max_failure 1 This value must be higher than 0 (infinite number of retries), but shoul