How to disable active data guard permanently?
Hi All, I'm testing on 11gr2 Active Data Guard, found that whenever I switch off the the Active Data Guard as below:
--start--
On Standby DB:
i) SQL>alter database recover managed standby database cancel;
ii) SQL> alter system set log_archive_dest_state_2=DEFER;
On Primary DB:
i) SQL> alter system set log_archive_dest_state_2=DEFER;
---end--
It will switch back to Active Data Guard mode after I perform a db bounce (shutdown immediate then startup) at standby server. Any Idea?
Thanks.