#切换测试--DG做(switchover)切换测试--

#主库

[oracle@DB196 ~]$ sqlplus / as sysdba

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

SQL> shutdown immediate

ORA-01012: not logged on

SQL> conn / as sysdba

SQL> shutdown immediate

ERROR: ORA-01034: ORACLE not available

SQL> startup

SQL> alter database recover managed standby database using current logfile disconnect from session;

SQL> select database_role,switchover_status from v$database;

PHYSICAL STANDBY        TO PRIMARY

SQL> archive log list;

---------------------------------------------

#备库

[oracle@DB197 ~]$ sqlplus / as sysdba

SQL> alter database commit to switchover to primary with session shutdown;

SQL> shutdown immediate

ORA-01109: database not open

SQL> startup

SQL> alter system switch logfile;

SQL> select database_role,switchover_status from v$database;

PRIMARY           TO STANDBY

SQL> archive log list;

#至此切换已完成

#第二轮切换开始

#新主库（原备机）

[oracle@DB197 ~]$ sqlplus / as sysdba

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

SQL> shutdown immediate

ORA-01012: not logged on

SQL> conn / as sysdba

SQL> shutdown immediate

ERROR: ORA-01034: ORACLE not available

SQL> startup

SQL> alter database recover managed standby database using current logfile disconnect from session;

SQL> select database_role,switchover_status from v$database;

PHYSICAL STANDBY        TO PRIMARY

SQL> archive log list;

-------------------------------------------------

#新备库（原主机）

[oracle@DB196 ~]$ sqlplus / as sysdba

SQL> alter database commit to switchover to primary with session shutdown;

SQL> shutdown immediate

ORA-01109: database not open

SQL> startup

SQL> alter system switch logfile;

SQL> select database_role,switchover_status from v$database;

PRIMARY           TO STANDBY

SQL> archive log list;