手工恢复控制文件的深入解析(七)
AD# SEQUENCE# BYTES MEMBERS ARCHIV STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------ -------------------------------- ------------- --------------
1 1 1 52428800 2 YES INACTIVE 4918661 05-6 -13
3 1 3 52428800 2 NO CURRENT 4935675 07-6 -13
2 1 2 52428800 2 YES INACTIVE 4935491 07-6 -13
SYS@orcl#desc v$logfile;
名称 是否为空 类型
----------------------------------------------------------------------------------------------------------------- -------- ----------------------------------------------------------------------------
GROUP# NUMBER
STATUS VARCHAR2(7)
TYPE VARCHAR2(7)
MEMBER VARCHAR2(513)
IS_RECOVERY_DEST_FILE VARCHAR2(3)
SYS@orcl#col member for a120
SYS@orcl#select group#,member from v$logfile;
GROUP# MEMBER
---------- ------------------------------------------------------------------------------------------------------------------------
3 /opt/oracle/oradata/ORCL/onlinelog/o1_mf_3_8np02j56_.log
3 /opt/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_3_8np02l6x_.log
2 /opt/oracle/oradata/ORCL/onlinelog/o1_mf_2_8np02cjq_.log
1 /opt/oracle/oradata/ORCL/onlinelog/o1_mf_1_8np02719_.log
1 /opt/oracle/flash_recovery_area/ORCL/onlinelog/o1_mf_1_8np02985_.log
已选择6行。
SYS@orcl#recover database using backup controlfile;
ORA-00279: 4938513 ( 06/07/2013 23:16:52 ) 1
ORA-00289: : /opt/oracle/flash_recovery_area/ORCL/archivelog/2013_06_08/o1_mf_1_3_%u_.arc
ORA-00280: 4938513 ( 1) #3
指定日志: {=suggested | filename | AUTO | CANCEL}
/opt/oracle/oradata/ORCL/onlinelog/o1_mf_3_8np02j56_.log
已应用的日志。
完成介质恢复。
SYS@orcl#
这个时候我们在看看控制文件，数据文件的信息，注意和在没有进行recover之前的区别：如下：
SYS@orcl#select CHECKPOINT_CHANGE#,CONTROLFILE_SEQUENCE#,CONTROLFILE_CHANGE# from v$database;
CHECKPOINT_CHANGE# CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
------------------ --------------------- -------------------
4937839 14357 4938734
SYS@orcl#select checkpoint_change# from v$datafile;
CHECKPOINT_CHANGE#
------------------
4938734
4938734
4938734
4938734
4938734
4938734
4938734
4938734
4938734
4938734
4938734
CHECKPOINT_CHANGE#
------------------
4938734
已选择12行。
SYS@orcl#select file#,checkpoint_change# from v$datafile_header;
FILE# CHECKPOINT_CHANGE#
---------- ------------------
1 4938734