物理Data Guard 下Failover 时Redo 的处理问题(二)

2014-11-24 17:59:07 · 作者: · 浏览: 5
andby database until cancel;


ORA-00279: change 509016 generated at 11/05/2010 11:40:27 needed for thread 1


ORA-00289: suggestion : /u01/archive/1_17_734225750.dbf


ORA-00280: change 509016 for thread 1 is in sequence #17


-- 默认情况下会提示需要归档17 实际上这个序列为17的归档还没有生成,我们忽略它,使用我们刚才copy过来的redo 日志来恢复。



Specify log: {=suggested | filename | AUTO | CANCEL}


/u01/app/oracle/oradata/orcl/redo01.log -- 注意, 这个位置是我手动写的


Log applied.


Media recovery complete.



--这里是运气好,一次就搞定了。 实际上有三个redo,我们也是不确定使用哪个redo的,只能一个一个试了。



SQL> recover standby database until cancel;


ORA-00279: change 509209 generated at 11/05/2010 11:46:35 needed for thread 1


ORA-00289: suggestion : /u01/archive/1_17_734225750.dbf


ORA-00280: change 509209 for thread 1 is in sequence #17



Specify log: {=suggested | filename | AUTO | CANCEL}


/u01/app/oracle/oradata/orcl/redo02.log


ORA-00310: archived log contains sequence 15; sequence 17 required


ORA-00334: archived log: '/u01/app/oracle/oradata/orcl/redo02.log'