RE: Duplicate DBIDs
- From: "Freeman, Donald" <dofreeman@xxxxxxxxxxx>
- To: <ntilbury@xxxxxxxxxxxx>, <rlsmith@xxxxxxx>, <peter.schauss@xxxxxxx>, "Oracle-L (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 26 Jan 2005 13:26:59 -0500
You can rename a database and database id using the Oracle Utility =
DBNEWID (command line) NID. If you search on it or check out the manual =
you will see its actually pretty simple.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Nick Tilbury @
Northampton
Sent: Wednesday, January 26, 2005 11:32 AM
To: rlsmith@xxxxxxx; peter.schauss@xxxxxxx; Oracle-L (E-mail)
Subject: RE: Duplicate DBIDs
We also had a similar issue. Which version of Oracle are you on ?
Renaming the database will not change it's DBID, but it can be done by =
exec=3D
uting a procedure
(the name of which escapes me for now).
8i databases having the same DBID did cause us some problems. However =
since=3D
upgrading to
9i, using RMAN duplicate database feature (which does change the DBID) =
we h=3D
ave had no problems.
Nick=3D20
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Smith, Ron L.
Sent: 26 January 2005 16:23
To: peter.schauss@xxxxxxx; Oracle-L (E-mail)
Subject: 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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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 =3D3D3D
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
--
//www.freelists.org/webpage/oracle-l
Important Notice!!
If you are not the intended recipient of this e-mail message, any use, =
=3D3D
distribution or copying of the message is prohibited.
Please let me know immediately by return e-mail if you have received =
=3D3D
this message by mistake, then delete the e-mail message.
Thank you.
--
//www.freelists.org/webpage/oracle-l
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D
This message is intended solely for the use of the individual or =
organisati=3D
on to whom it is addressed. It may contain privileged or confidential =
info=3D
rmation. If you have received this message in error, please notify the =
ori=3D
ginator immediately. If you are not the intended recipient, you should =
not=3D
use, copy, alter, or disclose the contents of this message. All =
informati=3D
on or opinions expressed in this message and/or any attachments are =
those o=3D
f the author and are not necessarily those of VarTecTelecom Europe Ltd =
or i=3D
ts affiliates. VarTec Telecom Europe Ltd accepts no responsibility for =
loss=3D
or damage arising from its use, including damage from virus.=3D20
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D=
3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D3D=3D
=3D3D=3D3D=3D3D=3D3D=3D3D
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
