Daraguard异常断电启动失败的恢复

一次因异常停电，导致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/