如果SWITCHOVER_STATUS= TO PRIMARY

备库可以顺利切换到主库

如果SWITCHOVER_STATUS=sessions active

表示当前仍然活动会话在进行，

这是你可以添加“WITH SESSION SHUTDOWN”关键字在ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY语句之后进行强制关闭会话，

如果不加alert_LEO.log里有If media recovery active, switchover will wait 900 seconds你需要等待900秒的时间，

这只是一个估计值，实际上时间会更长

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

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

NOT ALLOWED

SQL> /

SWITCHOVER_STATUS

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

NOT ALLOWED

SQL> alter database commit to switchover to primary;

alter database commit to switchover to primary

*

ERROR at line 1:

ORA-16139: media recovery required

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

…

出現長時間等待，不能執行完成。

檢查alert.log記錄If media recovery active, switchover will wait 900 seconds.

試著等待900 seconds後，情況依然。

SQL> alter database recover managed standby database finish force;

Database altered.

SQL> select switchover_status from v$database;

SWITCHOVER_STATUS

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

TO PRIMARY

SQL> alter database commit to switchover to primary;

Database altered.

大功告成。

ITPub博客

ORA-16139: media recovery required