Switchover with Data Guard Broker
DGMGRL>
DGMGRL>
DGMGRL> show configuration;
Configuration - prod_ddb
Protection Mode: MaxPerformance
Members:
ddb - Primary database
ddb_dr - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 11 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> switchover to ddb_dr
Performing switchover NOW, please wait...
Operation requires a connection to database "ddb_dr"
Connecting ...
Connected to "ddb_dr"
Connected as SYSDBA.
New primary database "ddb_dr" is opening...
Operation requires start up of instance "ddb" on database "ddb"
Starting instance "ddb"...
Connected to an idle instance.
ORACLE instance started.
Connected to "ddb"
Database mounted.
Connected to "ddb"
Switchover succeeded, new primary is "ddb_dr"
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - prod_ddb
Protection Mode: MaxPerformance
Members:
ddb_dr - Primary database
ddb - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 78 seconds ago)
DGMGRL>
DGMGRL>
DGMGRL> switchover to ddb
Performing switchover NOW, please wait...
Operation requires a connection to database "ddb"
Connecting ...
Connected to "ddb"
Connected as SYSDBA.
New primary database "ddb" is opening...
Operation requires start up of instance "ddb_dr" on database "ddb_dr"
Starting instance "ddb_dr"...
Connected to an idle instance.
ORACLE instance started.
Connected to "ddb_dr"
Database mounted.
Connected to "ddb_dr"
Switchover succeeded, new primary is "ddb"
DGMGRL>
DGMGRL>
DGMGRL>
DGMGRL> show configuration
Configuration - prod_ddb
Protection Mode: MaxPerformance
Members:
ddb - Primary database
ddb_dr - Physical standby database
Fast-Start Failover: Disabled
Configuration Status:
SUCCESS (status updated 77 seconds ago)
DGMGRL>
No comments:
Post a Comment