How to do a switchover with Data guard Broker
Below you can see i have primary database prod and standby database sby1, so in this demo we will switchover where standby (sby1) becomes primary and primary (prod) becomes standby
DGMGRL> show configuration
Configuration - dgconf1
Protection Mode: MaxPerformance
Databases:
prod - Primary database
sby1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to sby1;
Performing switchover NOW, please wait...
New primary database "sby1" is opening...
Operation requires shutdown of instance "prod" on database "prod"
Shutting down instance "prod"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "prod" on database "prod"
Starting instance "prod"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "sby1"
DGMGRL>
DGMGRL> show configuration
Configuration - dgconf1
Protection Mode: MaxPerformance
Databases:
sby1 - Primary database
prod - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Below you can see i have primary database prod and standby database sby1, so in this demo we will switchover where standby (sby1) becomes primary and primary (prod) becomes standby
DGMGRL> show configuration
Configuration - dgconf1
Protection Mode: MaxPerformance
Databases:
prod - Primary database
sby1 - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
DGMGRL> switchover to sby1;
Performing switchover NOW, please wait...
New primary database "sby1" is opening...
Operation requires shutdown of instance "prod" on database "prod"
Shutting down instance "prod"...
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Operation requires startup of instance "prod" on database "prod"
Starting instance "prod"...
ORACLE instance started.
Database mounted.
Switchover succeeded, new primary is "sby1"
DGMGRL>
DGMGRL> show configuration
Configuration - dgconf1
Protection Mode: MaxPerformance
Databases:
sby1 - Primary database
prod - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
SUCCESS
Nice post.
ReplyDeleteWould have been nice if it was possible to subscribe by mail to receive new post notifications from your blog.
Kind regards,
Foued