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,
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;
After you move and recover the data file, if you still see any block corruption then refer the below link
Time for Change: Migrate your Non-RAC Database to RAC
Manage Access Control List in Oracle 11g and ORA-24247