# primary节点
--切换为standby
SQL> alter database commit to switchover to physical standby;
SQL> shutdown immediate;
SQL> startup;
--开启redo应用
SQL> alter database recover managed standby database using current logfile disconnect from session;
SQL> select db_unique_name,database_role,protection_mode,protection_level,open_mode,switchover_status from v$database;
# standby 节点
--切换为primary
SQL> alter database commit to switchover to primary;
SQL> shutdown immediate
SQL> startup
SQL> alter system switch logfile;
SQL> select db_unique_name,database_role,protection_mode,protection_level,open_mode,switchover_status from v$database;
升为主库后，SWITCHOVER_STATUS 状态依次为：
1）RESOLVABLE GAP
2）TO STANDBY
3）SESSIONS ACTIVE

ITPub博客

ora11_node_dg（2）ADG做(switchover)切换测试