Oracle完全脱机，部分脱机与部分联机备份(九)
needed for this recovery
ORA-00279: change 13229463961601 generated at 06/02/2013 11:53:44 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_168_%u_.arc
ORA-00280: change 13229463961601 for thread 1 is in sequence #168
ORA-00278: log file '/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_167_8tojg8nw_.arc' no longer needed for this recovery
ORA-00279: change 13229463961618 generated at 06/02/2013 11:54:14 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_169_%u_.arc
ORA-00280: change 13229463961618 for thread 1 is in sequence #169
ORA-00278: log file '/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_168_8tojh6p8_.arc' no longer needed for this recovery
Log applied.
Media recovery complete.
SQL> alter database open;
--查看2号数据文件的SCN号：
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229463966643
2 13229463966643
3 13229463961652
4 13229463961652
5 13229463961652
6 13229463961652
7 13229463961652
7 rows selected
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229463966643
2 13229463966643
3 0
4 0
5 13229463961652
6 13229463961652
7 0
7 rows selected
--如此反复操作，如果我们将重做日志文件删除，可能会提示需要日志文件：
[oracle@localhost orcl]$ cp redo01.log /home/lubinsu/orcl/
[oracle@localhost orcl]$ rm redo01.log
SQL> recover datafile 4;
ORA-00279: change 13229463960923 generated at 06/02/2013 11:19:18 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_164_%u_.arc
ORA-00280: change 13229463960923 for thread 1 is in sequence #164
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 13229463961439 generated at 06/02/2013 11:51:58 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_165_%u_.arc
ORA-00280: change 13229463961439 for thread 1 is in sequence #165
ORA-00278: log file '/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_164_8tojbz0v_.arc' no longer needed for this recovery
ORA-00279: change 13229463961457 generated at 06/02/2013 11:52:34 needed for thread 1
ORA-00289: suggestion : /home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_166_%u_.arc
ORA-00280: change 13229463961457 for thread 1 is in sequence #166
ORA-00278: log file '/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_165_8tojd2mx_.arc' no longer needed for this recovery
ORA-00279: change 13229463961587 generated at 06/02/20