Oracle 控制文件损坏解决方案

柔情只为你懂 2022-05-28 02:43 667阅读 0赞

**故障一：丢失(损坏)一个控制文件**

**前台报错：ORA-00205：error in identifying control file,check alert log formore info**

**解决方案：(干净或非干净方式关闭数据库)**

**使用完好的控制文件复制(替换)重命名丢失(损坏)的控制文件；**

**故障二：两个控制文件版本不一致**

**(1)一个控制文件正常，另一个控制文件来源于其他备份或其他数据库的控制文件；**

**前台报错：ORA-00214:controlfile '/../../control01.ctl' version xxx inconsistent with file'/../../control02.ctl' version yyy;**

**解决方案：(干净或非干净方式关闭数据库)**

**用高版本的控制文件替换低版本的控制文件;**

**(2) 两个控制文件均是来自不同时间的备份(都低于当前版本)；**

**前台报错：ORA-00214:controlfile '/../../control01.ctl' version xxx inconsistent with file'/../../control02.ctl' version yyy;**

**ORA-01207:fileis more recent than control file - old control file**

**解决方案：(干净方式关闭数据库)**

**用高版本的控制文件替换低版本的控制文件，后可以正常mount数据库，但是无法open数据库，需要手动创建控制文件(alter database backup to trace as'\\..\\..\\cc.tcl')，重新生成控制文件(noresetlogs方式)，之后可以正常open数据库；**

**解决方案：(非干净方式关闭数据库)**

**非干净关闭(数据库异常断电)，数据库启动时需要介质恢复(recover database)，恢复成功后可以正常打开数据库；**

**故障三：两个控制文件全部损坏，非当前日志文件丢失(或损坏)**

**报错：ORA-00205：error in identifying control file,check alert log formore info**

**解决方案：(干净方式关闭数据库)**

**因为有日志文件丢失，以NORESETLOGS方式手动创建控制文件时报错，只能以RESETLOGS方式创建控制文件；创建控制文件成功后，数据库自动mount，执行alter database open resetlogs;可以正常启动数据库；**

**解决方案：(非干净方式关闭数据库)**

**如果数据库之前是以不干净的方式(abort/断电)关闭的，openresetlogs数据库之前需要进行介质恢复，**

**recover database using backup controlfie;**

**由于resetlogs方式创建控制文件，导致日志序列号重新开始，自动恢复时不会自动使用当前日志文件，需要手动指定具体的日志文件；**

**例如：D:\\app\_10.2.0.4\\chen\_datafile\\redo01.log或D:\\app\_10.2.0.4\\chen\_datafile\\redo03.log**

**进行介质恢复，介质恢复成功后可以通过alter database open resetlogs方式open数据库；**

**故障四：两个控制文件全部损坏，当前日志文件丢失(或损坏)**

**报错：ORA-00205：error in identifying control file,check alert log formore info**

**解决方案：**

**(干净方式关闭数据库)**

**解决方案：**

**(非干净方式关闭数据库)**

**如果数据库之前是以不干净的方式(abort/断电)关闭的，openresetlogs数据库之前需要进行介质恢复，**

**recover database using backup controlfie;**

**由于resetlogs方式创建控制文件，导致日志序列号重新开始，自动恢复时不会自动使用当前日志文件，需要手动指定具体的日志文件；**

**例如：D:\\app\_10.2.0.4\\chen\_datafile\\redo01.log或D:\\app\_10.2.0.4\\chen\_datafile\\redo03.log**

**进行介质恢复，但是数据库介质恢复所需的信息保存在丢失的当前日志文件中，导致介质恢复失败，只能通过隐含参数"\*.\_allow\_resetlogs\_corruption=true"(altersystem set "\_allow\_resetlogs\_corruption"=true scope=spfile;)跳过一致性检查，才能open resetlogs数据库；**

**其中\_allow\_resetlogs\_corruption参数可能会触发多个ORA-600错误；**

**(1)报错ORA-00600: internalerror code, arguments: \[2662\]，可通过\_minimum\_giga\_scn跳过此BUG；**

**(2)报错ORA-00600: internal error code, arguments: \[kdsgrp1\]，具体原因需要查看trace文件，本次案例可以通过将undo管理方式由自动改成手动，跳过此BUG；**

**\*.undo\_tablespace=SYSTEM**

**\*.undo\_management=MANUAL**

**具体解决故障过程如下：**

**故障一：丢失(损坏)一个控制文件**

**前台报错：ORA-00205：error in identifying control file,check alert log formore info**

**解决方案：使用完好的控制文件复制(替换)重命名丢失(损坏)的控制文件；  
![29785807_1464531791Kqmk.png][]  
![29785807_1464531825zPCY.png][]  
![29785807_1464531861Z2HC.png][]**

**---通过删除控制文件control02.ctl模拟控制文件丢失**

Sun May 29 14:56:12 2016

ALTER DATABASE   MOUNT

ORA-00210: cannot open the specifiedcontrol file

**ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL02.CTL'**

**ORA-27041: unable to open file**

**OSD-04002: 无法打开文件**

**O/S-Error: (OS 2) 系统找不到指定的文件。**

ORA-205 signalled during: ALTERDATABASE   MOUNT...

Sun May 29 14:56:12 2016

MMNL started with pid=16, OS id=2476

**---alert\_orcl.log警告日志**

**---通过文本编辑二进制控制文件control02.ctl模拟控制文件损坏**

Sun May 29 16:35:03 2016

ALTER DATABASE   MOUNT

ORA-00210: cannot open the specifiedcontrol file

**ORA-00202: control file: 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL01.CTL'**

**ORA-27046: file size is not a multiple of logical blocksize**

**OSD-04012: 文件大小不匹配 (OS 12763140)**

ORA-205 signalled during: ALTERDATABASE   MOUNT...

**解决方案：用另一个控制文件进行恢复**

![29785807_1464532077Hc6Y.png][]

**故障二：两个控制文件版本不一致**

**(1)一个控制文件正常，另一个控制文件来源于其他备份或其他数据库的控制文件；**

**前台报错：ORA-00214:controlfile '/../../control01.ctl' version xxx inconsistent with file'/../../control02.ctl' version yyy;**

**解决方案：用高版本的控制文件替换低版本的控制文件;**

![29785807_1464532117w4td.png][]

本次案例可以将control02.ctl控制文件复制重命名control01.ctl替换原control01.ctl文件；

![29785807_1464532077Hc6Y.png][]

**(2) 两个控制文件均是来自不同时间的备份；**

**前台报错：ORA-00214:controlfile '/../../control01.ctl' version xxx inconsistent with file'/../../control02.ctl' version yyy;**

**ORA-01207:fileis more recent than control file - old control file**

**解决方案：用高版本的控制文件替换低版本的控制文件，后可以正常mount数据库，但是无法open数据库，需要手动创建控制文件(alter database backup to trace as'\\..\\..\\cc.tcl')，重新生成控制文件(noresetlogs方式)，之后可以正常open数据库；**

** ![29785807_1464532174iMpQ.png][]**

**controlfile1版本号较高，用controlfile1重命名controlfile2替换原controfile2文件；**

![29785807_14645322043W87.png][]

![29785807_1464532240SQc5.png][]

Sun May 29 15:12:45 2016

Errors in fileD:\\APP\\ADMINISTRATOR\\diag\\rdbms\\orcl\\orcl\\trace\\orcl\_m000\_9636.trc:

ORA-00338: log 1 of thread 1 is more recentthan control file

ORA-00312: online log 1 thread 1:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

ORA-00338: log 1 of thread 1 is more recentthan control file

ORA-00312: online log 1 thread 1:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG'

** **

**解决方案：重建控制文件**

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE"ORCL" **NORESETLOGS**  NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 2337

LOGFILE

GROUP 1 (

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

)SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'  SIZE 50M BLOCKSIZE 512

DATAFILE

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSTEM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSAUX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\USERS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\EXAMPLE01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\MHWZ01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\ISM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01A.DBF'

CHARACTER SET ZHS16GBK

;

![29785807_1464532356Ba85.png][]

![29785807_1464532383303I.png][]

***使用resetlogs，将导致redo logs里的内容丢失，并且所有的备份失效，当redo logs 损坏或从备份恢复控制文件的情况下，才使用resetlogs模式。通常情况下重建控制文件最好采用noresetlogs方式；***

**非干净关闭(数据库异常断电)，数据库启动是需要介质恢复(recover database)，恢复成功后可以正常打开数据库；**

![29785807_146453242109Hq.png][]

![29785807_1464532434Gweh.png][]

SunMay 29 15:42:59 2016

ALTERDATABASE   MOUNT

ORA-00210:cannot open the specified control file

**ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL02.CTL'**

**ORA-27046: file size is not a multiple oflogical block size**

**OSD-04012: 文件大小不匹配 (OS 12763144)**

**ORA-00210: cannot open the specifiedcontrol file**

**ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL01.CTL'**

**ORA-27046: file size is not a multiple oflogical block size**

**OSD-04012: 文件大小不匹配 (OS 12763144)**

ORA-205signalled during: ALTER DATABASE  MOUNT...

![29785807_1464570954Kzd1.png][]

** **

**重建控制文件**

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE"ORCL" **NORESETLOGS**  NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 2337

LOGFILE

GROUP 1 (

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

)SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'  SIZE 50M BLOCKSIZE 512

DATAFILE

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSTEM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSAUX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\USERS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\EXAMPLE01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\MHWZ01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\ISM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01A.DBF'

CHARACTER SET ZHS16GBK

;

![29785807_1464532356Ba85.png][]

![29785807_1464571011pjvO.png][]

![29785807_1464571111wYub.png][]  
  
![29785807_1464571111GTzE.png][]  
  
![29785807_1464571111vtz8.png][]  
  
![29785807_1464571111T6tw.png][]  
  
![29785807_1464571112qHQU.png][]

**故障三：两个控制文件全部损坏，非当前日志文件丢失(或损坏)**

**报错：ORA-00205：error in identifying control file,check alert log formore info**

**解决方案：因为有日志文件丢失，以NORESETLOGS方式手动创建控制文件时报错，只能以RESETLOGS方式创建控制文件；创建控制文件成功后，数据库自动mount，如果数据库之前是以干净的方式(immediate/normal)关闭的，执行alter database open resetlogs;可以正常启动数据库；**

**如果数据库之前是以不干净的方式(abort/断电)关闭的，openresetlogs数据库之前需要进行介质恢复，**

**recover database using backup controlfie;**

**由于resetlogs方式创建控制文件，导致日志序列号重新开始，自动恢复时不会自动使用当前日志文件，需要手动指定具体的日志文件；**

**例如：D:\\app\_10.2.0.4\\chen\_datafile\\redo01.log或D:\\app\_10.2.0.4\\chen\_datafile\\redo03.log**

**进行介质恢复，介质恢复成功后可以通过alter database open resetlogs方式open数据库；**

![29785807_1464571267ODbF.png][]

![29785807_1464571280B30X.png][]

编辑损坏两个控制文件，删除非当前日志文件redo03.log

![29785807_1464571324XmGc.png][]

![29785807_1464571336VfOr.png][]

Sun May 29 16:40:55 2016

ALTER DATABASE   MOUNT

**ORA-00210: cannot open the specified control file**

**ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL02.CTL'**

**ORA-27046: file size is not a multiple of logical blocksize**

**OSD-04012: 文件大小不匹配 (OS 12763144)**

**ORA-00210: cannot open the specified control file**

**ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL01.CTL'**

**ORA-27046: file size is not a multiple of logical blocksize**

**OSD-04012: 文件大小不匹配 (OS 12763144)**

ORA-205 signalled during: ALTERDATABASE   MOUNT...

Sun May 29 16:40:55 2016

MMNL started with pid=16, OS id=10652

![29785807_14645713737QQy.png][]

**手动创建控制文件(NORESETLOGS)**

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE"ORCL" **NORESETLOGS ** NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 2337

LOGFILE

GROUP 1 (

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

)SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'  SIZE 50M BLOCKSIZE 512

DATAFILE

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSTEM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSAUX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\USERS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\EXAMPLE01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\MHWZ01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\ISM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01A.DBF'

CHARACTER SET ZHS16GBK

;

![29785807_14645714286WfW.png][]

Errors in fileD:\\APP\\ADMINISTRATOR\\diag\\rdbms\\orcl\\orcl\\trace\\orcl\_ora\_7516.trc:

**ORA-01565: error in identifying file'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'**

**ORA-27041: unable to open file**

**OSD-04002: 无法打开文件**

**O/S-Error: (OS 2) 系统找不到指定的文件。**

ORA-1503 signalled during: CREATECONTROLFILE REUSE DATABASE "ORCL" NORESETLOGS  NOARCHIVELOG

**手动创建控制文件(RESETLOGS)**

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE"ORCL" **RESETLOGS ** NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 2337

LOGFILE

GROUP 1 (

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

)SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'  SIZE 50M BLOCKSIZE 512

DATAFILE

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSTEM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSAUX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\USERS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\EXAMPLE01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\MHWZ01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\ISM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01A.DBF'

CHARACTER SET ZHS16GBK

;  
![29785807_1464571555XgQl.png][]  
  
![29785807_1464571555cu5G.png][]  
![29785807_1464571556Cfaa.png][]  
  
![29785807_1464571554g6Ni.png][]  
  
![29785807_146457155456Yp.png][]  
  
![29785807_14645715548iMm.png][]  
  
![29785807_14645715557gNY.png][]

**故障四：两个控制文件全部损坏，当前日志文件丢失(或损坏)**

**报错：ORA-00205：error in identifying control file,check alert log formore info**

**解决方案：因为有日志文件丢失，以NORESETLOGS方式手动创建控制文件时报错，只能以****RESETLOGS****方式创建控制文件；创建控制文件成功后，数据库自动mount，如果数据库之前是以干净的方式(immediate/normal)关闭的，执行alter database open resetlogs;可以正常启动数据库；**

**如果数据库之前是以不干净的方式(abort/断电)关闭的，openresetlogs数据库之前需要进行介质恢复，**

**recover database using backup controlfie;**

**由于resetlogs方式创建控制文件，导致日志序列号重新开始，自动恢复时不会自动使用当前日志文件，需要手动指定具体的日志文件；**

**例如：D:\\app\_10.2.0.4\\chen\_datafile\\redo01.log或D:\\app\_10.2.0.4\\chen\_datafile\\redo03.log**

**进行介质恢复，但是数据库介质恢复所需的信息保存在丢失的当前日志文件中，导致介质恢复失败，只能通过隐含参数"\*.****\_allow\_resetlogs\_corruption=true****"(altersystem set "\_allow\_resetlogs\_corruption"=true scope=spfile;)跳过一致性检查，才能open resetlogs数据库；**

**其中\_allow\_resetlogs\_corruption参数可能会触发多个ORA-600错误；**

**(1)报错ORA-00600: internal error code, arguments: \[****2662****\]，可通过\_minimum\_giga\_scn跳过此BUG；**

**(2)报错ORA-00600: internalerror code, arguments: \[****kdsgrp1****\]，具体原因需要查看trace文件，本次案例可以通过将undo管理方式由自动改成手动，跳过此BUG；**

**\*.undo\_tablespace=SYSTEM**

**\*.undo\_management=MANUAL**

** **

![29785807_1464571891tnvf.png][]

![29785807_1464571909tKqK.png][]

故障：两个控制文件全部损坏，当前日志文件丢失(或损坏)

解决方案：

![29785807_1464571957pKCx.png][]

![29785807_1464571970Oaf6.png][]

![29785807_1464571983TT29.png][]

Sun May 29 20:00:47 2016

ALTER DATABASE   MOUNT

ORA-00210: cannot open the specifiedcontrol file

ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL02.CTL'

ORA-27046: file size is not a multiple oflogical block size

OSD-04012: 文件大小不匹配 (OS 12763139)

ORA-00210: cannot open the specifiedcontrol file

ORA-00202: control file:'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CONTROL01.CTL'

ORA-27046: file size is not a multiple oflogical block size

OSD-04012: 文件大小不匹配 (OS 12763140)

ORA-205 signalled during: ALTERDATABASE   MOUNT...

**---手动创建控制文件(NORESETLOGS)**

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE"ORCL" **NORESETLOGS ** NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 2337

LOGFILE

GROUP 1 (

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

)SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'  SIZE 50M BLOCKSIZE 512

DATAFILE

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSTEM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSAUX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\USERS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\EXAMPLE01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\MHWZ01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\ISM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01A.DBF'

CHARACTER SET ZHS16GBK

;

![29785807_146457199643An.png][]

**---手动创建控制文件(RESETLOGS)**

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE"ORCL" **RESETLOGS ** NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 2337

LOGFILE

GROUP 1 (

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01.LOG',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO01A.LOG'

)SIZE 50M BLOCKSIZE 512,

GROUP 2 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO02.LOG'  SIZE 50M BLOCKSIZE 512,

GROUP 3 'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\REDO03.LOG'  SIZE 50M BLOCKSIZE 512

DATAFILE

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSTEM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\SYSAUX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\USERS01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\EXAMPLE01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\CHEN02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX02.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\MHWZ01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA02A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\ISM01.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_DATA01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\NNC\_INDEX01A.DBF',

'D:\\APP\_10.2.0.4\\CHEN\_DATAFILE\\UNDOTBS01A.DBF'

CHARACTER SET ZHS16GBK

;

![29785807_14645720120e3F.png][]

![29785807_1464575548ADsl.png][]

![29785807_1464575562d3z0.png][]

![29785807_146457557660N0.png][]  
![29785807_1464575588d2rR.png][]  
  
![29785807_1464575602SSzI.png][]  
  
![29785807_146457561403nQ.png][]  
  
![29785807_14645756243yco.png][]  
  
![29785807_1464575637x2R1.png][]  
  
![29785807_1464575649cEfo.png][]  
  
![29785807_14645756636Q4B.png][]  
  
![29785807_14645756806976.png][]

***---Windows环境下，如果cmd中存在"?"，乱码问题，可以设置客户端字符集***

![29785807_14645756947fc6.png][]

**或者set NLS\_LANG=SIMPLIFIED CHINESE\_CHINA.ZHS16GBK**

[29785807_1464531791Kqmk.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464531791Kqmk.png
[29785807_1464531825zPCY.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464531825zPCY.png
[29785807_1464531861Z2HC.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464531861Z2HC.png
[29785807_1464532077Hc6Y.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532077Hc6Y.png
[29785807_1464532117w4td.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532117w4td.png
[29785807_1464532174iMpQ.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532174iMpQ.png
[29785807_14645322043W87.png]: http://blog.itpub.net/attachment/201605/29/29785807_14645322043W87.png
[29785807_1464532240SQc5.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532240SQc5.png
[29785807_1464532356Ba85.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532356Ba85.png
[29785807_1464532383303I.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532383303I.png
[29785807_146453242109Hq.png]: http://blog.itpub.net/attachment/201605/29/29785807_146453242109Hq.png
[29785807_1464532434Gweh.png]: http://blog.itpub.net/attachment/201605/29/29785807_1464532434Gweh.png
[29785807_1464570954Kzd1.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464570954Kzd1.png
[29785807_1464571011pjvO.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571011pjvO.png
[29785807_1464571111wYub.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571111wYub.png
[29785807_1464571111GTzE.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571111GTzE.png
[29785807_1464571111vtz8.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571111vtz8.png
[29785807_1464571111T6tw.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571111T6tw.png
[29785807_1464571112qHQU.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571112qHQU.png
[29785807_1464571267ODbF.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571267ODbF.png
[29785807_1464571280B30X.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571280B30X.png
[29785807_1464571324XmGc.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571324XmGc.png
[29785807_1464571336VfOr.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571336VfOr.png
[29785807_14645713737QQy.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645713737QQy.png
[29785807_14645714286WfW.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645714286WfW.png
[29785807_1464571555XgQl.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571555XgQl.png
[29785807_1464571555cu5G.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571555cu5G.png
[29785807_1464571556Cfaa.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571556Cfaa.png
[29785807_1464571554g6Ni.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571554g6Ni.png
[29785807_146457155456Yp.png]: http://blog.itpub.net/attachment/201605/30/29785807_146457155456Yp.png
[29785807_14645715548iMm.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645715548iMm.png
[29785807_14645715557gNY.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645715557gNY.png
[29785807_1464571891tnvf.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571891tnvf.png
[29785807_1464571909tKqK.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571909tKqK.png
[29785807_1464571957pKCx.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571957pKCx.png
[29785807_1464571970Oaf6.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571970Oaf6.png
[29785807_1464571983TT29.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464571983TT29.png
[29785807_146457199643An.png]: http://blog.itpub.net/attachment/201605/30/29785807_146457199643An.png
[29785807_14645720120e3F.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645720120e3F.png
[29785807_1464575548ADsl.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464575548ADsl.png
[29785807_1464575562d3z0.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464575562d3z0.png
[29785807_146457557660N0.png]: http://blog.itpub.net/attachment/201605/30/29785807_146457557660N0.png
[29785807_1464575588d2rR.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464575588d2rR.png
[29785807_1464575602SSzI.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464575602SSzI.png
[29785807_146457561403nQ.png]: http://blog.itpub.net/attachment/201605/30/29785807_146457561403nQ.png
[29785807_14645756243yco.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645756243yco.png
[29785807_1464575637x2R1.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464575637x2R1.png
[29785807_1464575649cEfo.png]: http://blog.itpub.net/attachment/201605/30/29785807_1464575649cEfo.png
[29785807_14645756636Q4B.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645756636Q4B.png
[29785807_14645756806976.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645756806976.png
[29785807_14645756947fc6.png]: http://blog.itpub.net/attachment/201605/30/29785807_14645756947fc6.png