RE: Cloning DB- ORA-01503: CREATE CONTROLFILE failed

RE: Cloning DB- ORA-01503: CREATE CONTROLFILE failed

 

  

Sami,
review your ccf.sql and verify you did change this, and rerun it after the changes:
Change:
FROM: CREATE CONTROLFILE REUSE DATABASE "olddbname" NORESETLOGS ...
TO: CREATE CONTROLFILE set DATABASE "newdbname" RESETLOGS ...

FROM:
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE USING BACKUP CONTROLFILE
TO:
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
# RECOVER DATABASE USING BACKUP CONTROLFILE

Also make sure you remove all comment lines in this file (all lines that start with #)

Patricia
-----Original Message-----
From: Sami Seerangan [mailto:[Email Address Removed] Sunday, March 30, 2003 3:29 AM
To: LazyDBA.com Discussion
Subject: Cloning DB- ORA-01503: CREATE CONTROLFILE failed


Hi ALL DBAs

I went thru your document for cloning DB at

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:318216852435

I'm getting the following error in (step # 12. Run the
"ccf.sql" script )

My old DB name is SAMI
New DB name is CLONEDB

ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name SAMI in file header does not
match given name of
CLONEDB
ORA-01110: Data file 1:
'/oracle/oradata/clonedb/system01.dbf'

Could you please help me to resolve this issue.

Thanks
Sami

__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com

--------
Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:http://www.lazydba.com/legal.html

Oracle LazyDBA home page