Skip to Content
0
Former Member
Mar 11, 2013 at 02:57 AM

BRARCHIVE - save logs from Alternate location

293 Views

Hi All!

I've set the following to prevent the DB from freezing if ever the log files overflows.

LOG_ARCHIVE_DEST_1 = LOCATION=/oracle/(SID)/oraarch/(SID)archMANDATORY MAX_FAILURE=1 REOPEN=300 ALTERNATE=LOG_ARCHIVE_DEST_2

LOG_ARCHIVE_DEST_2 = LOCATION=/oracle/(SID)/oraarch-overflow/(SID)arch MANDATORY

LOG_ARCHIVE_DEST_STATE_1 = ENABLE

LOG_ARCHIVE_DEST_STATE_2 = ALTERNATE

Got 2 questions

  1. How do I set BRARCHIVE to backup both locations
  2. Once BRARCHIVE completes the backup and deletes the logs, how do I go back to LOG_ARCHIVE_DEST_1

Thanks in advance 😊