Oracle完全脱机，部分脱机与部分联机备份(十)
13 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 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
ORA-00283: recovery session canceled due to errors
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/home/oracle/oracle/product/10.2.0/oradata/orcl/redo01.log'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-01112: media recovery not started
--提示介质恢复未开始，需要重做日志文件/home/oracle/oracle/product/10.2.0/oradata/orcl/redo01.log
--我们再把该文件拷回来
SQL> recover datafile 4;
Media recovery complete.
SQL>
--恢复完成
SQL> select file#, checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229463966643
2 13229463966643
3 13229463966643
4 13229463966643
5 13229463961652
6 13229463961652
7 13229463966643
7 rows selected
SQL> select file#, checkpoint_change# from v$datafile;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 13229463966643
2 13229463966643
3 13229463966643
4 13229463966643
5 13229463961652
6 13229463961652
7 13229463966643
7 rows selected
SQL> alter database open;
Database altered.
--此时数据库已经可以启动
--查询我们之前的数据是否存在：
SQL> SELECT * FROM lubinsu.t_scn;
ID SCN
--------------------------------------- ----------
9 1322946396
1 1322946396
1 1322946396
1 1322946396
2 1322946396
3 1322946396
3 1322946396
4 1322946396
4 1322946396
5 1322946396
6 1322946396
7 1322946396
8 1