重庆思庄oracle技术分享-ORA-10456:无法打开备用数据库

rman完成主库到备库的恢复后，在备库运行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.停止备库的日志应用

SQL> alter database recover managedstandby database cancel;

Database altered.

2.打开备库

SQL> alter database open;

Database altered.

3.备库应用日志

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

Database altered.

4.查看备库状态

SQL> select open_mode from v$database;

OPEN_MODE

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

READ ONLY WITH APPLY