dg主备库切换步骤

先将主库切换成备库，然后将原主库启动到物理库的状态

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS
--------------------
TO STANDBY


SQL> Alter database commit to switchover to physical standby with session shutdown;


Database altered.


SQL> shut immediate
ORA-01507: database not mounted




ORACLE instance shut down.
SQL> startup nomount
ORACLE instance started.


Total System Global Area  304807936 bytes
Fixed Size                  2212856 bytes
Variable Size             176163848 bytes
Database Buffers          121634816 bytes
Redo Buffers                4796416 bytes
SQL> alter database mount standby database;


Database altered.


SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE