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
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: 64729
Registered: March 2007
Location: Nanterre, France, http://...
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
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: Check view consists of which tables
Next Topic: Truncate slow
Goto Forum:

Current Time: Thu Apr 27 15:53:01 CDT 2017

Total time taken to generate the page: 0.09478 seconds