在做完全恢復時如果有redo存在，則會使用redo而不會使用對應的歸檔

在恢復的提示中以及alert中都能清楚的發現，如果是不完全恢復那麼只會尋找歸檔而不會去使用redo[@more@]

SQL> recover database;
ORA-00279: change 715107 generated at 04/26/2013 09:32:44 needed for thread 1
ORA-00289: suggestion :
E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_43_8QMPCSPY_.AR
C
ORA-00280: change 715107 for thread 1 is in sequence #43

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 715136 generated at 04/26/2013 09:33:45 needed for thread 1
ORA-00289: suggestion :
E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_44_8QMPF9RF_.AR
C
ORA-00280: change 715136 for thread 1 is in sequence #44

ORA-00279: change 715163 generated at 04/26/2013 09:34:33 needed for thread 1
ORA-00289: suggestion :
E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_45_8QMPGMPG_.AR
C
ORA-00280: change 715163 for thread 1 is in sequence #45

Log applied.Media recovery complete.
SQL>

--==================================

alert日誌中的提示如下：

ALTER DATABASE RECOVER database
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 8 slaves
ORA-279 signalled during: ALTER DATABASE RECOVER database ...
Fri Apr 26 10:06:09 2013
Checker run found 5 new persistent data failures
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_43_8QMPCSPY_.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_44_8QMPF9RF_.ARC
ORA-279 signalled during: ALTER DATABASE RECOVER CONTINUE DEFAULT ...
ALTER DATABASE RECOVER CONTINUE DEFAULT
Media Recovery Log E:ORACLEFLASH_RECOVERY_AREATESTARCHIVELOG2013_04_26O1_MF_1_45_8QMPGMPG_.ARC
Fri Apr 26 10:06:13 2013
Recovery of Online Redo Log: Thread 1 Group 1 Seq 46 Reading mem 0
Mem# 0: E:ORADATATESTREDO01.LOG
Recovery of Online Redo Log: Thread 1 Group 2 Seq 47 Reading mem 0
Mem# 0: E:ORADATATESTREDO02.LOG
Recovery of Online Redo Log: Thread 1 Group 3 Seq 48 Reading mem 0
Mem# 0: E:ORADATATESTREDO03.LOG
Completed: ALTER DATABASE RECOVER CONTINUE DEFAULT
Fri Apr 26 10:06:49 2013