4 Replies Latest reply: Dec 3, 2012 6:53 AM by scolari-ire RSS

    Corrupt Data Blocks (No Backup)

    scolari-ire
      Hi All,

      I have a database that has 5 corrupt blocks on it. It tuns out that we have no backup for this database.
      I have done a bit of research and Ive used the DBMS_REPAIR to tell oracle to ignore these corrupt blocks and have rebuilt the index's involved.

      The senior DBA has told me that there is another way to "format" the blocks so we don't lose as much data. He is away so I cant ask him. I have looked online and I am of the opinion it is not possible to restore any other way.

      Can anyone tell me, is there a way to restore these corrupt blocks other than using a backup (i know !) or using the DBMS_REPAIR package.

      Thanks