Home » RDBMS Server » Backup & Recovery » recover missing datafile (Oracle 10g, R2, Windows 2003 Sp2)
recover missing datafile [message #323650] Thu, 29 May 2008 02:32 Go to next message
Messages: 49
Registered: April 2007
Location: Islamabad
i 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.
Re: recover missing datafile [message #323989 is a reply to message #323650] Fri, 30 May 2008 04:12 Go to previous message
Rajabaskar Thangaraj
Messages: 13
Registered: March 2008
Location: CHENNAI
Junior Member
alter database backup controlfile to trace; --

see the control file structure and check the 'H:\ORACLE\PRODDATA\DISCOVERER01.DBF' datafile path.

compare the production database controlfile trace and clone database control file.


Previous Topic: Dynamic Performance tables and views
Next Topic: Rman Backup with plus archivelog
Goto Forum:

Current Time: Sun Aug 20 06:56:08 CDT 2017

Total time taken to generate the page: 0.01036 seconds