Re: question on v$database.DBID

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: <ORACLE-L_at_fatcity.com>; "Ferenc Mantfeld" <mantfield_at_connexus.net.au> 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: mantfield_at_connexus.net.au

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: ListGuru_at_fatcity.com (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).