3

I need to enable archivelog. But sometimes database can't connect archivelog destination (NFS disk) and shutdowns. I can set two archivelog destinations and one of them is not NFS disk (local disk).

How can I configure, if database can't connect to NFS disk (dest1), to just write on local disk (dest2) and continue to work?

Thank you.

  • Ideally you should use reliable storage for your archivelog destination – Andrew Brennan Nov 14 '16 at 10:48
3

You can use ALTERNATE attribute in second archive log destination.

ALTERNATE

Specifies an alternate archiving destination to be used when the original destination fails.

Example:

LOG_ARCHIVE_DEST_1='LOCATION=/disk1 MANDATORY ALTERNATE=LOG_ARCHIVE_DEST_2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_2='LOCATION=/disk2 MANDATORY'
LOG_ARCHIVE_DEST_STATE_2=ALTERNATE

Reference: LOG_ARCHIVE_DEST_n Parameter Attributes

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.