Dataguard Broker Switchover

The steps to perform a switch over using dataguard broker are very simple you just need to do the following:

1. Connect to dgmgrl and make sure the configuration status = SUCCESS
2. Connect to the standby database as sys using the SID
3. Then use the command switchover to “XXXXX” where XXXXX is your standby database you wish to switch over to

See the below for the output.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s