丢失归档日志rman恢复

ALLSTARS_ORACLE

生产环境solaris 9+oracle9.2.06 做了DG


库上每天晚上执行一次的rman备份脚本如下：

backup database plus archivelog delete all  input;
crosscheck backup;
delete noprompt force obsolete;


在另外一台测试库上做rman恢复测试，recover 显示如下
Starting recover at 12-JUN-13
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 20630 is already on disk as file /oracle/app/oradata/eagle/redo03.log
archive log thread 1 sequence 20632 is already on disk as file /oracle/app/oradata/eagle/redo01.log
archive log thread 1 sequence 20633 is already on disk as file /oracle/app/oradata/eagle/redo02.log
Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: '/oracle/app/oradata/eagle/system01.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 06/12/2013 11:42:45
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 20629 scn 4694813805 found to restore
RMAN-06025: no backup of log thread 1 seq 20628 scn 4694801816 found to restore
RMAN-06025: no backup of log thread 1 seq 20627 scn 4694673125 found to restore
RMAN-06025: no backup of log thread 1 seq 20626 scn 4694470299 found to restore

ALLSTARS_ORACLE

控制文件中的scn为 ：
SQL> select checkpoint_change# from v$database;

CHECKPOINT_CHANGE#
------------------
        4708722056


数据文件中的scn为：
SQL> select file#,checkpoint_change#,last_change# from v$datafile;

     FILE# CHECKPOINT_CHANGE# LAST_CHANGE#
---------- ------------------ ------------
         1         4708722355
         2         4708722355
         3         4708722355
         4         4708722355
         5         4708722355
         6         4708722355
         7         4708722355
         8         4708722355
         9         4708722355
        10         4708722355
        11         4708722355

     FILE# CHECKPOINT_CHANGE# LAST_CHANGE#
---------- ------------------ ------------
        12         4708722355
        13         4708722355
        14         4708722355
        15         4708722355
        16         4708722355
        17         4708722355
        18         4708722355
        19         4708722355
        20         4708722355
        21         4708722355



对，就是这个原因，今天下午在测试库上，把那个文件offline了，然后做recover ,再open，就正常了，谢谢你的提醒哈