ORA-600 [kdsgrp1]
725911Aug 15 2011 — edited Aug 15 2011Hi All
We have our db patched to 11.2.0.2.3
we got the following error
ORA-00600: internal error code, arguments: [kdsgrp1], [], [], [], [], [], [], [], [], [], [], []
trace file
* kdsgrp1-1: *************************************************
row 0x030580e7.8 continuation at
0x030580e7.8 file# 12 block# 360679 slot 8 not found
KDSTABN_GET: 0 ..... ntab: 1
CHANGE #29 TYP:0 CLS:40 AFN:39 DBA:0x09c17ce7 OBJ:4294967295 SCN:0x0010.7e10a765 SEQ:6 OP:5.1 ENC:0 RBL:0
ktudb redo: siz: 100 spc: 5850 flg: 0x0022 seq: 0x190b rec: 0x0f
xid: 0x000c.01d.00045b85
ktubu redo: slt: 29 rci: 14 opc: 10.22 objn: 656941 objd: 656941 tsn: 6
Undo type: Regular undo Undo type: Last buffer split: No
Tablespace Undo: No
0x00000000
index undo for leaf key operations
KTB Redo
op: 0x02 ver: 0x01
compat bit: 4 (post-11) padding: 1
op: C uba: 0x09c17ce7.190b.0b
Dump kdilk : itl=2, kdxlkflg=0x1 sdc=32767 indexid=0xc073285 block=0x0c073286
(kdxlpu): purge leaf row
key :(28):
14 62 75 72 67 65 72 64 65 6e 63 40 67 6d 61 69 6c 2e 63 6f 6d 06 0c 05 93
d2 00 1b
and then it shows
REDO RECORD - Thread:1 RBA: 0x003ab3.000096bc.0158 LEN: 0x0048 VLD: 0x01
SCN: 0x0010.7e10a790 SUBSCN: 2 08/15/2011 10:09:40
(LWN RBA: 0x003ab3.000096bb.0010 LEN: 0002 NST: 04d SCN: 0x0010.7e10a78e)
CHANGE #1 MEDIA RECOVERY MARKER SCN:0x0000.00000000 SEQ:0 OP:18.3 ENC:0
Reuse redo entry
Object reuse: tsn=6 objd=657257
I ran the qry below for related file id and block
Select owner, segment_name, segment_type, partition_name,tablespace_name
From dba_extents
Where relative_fno = &1
And &2 between block_id and (block_id+blocks-1);
did analyze table schema.table_name validate structure cascade ; for that object
I need to know wht is cause of this message 'index undo for leaf key operations'
is it tablespace issue for the index