重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-10456的解决办法 [打印本页]

作者: jiawang 时间: 2018-11-19 10:19
标题: ORA-10456的解决办法
报错现象：
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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)