近日某客戶系統遭遇如下錯誤導致資料庫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

ORA-00600: 內部錯誤程式碼，引數: [6002], [6], [28], [1], [52], [], [], []

相關文章