Showing posts from November, 2016

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 SQLIf you do not use Data Guard Broker (dgmgrl), use the parameters specified below. ·Primary On the Primary Database Mandatory ParametersParameter 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 should not be too high, because the connection must fail after n attempts and fail over to the next destination, specified in …