Thanks Jared, Kirti and Dennis for answering my question. Case closed. Man this list is so fast compared to OWS :-)
Cheerio: Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. ----- Original Message ----- To: <[EMAIL PROTECTED]>; "Ferenc Mantfeld" <[EMAIL PROTECTED]> Sent: Tuesday, February 25, 2003 9:59 AM > > 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: Ferenc Mantfeld 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).
