Hi,
I am using oracle database 11g(11.2.0.1) in OEL5.I wanted to clone my development db using its cold backup to different db name in same server.I have cloned it successfully but mistakenly i missed one datafile in my control file recreation script.So i was able to open the database but file 5 is in recovery status as shown below.
FILE# NAME STATUS
---------- ------------------------------------------------------------------------------------------ -------
5 /u01/app/oracle/product/11.2.0/db_1/dbs/MISSING00005 RECOVER
Now i added the original file 5 from cold backup in the control file and tried to recreate the control file but i face the below error.
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name DEVDB in file header does not match given name of
TESTDB
ORA-01110: data file 5: '/u01/TEST2.dbf'
All the other datafiles headers are having new DB name since i opend the database already but this file 5 header alone is having old db name.
How to resolve this??
Do i need to copy all the datafiles again and recreate the controlfile with new DB name??
Regards,
007