Ferenc, Not sure about recreating on new node, but just re-creating the CF doesn't cause a new DBID.
I ran the following: selecd dbid, name from v$database; create controlfile .... selecd dbid, name from v$database; Here are the results: VRMGR> @cf DBID NAME ---------- --------- 1107996183 TS01 1 row selected. Database closed. Database dismounted. ORACLE instance shut down. ORACLE instance started. Total System Global Area 94970016 bytes Fixed Size 73888 bytes Variable Size 86335488 bytes Database Buffers 8388608 bytes Redo Buffers 172032 bytes Statement processed. Statement processed. DBID NAME ---------- --------- 1107996183 TS01 1 row selected. SVRMGR> Jared On Monday 24 February 2003 14:02, Ferenc Mantfeld wrote: > 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. ---------------------------------------- Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1" Content-Transfer-Encoding: quoted-printable Content-Description: ---------------------------------------- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
