备库意外down之后启动状态到mount,由于没有到read only状态,所以备库无法查询
1.select * from v$archive_gap;查询没有返回
2.查看主备库的日志sequence号是否同步
select open_mode,protection_mode,database_role,switchover_status from v$database;
select process,client_process,sequence#,status from v$managed_standby;
状态检查是正常
这一步其实能从rfs,mrp进程状态中看出来存在日志无法正常应用的情况
3.此时数据库是mount状态,手动open,发现报错
ORA-10456: cannot open standby database; media recovery session may be in progress
显示需要进行介质恢复,同时alert日志中应该也有相应的显示
执行
alter database recover managed standby database cancel;
alter database open;
(alter 日志中显示会进行alter database recover managed standby database disconnect from session; 操作)
之后报的错误是:
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/u01/app/oracle/oradata/rong/system01.dbf'