Re: database hung
- From: Kar <kp0773@xxxxxxxxx>
- To: cicciuxdba@xxxxxxxxx
- Date: Sun, 11 Oct 2009 18:30:56 -0700
dbverify report corrupted blocks . we might end up recreating a new database
from scratch.:-(.
On Sun, Oct 11, 2009 at 3:25 PM, Guillermo Alan Bort
<cicciuxdba@xxxxxxxxx>wrote:
> If you have corruption-causing ora-600 or ora-600 caused by corruption, I'd
> suggest stopping the application and recreating the DB from scratch ASAP.
>
> Also, if the corruption is physical, rebuilding the index MIGHT help.
>
> have you tried dbverify?
>
> cheers
> Alan Bort
> Oracle Certified Professional
>
>
> On Sun, Oct 11, 2009 at 6:54 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:
>
>> 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> 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> 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>
>> 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> 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
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>
>
Other related posts:
