Have you tried rebuilding the index? Alter index <index_name> rebuild; From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Kar Sent: Sunday, October 11, 2009 12:06 PM To: Frits Hoogland Cc: Oracle-L@xxxxxxxxxxxxx Subject: Re: database hung Thanks Fris. This is a corruption on the index. but not a deferred constraint issue as per my understanding so far. On Sun, Oct 11, 2009 at 11:01 AM, Frits Hoogland <frits.hoogland@xxxxxxxxx<mailto:frits.hoogland@xxxxxxxxx>> wrote: you could filter out possible reasons, and investigate further on these, please mind you've given little information. kd = kernel data layer dummy = ? blkchk = blockcheck quite probably, [6401] would be the reason. please mind I am guessing here. when searching for kddummy_blkchk and 6401, bug 8613137 showed. version affected with this bug is 11.1.0.7 (not your version), and deferred contraints and an index block corruption. is that the case here? frits On Sun, Oct 11, 2009 at 4:39 PM, Kar <kp0773@xxxxxxxxx<mailto:kp0773@xxxxxxxxx>> wrote: Thanks Fris. somehow I could not find a explanation for the repetition issue I am getting . On Sun, Oct 11, 2009 at 6:41 AM, Frits Hoogland <frits.hoogland@xxxxxxxxx<mailto:frits.hoogland@xxxxxxxxx>> wrote: have a look at ML note: 300581.1; that article links to several other ML note's, with issues with this OERI frits On Sun, Oct 11, 2009 at 12:27 AM, kp R <kp0773@xxxxxxxxx<mailto:kp0773@xxxxxxxxx>> wrote: All, recently we got into a database(10gR2) hang situation and we were forced to abort the instance . This database has few corrupted blocks which shows in v$database_block_corrutpion and occasionally we get ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [kddummy_blkchk], [18], [109812], [6401], [], [], [], [] but this time we observed a cycle of message as shown below coming for 2 hour so we decided to abort the instance . I have a SR opened but so far the support is not very helpful giving any reason. I was wondering if anyone has any idea on this . Doing block recovery for file 18 block 109812 Block recovery from logseq 7907, block 479993 to scn 23018333209 Thu Oct 8 10:05:07 2009 Recovery of Online Redo Log: Thread 1 Group 2 Seq 7907 Reading mem 0 Mem# 0: /mtrx/oradata/pmtrx/onlinelog/o1_mf_2_5azw407p_.log Mem# 1: /mtrx/oradata/pmtrx/onlinelog/o1_mf_2_5azw44op_.log Thu Oct 8 10:05:07 2009 Recovery of Online Redo Log: Thread 1 Group 3 Seq 7908 Reading mem 0 Mem# 0: /mtrx/oradata/pmtrx/onlinelog/o1_mf_3_6azx44op_.log Mem# 1: /mtrx/oradata/pmtrx/onlinelog/o1_mf_3_6azx4fop_.log Block recovery interrupted at rba 7908.155763.340 Doing block recovery for file 18 block 109812 Block recovery from logseq 7907, block 479993 to scn 23018333209 Thu Oct 8 10:05:08 2009 Recovery of Online Redo Log: Thread 1 Group 2 Seq 7907 Reading mem 0 Mem# 0: /mtrx/oradata/pmtrx/onlinelog/o1_mf_2_5azw407p_.log Mem# 1: /mtrx/oradata/pmtrx/onlinelog/o1_mf_2_5azw44op_.log Thu Oct 8 10:05:08 2009 Recovery of Online Redo Log: Thread 1 Group 3 Seq 7908 Reading mem 0 Mem# 0: /mtrx/oradata/pmtrx/onlinelog/o1_mf_3_6azx44op_.log Mem# 1: /mtrx/oradata/pmtrx/onlinelog/o1_mf_3_6azx4fop_.log Block recovery interrupted at rba 7908.155763.340 Doing block recovery for file 18 block 109812 Thanks in advance -Kar