RE: Block corruption on an index datafile

  • From: "Jiang, Lu" <Lu.Jiang@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 13 Dec 2011 02:49:47 -0500

I have fixed this issue with blockrecover command ^_^

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jiang, Lu
Sent: Tuesday, December 13, 2011 1:15 AM
To: oracle-l@xxxxxxxxxxxxx
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. 



Other related posts: