patternMinor
Archivelog redundancy
Viewed 0 times
archivelogredundancystackoverflow
Problem
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.
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.
Solution
You can use
ALTERNATE
Specifies an alternate archiving destination to be used when the original destination fails.
Example:
Reference:
LOG_ARCHIVE_DEST_n Parameter Attributes
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=ALTERNATEReference:
LOG_ARCHIVE_DEST_n Parameter Attributes
Code Snippets
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=ALTERNATEContext
StackExchange Database Administrators Q#154784, answer score: 3
Revisions (0)
No revisions yet.