BRARCHIVE - save logs from Alternate location

[former_member61236]

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

[former_member188883]

Hi Wei Liang,

You may use brtools to backup archive logs located at 2 locations ( one after the other). You may need to change the archive destination and run backup.

Secondly using RMAN you can do that. Refer link https://forums.oracle.com/forums/thread.jspa?threadID=2492579

Thirdly to avoid log directory full situation you may use brrachive with -f option which will continuously backup log files created into tape device. Refer SAP help for more details.

http://help.sap.com/saphelp_nwpi71/helpdata/en/47/28a4966ad85f7fe10000000a1553f6/content.htm

Regards,

Deepak Kori

[former_member61236]

Hi Deepak,

Could you share more info on how do I get brarchive to backup both locations? Thanks

[former_member188883]

Hi Wei Lang,

Backing up archive logs from 2 locations simultaneously is not possible using brarchive.

You need to perform these operations one after the other and that too using brtools where you can change the archive location path without having to change initSID.sap .

Regards,

Deepak Kori