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

最新推荐文章于 2024-03-22 10:37:41 发布

原创最新推荐文章于 2024-03-22 10:37:41 发布 · 2.5k 阅读

0 ·

CC 4.0 BY-SA版权

oracle 专栏收录该内容

96 篇文章

订阅专栏

本文记录了因突然断电导致Oracle数据库出现磁盘存储故障及控制文件损坏后的恢复过程。包括使用dbv检测坏块、重建控制文件、使用备份控制文件进行数据库恢复等步骤，并解决了索引一致性问题。

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

处理方法和上面大同小异

重建控制文件，