丢失归档日志rman恢复
生产环境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
控制文件中的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，就正常了，谢谢你的提醒哈
页:
[1]