Database Administration (MOSC)

MOSC Banner

Turn off one archive log dest in 11g?

edited Jun 27, 2012 11:32PM in Database Administration (MOSC) 3 commentsAnswered
Hi,

Is it possible that dynamically turn off one archive destination? Something like this:

alter system set log_archive_dest_2=disable scope=memory;


ORA-02097: parameter cannot be modified because specified value is invalid
ORA-16024: parameter LOG_ARCHIVE_DEST_2 cannot be parsed

EDIT: well, I found out the command is =defer

But that will only work until my dest 1 is full. This is only test so I will reset the dest instead.

Regards

U

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