Database Backup and Recovery (MOSC)

MOSC Banner

RMAN Recovery and Archive Log naming convention

edited Jan 13, 2013 11:11PM in Database Backup and Recovery (MOSC) 3 commentsAnswered

Hello

We are trying to ADD another destination for our archive logs
Ours is a 10g RAC database and it has 2 nodes
LOG_ARCHIVE_DEST_1 is set to +FRA

we want to have the archive log created on to linux file system as well besides the +FRA, so that if we loose +FRA disk group, we still would have a copy of archive log on local file system for recovery

we created local folder as '/u01/localarclog' on each node and then

We added LOG_ARCHIVE_DEST_2 --> alter system set log_archive_dest_2='LOCATION=/u01/localarclog/' ;

We then performed a log switch on each instance and verified that the archive log was created / generated on the local file system as well besides the +FRA disk group. But there is a discrepancy in the

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