ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_15_%u_.ar

c

ORA-00280: change 586676 for thread 1 is in sequence #15

ORA-00278: log file www.2cto.com

'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_14_80d55

41h_.arc' no longer needed for this recovery

ORA-00279: change 586704 generated at 07/18/2012 09:44:03 needed for thread 1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_16_%u_.ar

c

ORA-00280: change 586704 for thread 1 is in sequence #16

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_15_80d57

315_.arc' no longer needed for this recovery

Log applied.

Media recovery complete.

发现没？oracle只运用了归档日志到16。接下来的17,18就没有再提示了。为什么？我们先去数据文件的文件头把file 1的scn再取来看看。

[sql]

SQL> select file#,checkpoint_change# from v$datafile_header;

FILE# CHECKPOINT_CHANGE#

---------- ------------------

1 587003

2 0

3 0

4 0

5 587004

587003是不是比归档日志18的next_change#(586816)来得大呢。我们再来看看，当前日子组是哪一组。

[sql]

SQL> select group#,sequence#,status,first_change# from v$log;

GROUP# SEQUENCE# STATUS FIRST_CHANGE#

---------- ---------- ---------------- -------------

1 17 INACTIVE 586734

3 19 CURRENT 586816

2 18 INACTIVE 586762

可以看出，归档日志19的first_change#为586816。而数据文件头的scn是587003。当我们敲recover datafile 1时，oracle在做完全恢复。完全恢复的起点和终点是已经确定了。起点在数据文件的文件头，终点在控制文件里获取。因为，归档重做日志文件17,18是从联机重做日志文件1,2里面读出来的。oracle会优先去找联机重做日志文件。或者说，完全恢复时，oracle会自己去找联机重做日志文件；不完全恢复，我们可以把online redo log file的绝对路径和名称输进去。当前日志组是3，它的first_change#为586816，而587003比这个数大。可见，oracle也将当前日志文件给用上了。

接着恢复。这次，我们把剩余的数据文件全部拷回。然后大家一起往前走，直到步伐一致时，才能够同时停下来，这样子，oracle就处于一致的状态了。

[sql]

SQL> recover database;

ORA-00279: change 583375 generated at 07/17/2012 19:59:23 needed for thread 1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_11_%u_.ar

c

ORA-00280: change 583375 for thread 1 is in sequence #11

Specify log: {=suggested | filename | AUTO | CANCEL}

auto

ORA-00279: change 586090 generated at 07/18/2012 09:35:40 needed for thread 1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_12_%u_.ar

c

ORA-00280: change 586090 for thread 1 is in sequence #12

ORA-00278: log file www.2cto.com

'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_11_80d4q

dmh_.arc' no longer needed for this recovery

ORA-00279: change 586181 generated at 07/18/2012 09:39:21 needed for thread 1

ORA-00289: suggestion :

/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_13_%u_.ar

c

ORA-00280: change 586181 for thread 1 is in sequence #13

ORA-00278: log file

'/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2012_07_18/o1_mf_1_12_80d4y