RE: Duplicate DBIDs

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.

Ron

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

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Schauss, Peter Sent: Wednesday, January 26, 2005 10:12 AM To: Oracle-L (E-mail)
Subject: Duplicate DBIDs

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 =3D

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?

Thanks,
Peter Schauss
--

http://www.freelists.org/webpage/oracle-l

Important Notice!!
If you are not the intended recipient of this e-mail message, any use, = distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received = this message by mistake, then delete the e-mail message. Thank you.
--

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