Re: database hung

From: Kar <kp0773_at_gmail.com>
Date: Sun, 11 Oct 2009 12:05:54 -0700
Message-ID: <39a33df90910111205w6da5e644sc15c3db3d856b326_at_mail.gmail.com>

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>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> 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
>> > 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> 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 - 14:05:54 CDT