遭遇ORA-00600: internal error code, arguments: [4193], [0], [305]
本帖最后由 blue 于 2014-8-6 09:55 编辑各位大牛帮忙看下，数据库版本9.2.0.8，RAC双机，HP UNIX主机，open状态，有一张大表只要进行DML操作就会报如下报错，具体的trc我上传附件。
数据库是oracle9i RAC
alert.log日志显示
Mon Jul 28 11:37:53 2014
Errors in file /home/oracle/admin/ora92/udump/ora922_ora_17952.trc:
ORA-00600: internal error code, arguments: , , , [], [], [], [],[]
Mon Jul 28 11:37:53 2014
Trace dumping is performing id=
Mon Jul 28 11:39:28 2014
Doing block recovery for fno: 5 blk: 9497
block recovery range from rba1041.129905.0 to scn 3196.2987137248
Mon Jul 28 11:39:28 2014
Recovery of Online Redo Log: Thread 2 Group 3 Seq 1041 Reading mem 0
Mem# 0 errs 0: /dev/raw/raw15
completed block recovery at rba:1041.131601.72,scn:3196.2987137514
Doing block recovery for fno: 5 blk: 161
block recovery range from rba1041.129905.0 to scn 3196.2987206495
Mon Jul 28 11:39:28 2014
Recovery of Online Redo Log: Thread 2 Group 3 Seq 1041 Reading mem 0
Mem# 0 errs 0: /dev/raw/raw15
completed block recovery atrba:1041.252741.328, scn:3196.2987206496
Mon Jul 28 11:39:29 2014
Errors in file /home/oracle/admin/ora92/udump/ora922_ora_17954.trc:
ORA-00600: internal error code, arguments: , , , [], [], [], [],[]
Mon Jul 28 11:39:29 2014
Trace dumping is performing id=
Mon Jul 28 11:41:09 2014
Doing block recovery for fno: 5 blk: 9497
block recovery range from rba1041.129905.0 to scn 3196.2987137248
Mon Jul 28 11:41:09 2014
Recovery of Online Redo Log: Thread 2 Group 3 Seq 1041 Reading mem 0
Mem# 0 errs 0: /dev/raw/raw15
completed block recovery atrba:1041.131601.72, scn:3196.2987137514
Doing block recovery for fno: 5 blk: 161
block recovery range from rba1041.129905.0 to scn 3196.2987208128
新建UNDO表空间，切换UNDO为新建UNDO表空间，观察1个小时，不在报ORA-00600: internal error code, arguments: , , ，删除旧的UNDO表空间，此问题是由于恢复时redo与undo不一致所导致。 从trace文件中看，很可能和如下block 事务有关系
Block header dump:0x020de4df
Object id on Block? Y
seg/obj: 0x10c08csc: 0xc7c.b1e26fc0itc: 13flg: Otyp: 1 - DATA
fsl: 0fnx: 0x20de4e0 ver: 0x01
Itl Xid Uba FlagLck Scn/Fsc
0x01 0x0031.02d.0000291f0x01406a1e.1011.3cC--- 0scn 0x0c7c.b1e26fbd
0x02 0x000d.02b.0009e57a0x0141a0e8.6a07.0b---- 1fsc 0x0000.00000000
0x03 0x003b.008.000007100x01402a65.0b98.0f---- 1fsc 0x0000.00000000
0x04 0x000e.020.000a01b70x01406845.6c6a.09---- 1fsc 0x0000.00000000
0x05 0x0038.002.000009560x01400053.0dd1.3bC--- 0scn 0x0c7c.b1e26fbc
0x06 0x0030.016.000030c30x014020aa.10d2.48--U- 1fsc 0x0000.b1e26fc4
0x07 0x0015.02f.0001dad40x014043ba.2d03.0bC--- 0scn 0x0c7c.b1e26fbf
0x08 0x0025.011.0001ba210x014174ba.2aa5.57---- 1fsc 0x0000.00000000
0x09 0x002c.02c.000159810x01419dc0.2a83.24--U- 1fsc 0x0000.b1e26fc5
0x0a 0x0011.021.000a0dd50x01400d20.6d0d.0fC--- 0scn 0x0c7c.b1e26fbb
0x0b 0x0036.00a.000007940x0140118d.0b1a.49---- 1fsc 0x0000.00000000
0x0c 0x0035.011.000008760x01401955.0ab3.1b---- 1fsc 0x0000.00000000
0x0d 0x002b.01d.0001427c0x01405101.276a.48---- 1fsc 0x0000.00000000
具体需要结合当时的dba_rollback_segs，然后dump segment header 分析
页:
[1]