RE: database hung

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Sun, 11 Oct 2009 17:54:51 -0400
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F22A985AE_at_AAPQMAILBX02V.proque.st>



Have you tried rebuilding the index?

Alter index <index_name> rebuild;

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Kar Sent: Sunday, October 11, 2009 12:06 PM
To: Frits Hoogland
Cc: Oracle-L_at_freelists.org
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_at_gmail.com<mailto:frits.hoogland_at_gmail.com>> 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_at_gmail.com<mailto:kp0773_at_gmail.com>> 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_at_gmail.com<mailto:frits.hoogland_at_gmail.com>> 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_at_gmail.com<mailto:kp0773_at_gmail.com>> 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

--

http://www.freelists.org/webpage/oracle-l Received on Sun Oct 11 2009 - 16:54:51 CDT

Original text of this message