2 Replies Latest reply: Oct 11, 2012 2:34 PM by Satishbabu Gunukula RSS

    Data File Recovery Error

    966714
      Hi Guys,
      I have small problem here. Hope you guys can help me on this.
      I have Oracle 10.2.0.4.0 on RAC environment. I had 19 Data files on ASM. However one of my colleague has created new data file on a Node using Physical Drive which like this.
      G:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\DATA_001.DBF instead of +DATA/ref/datafile/data.400.70812332

      Now this file is in Recover State and when i try to make it online it says Block # 12 of this file is corrupted.

      select * from v$datafile
      20     20     6463317847     06/10/2012 10:11:18     6     20     RECOVER     READ WRITE     6467876664     07/10/2012 08:39:09     0          6468047778     07/10/2012 09:30:53     0     0          104857600     12800     104857600     8192     G:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\IFSAPP_DATA_001.DBF     0     8192     NONE     0     

      Can you guys please help me to recover this file.

      Thanks in Advance,
      Harsha
        • 1. Re: Data File Recovery Error
          Hemant K Chitale
          If you have a backup of the datafile, RESTORE it -- preferably with SET NEWNAME

          If you do not have a backup of the datafile but DO have all the ArchiveLogs since the datafile was created, you could use
          ALTER DATABASE CREATE DATAFILE fileid AS '+DATA';
          RECOVER DATAFILE fileid;
          Hemant K Chitale
          • 2. Re: Data File Recovery Error
            Satishbabu Gunukula
            After you move and recover the data file, if you still see any block corruption then refer the below link

            http://www.oracleracexpert.com/2009/08/block-corruption-and-recovery.html

            Regards,
            http://www.oracleracexpert.com
            Time for Change: Migrate your Non-RAC Database to RAC
            http://www.oracleracexpert.com/2012/10/time-for-change-migrate-your-non-rac.html
            Manage Access Control List in Oracle 11g and ORA-24247
            http://www.oracleracexpert.com/2012/09/manage-access-control-list-in-oracle.html