ALTERNATE Attribute of LOG_ARCHIVE_DEST_n Does Not Appear to Work
(Doc ID 369120.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.5 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A 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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document