Turn off one archive log dest in 11g?
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