Oracle完全脱机，部分脱机与部分联机备份(七)
ry_area/ORCL/archivelog/2013_06_02/o1_mf_1_168_8tojh6p8_.arc' no longer needed for this recovery
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
Log applied.
Media recovery complete.
现在再看看当前数据文件的SCN号：
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229463966643
2 0
3 0
4 0
5 13229463961652
6 13229463961652
7 0
7 rows selected
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229463966643
2 13229463961652
3 13229463961652
4 13229463961652
5 13229463961652
6 13229463961652
7 13229463961652
7 rows selected
--可见已经完全恢复了
--打开数据库：
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 2 - see DBWR trace file
ORA-01110: data file 2: '/home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf'
--使用同样的操作，接着恢复2号文件
[oracle@localhost orcl]$ cp /home/lubinsu/orcl/undotbs01.dbf undotbs01.dbf
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 2 needs media recovery
ORA-01110: data file 2: '/home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf'
SQL> recover datafile 2;
ORA-00279: change 13229463960924 generated at 06/02/2013 11:32:48 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 13229463960924 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/2013 11:53:11 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_167_%u_.arc
ORA-00280: change 13229463961587 for thread 1 is in sequence #167
ORA-00278: log file '/home/oracle/oracle/product/10.2.0/flash_recovery_area/ORCL/archivelog/2013_06_02/o1_mf_1_166_8tojf7dd_.arc' no longer