Home » RDBMS Server » Server Administration » DBID
DBID [message #232638] Sun, 22 April 2007 14:21 Go to next message
Messages: 157
Registered: April 2007
Location: USA
Karma: 0
Senior Member
Hi Guys,
One question arises, when we change dbname from utility nid, we can also able to change dbid. But I dont know Why we have to change dbid? Where we require dbid?

Re: DBID [message #232640 is a reply to message #232638] Sun, 22 April 2007 14:47 Go to previous messageGo to next message
Michel Cadot
Messages: 65153
Registered: March 2007
Location: Nanterre, France, http://...
Karma: 0
Senior Member
Account Moderator
Register database and backup/restore with RMAN.
DBID is the primary key for RMAN to know which backup belongs to which database.

Now the question is "why we have to change dbname?". Smile

Re: DBID [message #232680 is a reply to message #232640] Mon, 23 April 2007 00:29 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Karma: 0
Senior Member

hi harshad,

Found this thing, may be it's helpful to you...
"Because Recovery Manager (RMAN) distinguishes databases by DBID, you could not register a seed database and a manually copied database together in the same RMAN repository.The DBNEWID utility solves this problem by allowing you to change any of the following:
Only the DBID of a database
Only the DBNAME of a database
Both the DBNAME and DBID of a database "

also go through this link. Same question is discussed here..

Previous Topic: Oracle 9i Database Installation
Next Topic: Data Scrambling
Goto Forum:

Current Time: Tue Aug 22 10:03:16 CDT 2017

Total time taken to generate the page: 0.01836 seconds