RE: Duplicate DBIDs

DBID is different from DB name in the controlfile.

The only potential problem is RMAN and the fact that it will not let you register databases with the same DBID in the same catalog.

It is easy to change the DBID. Look for the 'nid' or dbnewid utility in 9i and 10g. Also I believe more recent versions of RMAN can fix the DBID.

--

Jeremiah Wilton
ORA-600 Consulting
Emergencies - Seminars - Hiring
http://www.ora-600.net

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]

You are already going through the edit on the controlfile. Why not just rename the database at the same time?
If not someone will surely mess up your production database, thinking they are connected to the test version.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org

We have had a practice at our site of creating development and staging databases by copying a cold backup to another system. We then edit the output from "backup controlfile to trace" to rename the database and relocate the data files and restart the database with the resulting script. This means that a number of our databases, mostly on different machines, have the same DBID. So far this has not caused us any problems. Are we running any risks here?

--

http://www.freelists.org/webpage/oracle-l Received on Wed Jan 26 2005 - 11:30:31 CST