ORA-10456的解决办法

jiawang

报错现象：
SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> alter database open；
alter database open
*
第 1 行出现错误:
ORA-10456: cannot open standby database; media recovery session may be in
progress


报错原因：恢复模式不可打开数据库   所以先要cancel日志应用，在开启日志应用。
解决办法：
SQL> alter database recover managed standby database cancel;
Database altered.

SQL> alter database open;
Database altered.

SQL> alter database recover managed standby database using current logfile disconnect ;
Database altered.

SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ ONLY WITH APPLY