Re: database hung
- From: Kar <kp0773@xxxxxxxxx>
- To: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- Date: Sun, 11 Oct 2009 18:25:56 -0700
table rebuild fails with ORA-1578 when it encounters the first corrupted
block.
On Sun, Oct 11, 2009 at 3:17 PM, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>wrote:
> Oh, then in that case, you can do:
>
> Alter table <table_name> move;
>
> Which will rebuild the index.
>
>
>
> If you’re worried about uptime/availability, you can add the ‘online’
> option:
>
> Alter table <table_name> move online;
>
>
>
> Details are here:
>
>
> http://download.oracle.com/docs/cd/E11882_01/server.112/e10595/tables012.htm#ADMIN11695
>
>
>
> Hope that helps,
>
>
>
> -Mark
>
>
>
> *From:* Kar [mailto:kp0773@xxxxxxxxx]
> *Sent:* Sunday, October 11, 2009 3:13 PM
> *To:* Bobak, Mark
> *Subject:* Re: database hung
>
>
>
> I cannot as it is part of the IOT primary index..occasionaly I see these
> errors in the alert log.
>
> Corrupt Block Found
>
> TSN = 7, TSNAME = MTRX_DATA
>
> RFN = 102, BLK = 60122, RDBA = 927951954
>
> OBJN = 8514, OBJD = 8514, OBJECT = MTRX_RFC_PK, SUBOBJECT =
>
> SEGMENT OWNER = MTRX_ADMIN, SEGMENT TYPE = Index Segment
>
> and few blocks reported in the datafiles for this table reported as
> logical corrupt in v$database_block_corruption,
>
> On Sun, Oct 11, 2009 at 2: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:
