| recover missing datafile [message #323650] |
Thu, 29 May 2008 02:32  |
emind
Messages: 49
Registered: April 2007
Location: Islamabad
|
Member |
|
|
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  |
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.
Regards
RajaBaskar
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
