Database Administration (MOSC)

MOSC Banner

Should LOG_ARCHIVE_DEST_1 be set as DB_RECOVERY_FILE_DEST?

edited May 26, 2009 1:29AM in Database Administration (MOSC) 4 commentsAnswered ✓
 Hi,

Oracle recommends LOG_ARCHIVE_DEST_1 to be the same location as DB_RECOVERY_FILE_DEST for recovery reason.

"Oracle also recommends that you configure the database to write archived redo log files to the flash recovery area." - from Oracle 2 Day DBA document

To avoid manual deletion on files other than old archived redo log files by accident, is it possible to assign a different location to LOG_ARCHIVE_DEST_1?  Are there any drawbacks for doing so?  Oracle should know where to find the archived redo log files given LOG_ARCHIVE_DEST_1, right?

Thanks,

Simon

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