Less know features: Alternate Archive Log Destination

Oracle offers the ability to specify so called ‘alternative’ archive log destinations in case the primary archive log destination gets full. You can enable this feature by setting:

log_archive_dest_1='location=+FRA REOPEN=0 MANDATORY alternate=log_archive_dest_2'
log_archive_dest_2='location=/some_path MANDATORY'
log_archive_dest_state_1=ENABLE
log_archive_dest_state_2=ALTERNATE

A configuration often used involved using the flash recovery area as primary destination and a nfs destination as alternative archive log destination.

This entry was posted in Oracle in general. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *