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

MOSC Banner

Switchover procedure when using Active Data Guard feature

We recently licensed the Active Data Guard (ADG) feature for Oracle 11.1.0.7. Active Data Guard allows a physical standby to be open in read-only mode and running real-time redo apply at the same time. I am wondering if the use of ADG requires a change to the procedure to perform a switchover or role-reversal of the primary and standby databases.

Without ADG, the standby would be mounted and closed with managed recovery running in background. During a switchover, the primary is first converted to a standby and then the "old" standby is converted to a primary by executing:

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;

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