近日某客户系统遭遇如下错误导致数据库down机
on Jan 9 10:48:36 2017
Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:
ORA-00600: 内部错误代码,参数: [6002], [6], [28], [1], [52], [], [], []
Mon Jan 9 10:48:37 2017
Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:
ORA-00600: 内部错误代码,参数: [6006], [1], [], [], [], [], [], []
Mon Jan 9 10:48:39 2017
Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:
ORA-00603: ORACLE 服务器会话因致命错误而终止
ORA-00600: 内部错误代码,参数: [6006], [1], [], [], [], [], [], []
Mon Jan 9 10:52:43 2017
PMON failed to delete process, see PMON trace file
Mon Jan 9 10:57:18 2017
Thread 1 advanced to log sequence 69144
Current log# 1 seq# 69144 mem# 0: /oradata/jzh/redo01.log
Mon Jan 9 10:57:18 2017
ARC0: Evaluating archive log 3 thread 1 sequence 69143
ARC0: Beginning to archive log 3 thread 1 sequence 69143
说明:该错误是因为oracle要在索引中插入键值,插入之前会去检查索引叶子块记录的行数,数据量大小,如果不匹配就会报错
解决方法是找出对应的索引,删除或rebuild就可以。
jzh_ora_491554.trc文件:
BH (0x700000073fbdb00) file#: 12 rdba: 0x0339451d (12/3753245) class 1 ba: 0x700000073776000
set: 18 dbwrid: 1 obj: 2005760 objn: 2005760 ---object_id 2005760就是索引
hash: [700000156f5bb00,700000156f5bb00] lru: [700000073fbe368,700000073fbd368]
ckptq: [700000073fbd3d8,700000073fbebd8] fileq: [700000073fbd3e8,700000073fbebe8]
st: XCURRENT md: NULL rsop: 0x0 tch: 1
flags: buffer_dirty gotten_in_current_mode redo_since_read
LRBA: [0x10e17.d108.0] HSCN: [0x0004.02150ff1] HSUB: [1] RRBA: [0x0.0.0]
buffer tsn: 4 rdba: 0x0339451d (12/3753245)
scn: 0x0004.02150ff1 seq: 0x06 flg: 0x00 tail: 0x0ff10606
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump: 0x0339451d
Object id on Block? Y
seg/obj: 0x1e9b00 csc: 0x04.2150fef itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x3394509 ver: 0x01
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0001.00e.00d3c2d8 0x0080c4b0.17a7.4c ---- 33 fsc 0x0000.00000000
0x02 0x0001.01c.00d3c398 0x00c046a0.179c.05 C-U- 0 scn 0x0004.02150f41
on Jan 9 10:48:36 2017
Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:
ORA-00600: 内部错误代码,参数: [6002], [6], [28], [1], [52], [], [], []
Mon Jan 9 10:48:37 2017
Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:
ORA-00600: 内部错误代码,参数: [6006], [1], [], [], [], [], [], []
Mon Jan 9 10:48:39 2017
Errors in file /oracle/admin/jzh/udump/jzh_ora_491554.trc:
ORA-00603: ORACLE 服务器会话因致命错误而终止
ORA-00600: 内部错误代码,参数: [6006], [1], [], [], [], [], [], []
Mon Jan 9 10:52:43 2017
PMON failed to delete process, see PMON trace file
Mon Jan 9 10:57:18 2017
Thread 1 advanced to log sequence 69144
Current log# 1 seq# 69144 mem# 0: /oradata/jzh/redo01.log
Mon Jan 9 10:57:18 2017
ARC0: Evaluating archive log 3 thread 1 sequence 69143
ARC0: Beginning to archive log 3 thread 1 sequence 69143
说明:该错误是因为oracle要在索引中插入键值,插入之前会去检查索引叶子块记录的行数,数据量大小,如果不匹配就会报错
解决方法是找出对应的索引,删除或rebuild就可以。
jzh_ora_491554.trc文件:
BH (0x700000073fbdb00) file#: 12 rdba: 0x0339451d (12/3753245) class 1 ba: 0x700000073776000
set: 18 dbwrid: 1 obj: 2005760 objn: 2005760 ---object_id 2005760就是索引
hash: [700000156f5bb00,700000156f5bb00] lru: [700000073fbe368,700000073fbd368]
ckptq: [700000073fbd3d8,700000073fbebd8] fileq: [700000073fbd3e8,700000073fbebe8]
st: XCURRENT md: NULL rsop: 0x0 tch: 1
flags: buffer_dirty gotten_in_current_mode redo_since_read
LRBA: [0x10e17.d108.0] HSCN: [0x0004.02150ff1] HSUB: [1] RRBA: [0x0.0.0]
buffer tsn: 4 rdba: 0x0339451d (12/3753245)
scn: 0x0004.02150ff1 seq: 0x06 flg: 0x00 tail: 0x0ff10606
frmt: 0x02 chkval: 0x0000 type: 0x06=trans data
Block header dump: 0x0339451d
Object id on Block? Y
seg/obj: 0x1e9b00 csc: 0x04.2150fef itc: 2 flg: E typ: 1 - DATA
brn: 0 bdba: 0x3394509 ver: 0x01
inc: 0 exflg: 0
Itl Xid Uba Flag Lck Scn/Fsc
0x01 0x0001.00e.00d3c2d8 0x0080c4b0.17a7.4c ---- 33 fsc 0x0000.00000000
0x02 0x0001.01c.00d3c398 0x00c046a0.179c.05 C-U- 0 scn 0x0004.02150f41
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10271187/viewspace-2132279/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-2132279/