rman异常案例一：归档日志被人移动到其他目录，导致数据库恢复异常解决(四)
============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/17/2013 11:46:47
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 92 and starting SCN of 2419529 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 91 and starting SCN of 2418760 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 90 and starting SCN of 2415900 found to restore
因为rman无法找到需要用于恢复的归档日志，恢复过程中断且报错。
我尝试移动其中三个时间靠前的归档日志回到原归档目录，依然报错，说明如果我们不指定，oracle不会按量恢复，归档日志需要完全才可以。
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
archived log for thread 1 with sequence 88 is already on disk as file /oracle/oraarch/1_88_821442260.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
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/17/2013 12:04:50
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of archived log for thread 1 with sequence 92 and starting SCN of 2419529 found to restore
RMAN>
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 08/17/2013 12:06:57
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/oradata/ebai/system01.dbf'
3、把所有归档日志从test目录再移动回到归档目录原位置，恢复过程恢复正常
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
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
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=88
channel ORA_DISK_1: reading from backup piece /oracle/rman/arch_0vohh21q_1_1_20130817
channel ORA_DISK_2: starting archived log restore to default destination
channel ORA_DISK_2: restoring archived log
archived log thread=1 sequence=89
channel ORA_DISK_2: reading from backup piece /oracle/rman/arch_10ohh21q_1_1_20130817
channel ORA_DISK_1: piece handle=/ora