ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [16226], [16217], [0x0], [], [],

oracle机器断电,导致磁盘存贮故障

 

dbv检测undo表空间有坏块

 

ORA-00600: internal error code, arguments: [kccpb_sanity_check_2], [16226], [16217], [0x0], [], [], [], []

试各个控制文件，成功mount

 

重建控制文件

alter database backup controlfile to trace;

 

 

REATE CONTROLFILE REUSE DATABASE "DUXIU" RESETLOGS  NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\REDO01.LOG'  SIZE 50M,
  GROUP 2 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\REDO02.LOG'  SIZE 50M,
  GROUP 3 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\REDO03.LOG'  SIZE 50M
DATAFILE
  'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\SYSTEM01.DBF',
  'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\UNDOTBS01.DBF',
  'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\SYSAUX01.DBF',
  'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\USERS01.DBF',
  'F:\ORACLE\PRODUCT\10.2.0\ORADATA\DUXIU\NBDL'
CHARACTER SET ZHS16GBK;

 

 

ALTER DATABASE RECOVER  DATABASE USING BACKUP CONTROLFILE ;

Thu Aug 08 10:24:10 2013
Media Recovery Start
WARNING! Recovering data file 1 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 2 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 3 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 4 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
WARNING! Recovering data file 5 from a fuzzy file. If not the current file
it might be an online backup taken without entering the begin backup command.
 parallel recovery started with 7 processes
ORA-279 signalled during: ALTER DATABASE RECOVER  DATABASE USING BACKUP CONTROLFILE  ...
Thu Aug 08 10:25:03 2013

ALTER DATABASE RECOVER    LOGFILE 'F:\oracle\product\10.2.0\oradata\DUXIU\REDO02.LOG' 
Thu Aug 08 10:25:03 2013
Media Recovery Log F:\oracle\product\10.2.0\oradata\DUXIU\REDO02.LOG
Thu Aug 08 10:25:10 2013
Hex dump of (file 2, block 2882) in trace file f:\oracle\product\10.2.0\admin\duxiu\bdump\duxiu_p004_2784.trc
Corrupt block relative dba: 0x00800b42 (file 2, block 2882)
Fractured block found during media recovery
Data in bad block:
 type: 2 format: 2 rdba: 0x00800b42
 last change scn: 0x0000.02898e29 seq: 0x9 flg: 0x04
 spare1: 0x0 spare2: 0x0 spare3: 0x0

 

 alter database open resetlogs;

成功打开数据库。

 

但是观察alert日志有报错

 

hu Aug 08 10:48:26 2013
Errors in file f:\oracle\product\10.2.0\admin\duxiu\bdump\duxiu_j000_1896.trc:
ORA-12012: 自动执行作业 1 出错
ORA-08102: 未找到索引关键字, 对象号 239, 文件 1, 块 1674 (2)

Thu Aug 08 10:48:26 2013
Errors in file f:\oracle\product\10.2.0\admin\duxiu\bdump\duxiu_j000_1896.trc:
ORA-12012: 自动执行作业 1 出错
ORA-08102: 未找到索引关键字, 对象号 239, 文件 1, 块 1674 (2)

Thu Aug 08 10:48:26 2013
Errors in file f:\oracle\product\10.2.0\admin\duxiu\bdump\duxiu_j000_1896.trc:
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-08102: 未找到索引关键字, 对象号 239, 文件 1, 块 1674 (2)
ORA-12012: 自动执行作业 1 出错
ORA-08102: 未找到索引关键字, 对象号 239, 文件 1, 块 1674 (2)

Thu Aug 08 10:50:10 2013
Errors in file f:\oracle\product\10.2.0\admin\duxiu\bdump\duxiu_j000_2660.trc:

Thu Aug 08 10:50:11 2013
Errors in file f:\oracle\product\10.2.0\admin\duxiu\bdump\duxiu_j000_2660.trc:
ORA-12012: 自动执行作业 1 出错
ORA-08102: 未找到索引关键字, 对象号 239, 文件 1, 块 1674 (2)

 

这是索引的一致性问题，找到这个对象：

SQL> select object_name from dba_objects where object_id=239;

OBJECT_NAME
--------------------------------------------------------------------------------
I_JOB_NEXT

直接DROP掉了重建：

SQL> drop index I_JOB_NEXT;

Index dropped.

SQL> create index i_job_next on job$ (next_date);

Index created.

错误消除，参考Metalink：1036858.6

 参考资料;http://www.eygle.com/archives/2010/12/fractured_controlfile_recovery.html

 

另外一个数据库也出现问题

alert日志如下

Recovery of Online Redo Log: Thread 1 Group 1 Seq 410 Reading mem 0
  Mem# 0 errs 0: F:\ORACLE\PRODUCT\10.2.0\ORADATA\CSSP\REDO01.LOG
Thu Aug 08 10:06:48 2013
Completed redo application
Thu Aug 08 10:06:49 2013
Errors in file f:\oracle\product\10.2.0\admin\cssp\bdump\cssp_p002_1512.trc:
ORA-07445: 出现异常错误: 核心转储 [IN_PAGE_ERROR] [_ktspfredo+0] [PC:0x1677A48] [] [] []

Thu Aug 08 10:06:49 2013
Errors in file f:\oracle\product\10.2.0\admin\cssp\bdump\cssp_p000_2848.trc:
ORA-07445: 出现异常错误: 核心转储 [IN_PAGE_ERROR] [_kturdb+0] [PC:0x17755D4] [] [] []

Thu Aug 08 10:06:49 2013
Errors in file f:\oracle\product\10.2.0\admin\cssp\bdump\cssp_p003_3628.trc:
ORA-07445: 出现异常错误: 核心转储 [IN_PAGE_ERROR] [_kturdb+0] [PC:0x17755D4] [] [] []

Thu Aug 08 10:06:49 2013
Errors in file f:\oracle\product\10.2.0\admin\cssp\bdump\cssp_p004_3928.trc:
ORA-07445: 出现异常错误: 核心转储 [IN_PAGE_ERROR] [_kturdh+0] [PC:0x1774A38] [] [] []

Thu Aug 08 10:06:50 2013
Errors in file f:\oracle\product\10.2.0\admin\cssp\bdump\cssp_p005_3720.trc:
ORA-07445: 出现异常错误: 核心转储 [IN_PAGE_ERROR] [_ktspfredo+0] [PC:0x1677A48] [] [] []

Thu Aug 08 10:07:32 2013
Aborting crash recovery due to slave death, attempting serial crash recovery
Thu Aug 08 10:07:32 2013

 

处理方法和上面大同小异

重建控制文件，