High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

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.

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