Redo data should be received by all destinations before the commit is complete.
Redo data need not be received by all destinations for commit to complete.
SYNC is not supported by destinations LOG_ARCHIVE_DEST_11 to LOG_ARCHIVE_DEST_31
FOR INFO ONLY : ALTER SYSTEM SET log_archive_dest_2='SERVICE=dosa1 LGWR SYNC AFFIRM COMPRESSION=ENABLE DB_UNIQUE_NAME=dosa1';
Used only when redo transport service uses ARCH. Valid values : 1 - 5. Depends on LOG_ARCHIVE_MAX_PROCESSES
if set, real-time Redo Apply will not be used.
MAX_FAILURE (also need to set REOPEN)
These many attempts will be done to connect to destination before giving up.
Need to set REOPEN clause. after attemtping MAX_FAILURE attempts, REOPEN clause will be set to 0. Then redo transport will to be destination
specified in ALTERNATE attribute. Destination for LOG_ARCHIVE_DEST_1 to LOG_ARCHIVE_DEST_10 can contain either LOCATION or SERVICE.
But, destination for LOG_ARCHIVE_DEST_11 to LOG_ARCHIVE_DEST_31 can contain only SERVICE.
will reopen the failed connection
used with SYNC redo transport mode.
will wait for acknowledgement from redo transport destination.
if not recieved, the redo transort session for the destination is terminated.
Default value = 30 seconds.
set the delay between primary and standby database
SQL> ALTER SYSTEM SET log_archive_dest_2='SERVICE=dosa1 LGWR SYNC AFFIRM REOPEN=20 NET_TIMEOUT=30 DELAY=10 DB_UNIQUE_NAME=dosa1';