Database Administration (MOSC)

MOSC Banner

Adding another archive log destination

edited Jan 15, 2009 1:13AM in Database Administration (MOSC) 3 comments
Hi

I want to add another archivelog destination incase a archivelog gets corrupted or lost. I wish to use a NFS fileserver for this.

Anyone done this before? Is it something Oracle supports?. Any known problems if the fileserver goes down or loose connectivity?(LGWR crash?)

I don't have the fileserver up yet so unable to test. Think i'll use something like this:

NFS mount options

rw,bg,hard,nointr,tcp,vers=3,timeo=600,rsize=32768,wsize=32768,actimeo=0

Oracle Parameters

log_archive_min_succeed_dest=1

log_archive_dest_2='location=/net/filserv/archive2'

log_archive_dest_10=USE_DB_RECOVERY_FILE_DEST <- default

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