Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Creating/renaming a clone database
Mark Bole wrote:
> J. Dex wrote:
>
>> I know about Metalink Note 15390.1 [...]
>>
> [...]
>
> 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.
>
You'll probably want to use "nid" in any event -- if you plan to use
RMAN to backup both the original and the clone, at least. RMAN expected
DBIDs to be unique, and it won't be one bit happy if they are not. Even
if you don't happen to use RMAN today, having multiple databases with
the same DBID laying around could be considered a "ticking time-bomb"...
Of course, if you do happen to be using RMAN for your backups, the DUPLICATE DATABASE command in RMAN provides a darned handy means of cloning them, and it pretty much takes care of every consideration discussed in this thread.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 11 2005 - 19:48:16 CST