-
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
sanjay
-
Hi Sanjay,
Please remove the "REUSE" from the "create controlfile"
statement !
Regards,
Robert.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|