Re: Creating/renaming a clone database

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_at_hotmail.com> 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_at_gmail.com>
> >To: cemail_219_at_hotmail.com
> >CC: oracle-l_at_freelists.org
> >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_at_hotmail.com> 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/
> > >
> > > --
> > > http://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/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l