Database Administration (MOSC)

MOSC Banner

Archive Log Mirroring on 11g

edited Jun 8, 2016 5:04AM in Database Administration (MOSC) 4 commentsAnswered

Hi,

I have a simple question hopefully.

I want the ability to mirror my archive logs to both a local drive and network share.

My plan is to

Primary location will be d:\oracle\flash_recovery\test....

ALTER SYSTEM set LOG_ARCHIVE_DUPLEX_DEST = ‘location=\\<remote_location>\archivelog\test’  --> Backup location

alter system set log_archive_min_succeed_dest = 2;   --> From reading up on this it will mean both locations must be written to.

ALTER SYSTEM SET ARCHIVE_LAG_TARGET = 3600 SCOPE=BOTH;  --> Force hourly log switches.

My question is what happens if the network location goes down.  I assume the database hangs until the location is available.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center