snaik_44
05-06-2001, 04:25 PM
Hi Guys
I have following scenario. I have one instance name CRP on Server1 and I created control trace file using for CRP. And total cold backup (including control and redo logfiles).
Now I created another instance TST on the same machine.
I edited the control trace file (which I cretaed for CRP) , to coreesponds the TST instance, Then I moved the all the datafiles backup in cold back from CRP, to the TST instance.
Then I started TST instance with no mount.
Then I tried to create control file by runing above trace file , but I get following error, I even tried to shuting down CRp before I create and starting the TST instance.
Error Message
Buffers 180224 bytes
SVRMGR> @ccq.sql
CREATE CONTROLFILE REUSE SET DATABASE "TST" RESETLOGS NOARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name TST in file header does not match given name
of CRP
ORA-01110: data file 82: '/d02/oradata/TST/user_idx.dbf'
ORA-01507: database not mounted
ALTER DATABASE OPEN
Any Help
Thanks
Sanjay
I have following scenario. I have one instance name CRP on Server1 and I created control trace file using for CRP. And total cold backup (including control and redo logfiles).
Now I created another instance TST on the same machine.
I edited the control trace file (which I cretaed for CRP) , to coreesponds the TST instance, Then I moved the all the datafiles backup in cold back from CRP, to the TST instance.
Then I started TST instance with no mount.
Then I tried to create control file by runing above trace file , but I get following error, I even tried to shuting down CRp before I create and starting the TST instance.
Error Message
Buffers 180224 bytes
SVRMGR> @ccq.sql
CREATE CONTROLFILE REUSE SET DATABASE "TST" RESETLOGS NOARCHIVELOG
*
ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name TST in file header does not match given name
of CRP
ORA-01110: data file 82: '/d02/oradata/TST/user_idx.dbf'
ORA-01507: database not mounted
ALTER DATABASE OPEN
Any Help
Thanks
Sanjay