HiveBrain v1.2.0
Get Started
← Back to all entries
patternMinor

Archivelog redundancy

Submitted by: @import:stackexchange-dba··
0
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.

Solution

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

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=ALTERNATE

Context

StackExchange Database Administrators Q#154784, answer score: 3

Revisions (0)

No revisions yet.