Oracle恢复实验（一）(二)

9 rows selected.

可以明显的看到数据文件users01.dbf的scn比较小，这是备份时的scn。

7、介质恢复
SQL> recover database;
ORA-00279: change 721971 generated at 09/25/2011 13:27:36 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_7_760842868.dbf
ORA-00280: change 721971 for thread 1 is in sequence #7

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 723634 generated at 09/25/2011 14:05:56 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_8_760842868.dbf
ORA-00280: change 723634 for thread 1 is in sequence #8
ORA-00278: log file '/home/oracle/oracle/product/archive/1_7_760842868.dbf' no longer needed for this recovery

ORA-00279: change 723636 generated at 09/25/2011 14:05:57 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_9_760842868.dbf
ORA-00280: change 723636 for thread 1 is in sequence #9
ORA-00278: log file '/home/oracle/oracle/product/archive/1_8_760842868.dbf' no longer needed for this recovery

ORA-00279: change 743752 generated at 09/25/2011 14:10:32 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_10_760842868.dbf
ORA-00280: change 743752 for thread 1 is in sequence #10
ORA-00278: log file '/home/oracle/oracle/product/archive/1_9_760842868.dbf' no longer needed for this recovery

ORA-00279: change 743864 generated at 09/25/2011 14:10:58 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_11_760842868.dbf
ORA-00280: change 743864 for thread 1 is in sequence #11
ORA-00278: log file '/home/oracle/oracle/product/archive/1_10_760842868.dbf' no longer needed for this recovery

ORA-00279: change 743866 generated at 09/25/2011 14:10:59 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_12_760842868.dbf
ORA-00280: change 743866 for thread 1 is in sequence #12
ORA-00278: log file '/home/oracle/oracle/product/archive/1_11_760842868.dbf' no longer needed for this recovery

ORA-00279: change 743868 generated at 09/25/2011 14:11:05 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/archive/1_13_760842868.dbf
ORA-00280: change 743868 for thread 1 is in sequence #13
ORA-00278: log file '/home/oracle/oracle/product/archive/1_12_760842868.dbf' no longer needed for this recovery

使用auto选项进行恢复，可以看到使用了8-13号日志，到操作系统中看一下：
[oracle@localhost archive]$ ls -lt
total 4112
-rw-r----- 1 oracle oinstall 4608 Sep 25 14:11 1_15_760842868.dbf
-rw-r----- 1 oracle oinstall 1024 Sep 25 14:11 1_14_760842868.dbf
-rw-r----- 1 oracle oinstall 1024 Sep 25 14:11 1_13_760842868.dbf
-rw-r----- 1 oracle oinstall 2048 Sep 25 14:11 1_12_760842868.dbf
-rw-r----- 1 oracle oinstall 1024 Sep 25 14:10 1_11_760842868.dbf
-rw-r----- 1 oracle oinstall 53760 Sep 25 14:10 1_10_760842868.dbf
-rw-r----- 1 oracle oinstall 1536 Sep 25 14:10 1_8_760842868.dbf
-rw-r----- 1 oracle oinstall 30720 Sep 25 14:10 1_9_760842868.dbf
-rw-r----- 1 oracle oinstall 4043776 Sep 25 14:10 1_7_760842868.dbf
还有14、15两个归档日志，可这两个并没有使用。这是为什么？
查看一下警告日志
[oracle@localhost bdump]$ tail -f alert_orcl.log
Mem# 0 errs