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: {
/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: {
/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'