| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Creating/renaming a clone database
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
> >
> >
> >
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 11 2005 - 08:40:43 CST
 |
 |