There is weird. I just blogged about this. You'll want to edit your create controlfile statement so that it reads CREATE CONTROLFILE *SET* DATABASE "DB2" RESETLOGS NOARCHIVELOG ..... On 11/11/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > > I know about Metalink Note 15390.1. The complication I am having is that > there is intially two databases on the same box with the same SID. DB1 was > restored to other mount points in order to create DB2. I now need to > startup DB2 so I created a script to create a controlfile with the new > directory structure and I get the error below. I don't want to start it up > as DB1 and run "Alter database rename file..." because I don't want to > accidentally mess up the original DB1. Has anyone done this before? > > CREATE CONTROLFILE REUSE DATABASE "DB2" RESETLOGS NOARCHIVELOG > * > ERROR at line 1: > ORA-01503: CREATE CONTROLFILE failed > ORA-01161: database name DB1 in file header does not match given name of > DB2 > ORA-01110: data file 1: '/d03/oradata/db2/system01.dbf' > > > > > > > > >From: Ranko Mosic <ranko.mosic@xxxxxxxxx> > >To: cemail_219@xxxxxxxxxxx > >CC: oracle-l@xxxxxxxxxxxxx > >Subject: Re: Creating/renaming a clone database > >Date: Thu, 10 Nov 2005 22:06:05 -0500 > > > > Note:15390.1 *Subject: * How to Determine and Change DB_NAME or > >ORACLE_SID > >rm > > > >On 11/10/05, J. Dex <cemail_219@xxxxxxxxxxx> wrote: > > > > > > I have database #1 on a server that I want to clone/restore from a > cold > > > backup so that it becomes database #2. Database #2 wiill be on the > same > > > server as #1 but I want to rename it. Other than creating a new > >directory > > > structure and recreating the controlfile with all the new info, is > there > > > anything else that I need to do? Do you have to alter anything within > >the > > > database (file names/structures) or will recreating the controlfile > take > > > care of it? > > > > > > I don't want to bring the database up as the old SID because the SID > > > already > > > exists on that server so if something does have to be altered, I am > not > > > sure > > > how to do it in this scenario. > > > > > > Thanks for your help. > > > > > > _________________________________________________________________ > > > Express yourself instantly with MSN Messenger! Download today - it's > >FREE! > > > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > > > > > -- > > > //www.freelists.org/webpage/oracle-l > > > > > > > > > > > _________________________________________________________________ > Express yourself instantly with MSN Messenger! Download today - it's FREE! > http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/ > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.com