 | | | Creating/renaming a clone database | Creating/renaming a clone database 2005-11-11 - By J. Dex
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 (See ORA-01503.ora-code.com): CREATE CONTROLFILE failed
ORA-01161 (See ORA-01161.ora-code.com): database name DB1 in file header does not match given name of
DB2
ORA-01110 (See ORA-01110.ora-code.com): data file 1: '/d03/oradata/db2/system01.dbf'
>From: Ranko Mosic <ranko.mosic@(protected)>
>To: cemail_219@(protected)
>CC: oracle-l@(protected)
>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@(protected)> 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
|
|
|