Dear Patricia,

Thanks for your response.

I've done exactly what you have specified
here("newdbname" and RESETLOGS). The ccf.sql includes
datafile which has header with my old db name(SAMI.

ORA-01161: database name SAMI in file header does not
match given name of CLONEDB

Any help would be really appreciated...

Thanks
Sami


--- Patricia Phung <Patricia.[Email Address Removed] 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] Sent: 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] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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 documentation is here:
> http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
> To unsubscribe: send a blank email to
> oracledba-[Email Address Removed] To subscribe: send a blank email to
> oracledba-[Email Address Removed] Visit 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
>


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