Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Creating/renaming a clone database
J. Dex 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?
>
[...]
There is another alternative. The DBNEWID utility allows one to change the dbname and/or dbid of an existing database (in your case the copy of the existing database). The actual executable name is "nid" under Unix or "nid.exe" under Windows.
If you review the steps in the documentation (Data Guard Concepts) for creating a logical standby database you'll find it includes a subset of steps to accomplish what you are trying to do.
-- Mark Bole http://www.bincomputing.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 11 2005 - 17:23:36 CST