Database Administration (MOSC)

MOSC Banner

DB Startup fails if optional log_archive_dest is not found

edited Apr 27, 2011 6:58AM in Database Administration (MOSC) 3 commentsAnswered ✓
Server: Windows Server 2003 R2 DB: Oracle 10.2.0.4

Last month, in order to provide a little extra backup, I started duplexing my archive logs on a couple of databases - so that I'd have my local copies and then I was shooting a separate copy out to the file server.

I set the following parameters:

log_archive_dest_1='location=use_recovery_file_dest'
log_archive_dest_2='location=\\fsv01\backups\prod\archive'

Things have been working very well ... right up until we had our monthly maintenance on Saturday.

The DB Server came up before the file server.  When the services started and tried to start the database I got errors stating that log_archive_dest_2 couldn't be translated and the database didn't start.

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