how to unset log_archive_dest_2 parameter in RAC database
772262Mar 8 2011 — edited Mar 8 2011Hello All,
I have standby database setup and using log_archive_dest_2 parameter to ship archive logs to standby. I want to shutdown standby database.
My primary database is 2 node RAC 11g database.
Please can I know how to unset log_archive_dest_2 parameter.
Currently the parameter is set as :-
NAME TYPE VALUE
--------------------------------------------------------------------------------
-----------
--------------------------------------------------------------------------------
log_archive_dest_2 string SERVICE=MDM2 SYNC VALID_FOR=(O
NLINE_LOGFILES,PRIMARY_ROLE) D
B_UNIQUE_NAME=MDM2
thanks.