12c DataGuard switchover to 'primary'

I. description of the environment

Oracle 12c

RHEL 7

II. Operation

Note: the switch needs to be performed on the physical standby node because the primary node needs to be restarted.

1. View configuration

DGMGRL > show configuration;Configuration-dg_config Protection Mode: MaxAvailability Members: orcl-Primary database orcldg-Physical standby database Fast-Start Failover: DISABLEDConfiguration Status:SUCCESS (status updated 30 seconds ago)

two。 Verify the main library

DGMGRL > validate database orcl; Database Role: Primary database Ready for Switchover: Yes Flashback Database Status: orcl: Off

3. Verify the physical repository

DGMGRL > validate database orcldg; Database Role: Physical standby database Primary Database: orcl Ready for Switchover: Yes Ready for Failover: Yes (Primary Running) Flashback Database Status: orcl: Off orcldg: On Standby Apply-Related Information: Apply State: Running Apply Lag: 13 hours 29 minutes 48 seconds (computed 1 second ago) Apply Delay: 0 minutes

4. Make a switch

DGMGRL > switchover to orcldg;Performing switchover NOW, please wait...New primary database "orcldg" is opening...Oracle Clusterware is restarting database "orcl"... ORA-01017: invalid username/password; logon deniedWarning: You are no longer connected to ORACLE. Shut down instance "orcl" of database "orcl" start up instance "orcl" of database "orcl"

5. Confirm after switching

DGMGRL > show configuration;Configuration-dg_config Protection Mode: MaxAvailability Members: orcldg-Primary database orcl-Physical standby database Fast-Start Failover: DISABLEDConfiguration Status:SUCCESS (status updated 30 seconds ago) DGMGRL >