Recover missing Datafiles
418937May 29 2008 — edited May 29 2008i am using Oracle E-business suite with Oracle 10g R2 Database i made a cloning on TEST machine every thing done successfully and system is working fine after that clone but i saw in v$datafile 2 files are showing incorrect datafile name (i.e Missing00036) i and there status is recover i renamed these files to there Actual name after that i try to open / Recover these files it's showing me errors SQL> recover datafile 37;
ORA-00283: recovery session canceled due to errors
ORA-01110: data file 37: 'H:\ORACLE\PRODDATA\DISCOVERER01.DBF'
ORA-01122: database file 37 failed verification check
ORA-01110: data file 37: 'H:\ORACLE\PRODDATA\DISCOVERER01.DBF'
ORA-01206: file is not part of this database - wrong database id
Database is in noarchive log mode.