This content has been marked as final. Show 2 replies
What I know about RESET is, if you want to use the default value of the parameter that has been changed, you must reset it.
I thinking you changed it to DEFER and after the shutdown Broker ( educated guess ) reset it.
alter system reset parameter scope...
Found this note :
Log_archive_dest_state_2 Automatically Set To RESET Causing Standy Database To Fall Out Of Sync [ID 1470986.1]
( looks like I should report a typo to Oracle )
Edited by: mseberg on Apr 3, 2013 2:38 PM