My Oracle Support Banner

ALTERNATE Attribute of LOG_ARCHIVE_DEST_n Does Not Appear to Work (Doc ID 369120.1)

Last updated on FEBRUARY 19, 2019

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.



Symptoms

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).

For example:

Set the following and simulate an out of space condition for the LOG_ARCHIVE_DEST_1 directory.

Parameters:

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.

Cause

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
Symptoms
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.