Database Administration (MOSC)

MOSC Banner

Moving archive dest

edited Jan 4, 2011 7:12PM in Database Administration (MOSC) 3 commentsAnswered
 Dear all,

I recently try to have an alternate location for archive file - so that when the default enabled location cannot be accessed, the archive file will automatically written to the alternate directory. here is what I have done:

log_archive_dest_1                   string      location=/usr/arch/ MANDATORY REOPEN=3 MAX_FAILURE=3 ALTERNATE=LOG_ARCHIVE_DEST_2
log_archive_dest_2                   string      location=/u01/arch MANDATOR

log_archive_dest_state_1             string      ENABLE
log_archive_dest_state_2             string      ALTERNATE


The setting above works well - my quetsion is, how would you move the archive destination from the alternative location (i.e. log_archive_dest_2) back to the main location (i.e. log_archive_dest_1) with no system shutdown?

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