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