ORA-00600 [kddummy_blkchk]错误一例

一套HP-UX Itanium平台上的10.2.0.2，实例意外终止，维护人员尝试重启实例，在数据库打开后数秒，smon后台进程报ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110]错误，实例再次意外终止。 部分告警日志如下:

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64

Corrupt Block Found TSN = 50, TSNAME = TS_DNI_AAL_12 RFN = 120, BLK = 849708, RDBA = 504166188 OBJN = 701796, OBJD = 701796, OBJECT = MAP_WOL_SILJUK, SUBOBJECT = SEGMENT OWNER = DBOWN, SEGMENT TYPE =  Table  Segment Corrupt Block Found TSN = 50, TSNAME = TS_DNI_AAL_12 RFN = 121, BLK = 897927, RDBA = 508408711 OBJN = 701796, OBJD = 701796, OBJECT = MAP_WOL_SILJUK, SUBOBJECT = SEGMENT OWNER = DBOWN, SEGMENT TYPE =  Table  Segment Mon May 4 19:38:19 2009 Errors  in  file /oracle/admin/TDAY2DB/udump/tday2db_ora_2080.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [121], [897927], [6110], [], [], [], [] Mon May 4 19:38:19 2009 Errors  in  file /oracle/admin/TDAY2DB/udump/tday2db_ora_2077.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [849708], [6110], [], [], [], []   Mon May 4 21:58:55 2009 Recovery  of  Online Redo Log: Thread 1  Group  5 Seq 90582 Reading mem 0 Mem# 0: /dev/vx/rdsk/day2db1tdg03/redo05.log Block recovery completed  at  rba 90582.42.16, scn 1858.566253676 ORACLE Instance TDAY2DB (pid = 22) - Error 81 encountered while recovering  transaction  (14, 22)  on  object 701796. Mon May 4 21:58:55 2009 Errors  in  file /oracle/admin/TDAY2DB/bdump/tday2db_smon_17651.trc: ORA-00081: address range [0x60000000000BD230, 0x60000000000BD234)  is  not  readable ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], [] Mon May 4 21:58:55 2009 Errors  in  file /oracle/admin/TDAY2DB/bdump/tday2db_smon_17651.trc: ORA-00081: address range [0x60000000000BD230, 0x60000000000BD234)  is  not  readable ORA-00081: address range [0x60000000000BD230, 0x60000000000BD234)  is  not  readable ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], [] Mon May 4 21:58:57 2009 Errors  in  file /oracle/admin/TDAY2DB/bdump/tday2db_p020_17710.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], [] Mon May 4 21:58:58 2009 Doing block recovery  for  file 120 block 856039 Block recovery  from  logseq 90582, block 37  to  scn 7980615489643 Mon May 4 21:58:58 2009 Recovery  of  Online Redo Log: Thread 1  Group  5 Seq 90582 Reading mem 0 Mem# 0: /dev/vx/rdsk/day2db1tdg03/redo05.log Block recovery completed  at  rba 90582.42.16, scn 1858.566253676 Mon May 4 21:58:58 2009 SMON: Restarting fast_start parallel  rollback Mon May 4 21:58:58 2009 Errors  in  file /oracle/admin/TDAY2DB/bdump/tday2db_p000_17661.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], [] Mon May 4 21:58:59 2009 Doing block recovery  for  file 120 block 856039 Block recovery  from  logseq 90582, block 37  to  scn 7980615489643 Mon May 4 21:58:59 2009 Recovery  of  Online Redo Log: Thread 1  Group  5 Seq 90582 Reading mem 0 Mem# 0: /dev/vx/rdsk/day2db1tdg03/redo05.log Block recovery completed  at  rba 90582.42.16, scn 1858.566253676 Mon May 4 21:58:59 2009 SMON: ignoring slave err,downgrading  to  serial  rollback Mon May 4 21:59:00 2009 Errors  in  file /oracle/admin/TDAY2DB/bdump/tday2db_smon_17651.trc: ORA-00600: internal error code, arguments: [kddummy_blkchk], [120], [856039], [6110], [], [], [], [] Mon May 4 21:59:09 2009 Errors  in  file /oracle/admin/TDAY2DB/bdump/tday2db_pmon_17633.trc: ORA-00474: SMON process terminated  with  error Mon May 4 21:59:09 2009 PMON: terminating instance due  to  error 474 Instance terminated  by  PMON, pid = 17633

当Oracle进程在读取数据块时会做一系列逻辑检测，当发现块当中存在逻辑讹误就会触发该ORA-00600 [kddummy_blkchk]等内部错误；[kddummy_blkchk]内部函数的功能大致与[kdBlkCheckError]相仿，它们都有3个参数argument： ORA-600 [kddummy_blkchk] [file#] [block#] [check code] ORA-600 [kdBlkCheckError]

本文转自maclean_007 51CTO博客，原文链接:http://blog.51cto.com/maclean/1276753