ALTERNATE Attribute of LOG_ARCHIVE_DEST_n Does Not Appear to Work
Last updated on SEPTEMBER 12, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.5 and later
Information in this document applies to any platform.
Oracle is not archiving to the ALTERNATE destination (when LOG_ARCHIVE_DEST_STATE_n=ALTERNATE is set), even though it is failing to archive to the default destination (LOG_ARCHIVE_DEST_1).
Set the following and simulate an out of space condition for the LOG_ARCHIVE_DEST_1 directory.
log_archive_dest_1 = 'LOCATION=/opt/oracle/u02/oradata/DOKP/arch REOPEN=3 MAX_FAILURE=5 ALTERNATE=LOG_ARCHIVE_DEST_2'
log_archive_dest_2 = 'LOCATION=/opt/oracle/u03/oradata/DOKP/arch REOPEN=3 MAX_FAILURE=5'
log_archive_dest_state_1 = ENABLE
log_archive_dest_state_2 = ALTERNATE
Observe in the alert.log file that Oracle is failing to archive to the LOG_ARCHIVE_DEST_1 destination, as expected, but does not try to archive to the ALTERNATE destination.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms