rman异常案例一：归档日志被人移动到其他目录，导致数据库恢复异常解决(二)
260.dbf
archived log for thread 1 with sequence 89 is already on disk as file /oracle/oraarch/1_89_821442260.dbf
archived log for thread 1 with sequence 90 is already on disk as file /oracle/oraarch/1_90_821442260.dbf
archived log for thread 1 with sequence 91 is already on disk as file /oracle/oraarch/1_91_821442260.dbf
archived log for thread 1 with sequence 92 is already on disk as file /oracle/oraarch/1_92_821442260.dbf
archived log file name=/oracle/oraarch/1_88_821442260.dbf thread=1 sequence=88
archived log file name=/oracle/oraarch/1_89_821442260.dbf thread=1 sequence=89
archived log file name=/oracle/oraarch/1_90_821442260.dbf thread=1 sequence=90
media recovery complete, elapsed time: 00:00:04
Finished recover at 17-AUG-13
2、模拟归档日志被移动到其他位置，做恢复的过程，遭遇报错
suse11sp2:/oracle/oraarch # mkdir test
suse11sp2:/oracle/oraarch # mv *.dbf test
suse11sp2:/oracle/oraarch/test # ls
1_88_821442260.dbf 1_90_821442260.dbf 1_92_821442260.dbf
1_89_821442260.dbf 1_91_821442260.dbf
RMAN> restore database;
Starting restore at 17-AUG-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /oracle/oradata/ebai/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/oradata/ebai/example01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/rman/data_0tohh219_1_1_20130817
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to /oracle/oradata/ebai/system01.dbf
channel ORA_DISK_2: restoring datafile 00006 to /oracle/oradata/aa.dbf
channel ORA_DISK_2: reading from backup piece /oracle/rman/data_0rohh219_1_1_20130817
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00002 to /oracle/oradata/ebai/sysaux01.dbf
channel ORA_DISK_3: restoring datafile 00004 to /oracle/oradata/ebai/users01.dbf
channel ORA_DISK_3: reading from backup piece /oracle/rman/data_0sohh219_1_1_20130817
channel ORA_DISK_1: piece handle=/oracle/rman/data_0tohh219_1_1_20130817 tag=TOTALDB_HOT_BKUP
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel ORA_DISK_2: piece handle=/oracle/rman/data_0rohh219_1_1_20130817 tag=TOTALDB_HOT_BKUP
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:07
channel ORA_DISK_3: piece handle=/oracle/rman/data_0sohh219_1_1_20130817 tag=TOTALDB_HOT_BKUP
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:00:07
Finished restore at 17-AUG-13
RMAN> recover database;
Starting recover at 17-AUG-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
starting media recovery
RMAN-00571: ===========================================================
RMAN-00569: =