控制文件OLD错误

1、SQL首先需要查找redo文件的存放路径：select group#,type,member from v$logfile; 方法2：模拟ORA-01207错误很简单，不再描述：u 思路：用旧的控制文件恢复，最后用resetlogs打开数据库。u 具体步骤：1：startup mount;2：recover database using backup controlfile until cancel;然后根据情况，指定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执行恢复：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这个归档日志，我这里有这个文件，所以指定auto，此时应用了一些归档日志）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'这种恢复方式，不会自动去找联机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'需要的不是这个redo文件，继续指定！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'仍然不是，继续指定!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