1.确保主库的所有日志文件都刷到备库
查询备库的v$archived_log视图。
SQL> select sequence#,applied from v$archived_log;
SEQUENCE# APPLIED
---------- ---------
48 YES
49 YES
50 YES
51 YES
52 YES
53 YES
55 YES
54 YES
56 YES
57 YES
58 YES
SEQUENCE# APPLIED
---------- ---------
59 YES
60 YES
61 YES
62 YES
63 YES
64 YES
65 YES
66 YES
19 rows selected.
2.查看备库可以切换的状态
查询备库v$database视图。
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
TO PRIMARY
3.查看主库可以切换的状态
查询主库v$databse视图。
SQL> select switchover_status from v$database;
SWITCHOVER_STATUS
--------------------
SESSIONS ACTIVE
4.将主库切换成备库
SQL> alter database commit to switchover