Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-600 [kdsgrp1]

725911Aug 15 2011 — edited Aug 15 2011
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 12 2011
Added on Aug 15 2011
1 comment
3,088 views