一次因异常停电,导致oracle数据库备库,Dataguard数据库启动失败!
Standby crash recovery aborted due to error 16016.
Errors in file /opt/app/oracle/diag/rdbms/zonedbdg/zonedbdg/trace/zonedbdg_ora_6788.trc:
ORA-16016: archived log for thread 1 sequence# 1426 unavailable
Recovery interrupted!
Some recovered datafiles maybe left media fuzzy
Media recovery may continue but open resetlogs may fail
Completed standby crash recovery.
Errors in file /opt/app/oracle/diag/rdbms/zonedbdg/zonedbdg/trace/zonedbdg_ora_6788.trc:
ORA-10458: standby database requires recovery
ORA-01196: file 1 is inconsistent due to a failed media recovery session
ORA-01110: data file 1: '/oradata/zonedbdg/system01.dbf'
ORA-10458 signalled during: ALTER DATABASE OPEN...
发现1426 sequence#获取不到,不能恢复。
开始检查备库和主库,均没有该文件,则在主库使用alter system switch logfile;进行切换。
发现sequence# 1426的归档日志已经在主库归档目录生成。
archived log '/fra/ZONEDBDG/archivelog/2012_04_19/o1_mf_1_1426_%u_.arc'
然后再执行恢复;启动dataguard成功。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/88305/viewspace-722312/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/88305/viewspace-722312/