RE: database hung
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