oracle DG GAP问题解决

备库意外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'