Hi,
I am using Oracle database 11.2.0.1.0 in OEL5 server. I want to clone my development database in the same server with different db name.I have cloned the database from cold backup and recreated the controlfile with new database name and opened the database successfully. But unfortunately i have missed one file in control file recreation script.Due to this datafile 5 is in missing and status is in recovery as shown below.
FILE# NAME STATUS
---------- ------------------------------------------------------------------------------------------ -------
5 /u01/app/oracle/product/11.2.0/db_1/dbs/MISSING00005 RECOVER
Now i want to bring the original datafile from the cold backup into this database where all the other datafiles headers are updated with new db name.So for this i shutdown the db and started in nomount and added the original datafile 5 in the control file script and tried to recreate the controlfile but i face the below error.
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name ORADB in file header does not match given name of TEST
ORA-01110: data file 5: '/u01/TEST2.dbf'
How to add one datafile alone in the database where its header is having old db name while other datafiles headrer are having new db name???
Do i need to recreate controlfile with all other datafiles having old db name along with datafile 5??
Regards,
007