Home > Oracle in general > Less know features: Alternate Archive Log Destination

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.

Categories: Oracle in general Tags:
  1. No comments yet.
  1. No trackbacks yet.