急救,基于时间点的不完全恢复

显示全部楼层 · 2005-12-26 15:30:00

执行基于时间点的不完全恢复
recover database until time '2005-12-26 16:00'
然后执行
alter database open resetlogs;
启动数据库发现数据还不是16:00的,需要再执行.
recover database until time '2005-12-26 15:30'
SQL> recover database until time '2005-12-26 15:30:00'
ORA-00283: recovery session canceled due to errors
ORA-19907: recovery time or SCN does not belong to recovered incarnation

该怎么办?

千问 · 2005-12-26 15:30:00

conn / as sysdba
startup mount
recover database until time '2005-12-26 15:30:00' using backup controlfile;

千问 · 2005-12-26 15:30:00

SQL>recover database until time '2005-12-26 15:30:00' using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-19907: recovery time or SCN does not belong to recovered incarnation
我只是对单个表进行了update
早知道我先用flashback 某一个表了,这样可以只针对单个表恢复了.

现在搞的

千问 · 2005-12-26 15:30:00

执行了
alter database open resetlogs;
对scn已经更改了.
recover database until time '2005-12-26 15:30:00' using backup controlfile;
所以不行吧

千问 · 2005-12-26 15:30:00

如果是9i那就用flashback恢复个别表了

千问 · 2005-12-26 15:30:00

发现数据不是16点的，那只能重新作一次恢复了。不能在16点得基础上恢复到15:30吧。
用以前的备份全拷贝回去，重新恢复到15:30。

千问 · 2005-12-26 15:30:00

你已经resetlogs过了巴

千问 · 2005-12-26 15:30:00

19:53:16 SQL> recover database until time '2005-12-25 18:21:19';
Media recovery complete.
19:53:32 SQL> recover database until time '2005-11-25 18:21:19';
Media recovery complete.
19:53:38 SQL> recover database until time '2004-11-25 18:21:19';
Media recovery complete.
19:53:44 SQL> recover database until time '2001-11-25 18:21:19';
Media recovery complete.
19:53:52 SQL> recover database until time '2001-11-25 18:21';
Media recovery complete.
好象基于时间是有问题的，我的时间跨度太大了．但一点问题也没有

千问 · 2005-12-26 15:30:00

只能用再前面的备份还原,然后再做imcomplete recovery,
recover只能前滚,不能后退

千问 · 2005-12-26 15:30:00

所以还不是很智能了. 呵呵.