Re: question on v$database.DBID

[Tim Gorman]

Nope.  Not even an OPEN RESETLOGS or CREATE CONTROLFILE changes the DBID...   There is a packaged procedure DBMS_BACKUP_RESTORE.ZERODBID that is discussed in numerous forums and notes in MetaLink, but a good starting point would be MetaLink note #174625.1 ("RMAN: Incomplete Duplication and It's Consequences").  There is also an excellent posting in MetaLink forum #228668.995 by a gentleman named Rich Bernat of ChevronTexaco on 22-Aug 2002, down around the middle of that forum which describes exactly the steps you are interested in... ----- Original Message ----- From: Ferenc Mantfeld To: Multiple recipients of list ORACLE-L Sent: Monday, February 24, 2003 3:02 PM Subject: question on v$database.DBID Hi Everyone   Unfortunately, I don't have the time to test this out, so hopefully someone here has gone through this, and can give me a simple yes/no answer.   If I completely restore a database (DB crashed, think DR situation) and bring it up on another node, does the DBID in v$database change ? If I recreate the control file, will DBID change ?   Thanks. Regards : Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything.