rman完成主庫到備庫的恢復(fù)后，在備庫運(yùn)行alter database open；報錯：ORA-10456: cannot open standby database;

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-10456: cannot open standby database;media recovery session may be in

progress

解決辦法：
1.停止備庫的日志應(yīng)用

SQL> alter database recover managedstandby database cancel;

Database altered.

2.打開備庫

SQL> alter database open;

Database altered.

3.備庫應(yīng)用日志

SQL> Alter database recover managedstandby database using current logfile disconnect from session;

Database altered.

4.查看備庫狀態(tài)

SQL> select open_mode from v$database;

OPEN_MODE

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

READ ONLY WITH APPLY