一套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
