RE: Block corruption on an index datafile

From: Jiang, Lu <Lu.Jiang_at_umassmed.edu>
Date: Tue, 13 Dec 2011 02:49:47 -0500
Message-ID: <E456CBDCBA39124DA45560EA116A22E7C83D2FBE4B_at_MBLEXCH.mbl.org>



I have fixed this issue with blockrecover command ^_^

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jiang, Lu Sent: Tuesday, December 13, 2011 1:15 AM To: oracle-l_at_freelists.org
Subject: Block corruption on an index datafile

Hi all,

I am getting error ' ORA-19566: exceeded limit of 0 corrupt blocks for file ...'. I found out that the corrupt block is on an index. Recreated the index only moved the index out of the corrupt block. Now the corrupt block is associated with no object. I tried to reformat the corrupt block by inserting dummy data into this block and end up with error ' ORA-01578: ORACLE data block corrupted (file # 25, block # 157844)'.

The corrupt block is in an index file. Is there any other option other than recover the datafile from backup? The last backup is one week old and the block corruption happened a few days ago.

Thanks,
Lu
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 13 2011 - 01:49:47 CST

Original text of this message