Data Guard Switchover

In the current DR environment,  primary database is ‘DB11R2’ and physical standby is ‘DB11R2DR’.


DGMGRL> show configuration;

Configuration - DB11R2_DG_CONFIG

 Protection Mode: MaxPerformance
 Databases:
 DB11R2   - Primary database
 DB11R2DR - Physical standby database
 DB11R2LS - Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

Now swithover primary database and physical standby database. The switchover operation may take a while to complete. Monitor alert.log for details.

DGMGRL> switchover to 'DB11R2DR';
Performing switchover NOW, please wait...
New primary database "DB11R2DR" is opening...
Operation requires shutdown of instance "DB11R2" on database "DB11R2"
Shutting down instance "DB11R2"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "DB11R2" on database "DB11R2"
Starting instance "DB11R2"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "DB11R2DR"

The switchover is completed successfully. Check current configuration.


DGMGRL> show configuration;

Configuration - DB11R2_DG_CONFIG

 Protection Mode: MaxPerformance
 Databases:
 DB11R2DR - Primary database
 DB11R2   - Physical standby database
 DB11R2LS - Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:
ORA-16610: command "Broker automatic health check" in progress
DGM-17017: unable to determine configuration status

DGMGRL> show configuration;

Configuration - DB11R2_DG_CONFIG

 Protection Mode: MaxPerformance
 Databases:
 DB11R2DR - Primary database
 DB11R2   - Physical standby database
 DB11R2LS - Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

Now switch back to its original configuration


DGMGRL> switchover to 'DB11R2';
Performing switchover NOW, please wait...
New primary database "DB11R2" is opening...
Operation requires shutdown of instance "DB11R2DR" on database "DB11R2DR"
Shutting down instance "DB11R2DR"...
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "DB11R2DR" on database "DB11R2DR"
Starting instance "DB11R2DR"...
ORACLE instance started.
Database mounted.
Database opened.
Switchover succeeded, new primary is "DB11R2"

Check current configuration


DGMGRL> show configuration;

Configuration - DB11R2_DG_CONFIG

 Protection Mode: MaxPerformance
 Databases:
 DB11R2   - Primary database
 DB11R2DR - Physical standby database
 DB11R2LS - Logical standby database

Fast-Start Failover: DISABLED

Configuration Status:
SUCCESS

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: