Re: question on v$database.DBID

From: Jared Still <jkstill_at_cybcon.com>
Date: Mon, 24 Feb 2003 15:09:09 -0800
Message-ID: <F001.00557C11.20030224150909@fatcity.com>

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: jkstill_at_cybcon.com

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).

Received on Mon Feb 24 2003 - 17:09:09 CST