1、SQL首先需要查找redo文件的存放路徑：select group#,type,member from v$logfile; 方法2：模擬ORA-01207錯(cuò)誤很簡單，不再描述：u 思路：用舊的控制文件恢復(fù)，最后用resetlogs打開數(shù)據(jù)庫。u 具體步驟：1：startup mount;2：recover database using backup controlfile until cancel;然后根據(jù)情況，指定archive log和redo file。3：alter database open resetlogs;u 操作演示：oraclelinuxfreeoracleoradata

2、orcl sqlplus as sysdbaSQLPlus Release 10.2.0.1.0 - Production on 星期日 11月 19 1357512006Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to an idle instance.SQL startupORACLE instance started.Total System Global Area 167772160 bytesFixed Size 1218316 bytesVariable Size 88082676 bytesDat

3、abase Buffers 75497472bytesRedo Buffers 2973696 bytesDatabase mounted.ORA-01122 database file 1 failed verification checkORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'ORA-01207 file is more recent than control file - old control file執(zhí)行恢復(fù)：SQL recover database using backup controlfi

4、le until cancel;ORA-00279 change 891145 generated at 11182006 060211 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_47_%u_.arcORA-00280 change 891145 for thread 1 is in sequence #47Specify log =suggested filename AUTO CANCELauto （由于o1_mf_1_47_%u_

5、.arc這個(gè)歸檔日志，我這里有這個(gè)文件，所以指定auto，此時(shí)應(yīng)用了一些歸檔日志）ORA-00279 change 911145 generated at 11192006 134924 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_48_%u_.arcORA-00280 change 911145 for thread 1 is in sequence #48ORA-00278 log file'freeoracleflash_r

6、ecovery_areaORCLarchivelog2006_11_19o1_mf_1_47_2ozw355r_.arc' no longer needed for this recoveryORA-00279 change 911687 generated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1

7、 is in sequence #49ORA-00278 log file'freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_48_2ozwf289_.arc' no longer needed for this recoveryORA-00308 cannot open archived log'freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arc'ORA-27037 unable to obtain

8、 file statusLinux Error 2 No such file or directoryAdditional information 3ORA-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152 file 1 was not restored from a sufficiently old backupORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'這種恢復(fù)方式，不會(huì)自動(dòng)去找聯(lián)機(jī)redo文

9、件，所以必須要手工指定！SQL recover database using backup controlfile until cancel;ORA-00279 change 911687 generated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1 is in sequence #49Specify lo

10、g =suggested filename AUTO CANCELfreeoracleoradataorclredo01.logORA-00310 archived log contains sequence 47; sequence 49 requiredORA-00334 archived log 'freeoracleoradataorclredo01.log'ORA-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152 file 1 was not restor

11、ed from a sufficiently old backupORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'需要的不是這個(gè)redo文件，繼續(xù)指定！SQL recover database using backup controlfile until cancel;ORA-00279 change 911687 generated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaOR

12、CLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1 is in sequence #49Specify log =suggested filename AUTO CANCELfreeoracleoradataorclredo02.logORA-00310 archived log contains sequence 48; sequence 49 requiredORA-00334 archived log 'freeoracleoradataorclredo02.log'OR

13、A-01547 warning RECOVER succeeded but OPEN RESETLOGS would get error belowORA-01152 file 1 was not restored from a sufficiently old backupORA-01110 data file 1 'freeoracleoradataorclsystem01.dbf'仍然不是，繼續(xù)指定!SQL recover database using backup controlfile until cancel;ORA-00279 change 911687 gene

14、rated at 11192006 135436 needed for thread 1ORA-00289 suggestion freeoracleflash_recovery_areaORCLarchivelog2006_11_19o1_mf_1_49_%u_.arcORA-00280 change 911687 for thread 1 is in sequence #49Specify log =suggested filename AUTO CANCELfreeoracleoradataorclredo03.logLog applied.Media recovery complete.SQL alter database open resetlogs;Database altered.SQL select count() from gaojf; COUNT()- 791392SQL