Re: Creating/renaming a clone database
- From: Mark Brinsmead <mark.brinsmead@xxxxxxx>
- To: makbo@xxxxxxxxxxx
- Date: Fri, 11 Nov 2005 18:46:09 -0700
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
