ORA-16456: switchover to standby in progress or completed

来源:互联网 发布:sql二进制数据 计算符 编辑:程序博客网 时间:2024/05/29 17:25
SQL> SELECT SWITCHOVER_STATUS FROM V$DATABASE;


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


SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;


Database altered.


SQL> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN
*
ERROR at line 1:
ORA-16456: switchover to standby in progress or completed


备库必须mount状态下,主库open状态


查看备库是

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
READ ONLY WITH APPLY

阅读全文
0 0
原创粉丝点击