Home > Oracle > How To Determine The DBID When Using RMAN

How To Determine The DBID When Using RMAN


1)  If your database is open you may issue the following query:
SQL>  SELECT dbid FROM v$database;

      DBID
----------
1411146558


2)  If you are using a recovery catalog then connect to the recovery catalog via
RMAN and issue the "list incarnation" command. You must first nomount the target
database.  For example:

D:\> rman target <user>/<pwd>@mydb rcvcat <user>/<pwd>@rcat

Recovery Manager: Release 8.1.7.4.1 - Production

RMAN-06193: connected to target database (not started)
RMAN-06008: connected to recovery catalog database

RMAN> startup nomount

RMAN-06196: Oracle instance started

Total System Global Area      94980124 bytes

Fixed Size                       75804 bytes
Variable Size                 57585664 bytes
Database Buffers              37240832 bytes
Redo Buffers                     77824 bytes

RMAN> list incarnation;

RMAN-03022: compiling command: list

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            CUR Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       2       ORCL817  1411146558       YES 282854     03-DEC-02
--------------------------------------------------------------------------------


3)  If you have a saved copy of the screen details from a previous RMAN session
you may refer to this output for the dbid.  For example:

D:\> rman target <user>/<pwd>@mydb rcvcat <user>/<pwd>@rcat

Recovery Manager: Release 8.1.7.4.1 - Production

RMAN-06005: connected to target database: ORCL817 (DBID=1411146558)
RMAN-06008: connected to recovery catalog database
--------------------------------------------------------------------------------


4)  If you are using RMAN with version 9i you have the ability to configure the
automatic backup of your control files.  If you have this feature on locate one
of your control file autobackups.  The name of this file will tell you the dbid
of your database. For example:

D:\ORACLE\ORA92\DATABASE> dir
Volume in drive D has no label.
Volume Serial Number is 3E3B-12FD

Directory of D:\ORACLE\ORA92\DATABASE

11/20/2002  02:06p      <DIR>          .
11/20/2002  02:06p      <DIR>          ..
01/23/2003  11:12a           2,064,384 C-2282329623-20030123-00
...

In this case 2282329623 is the dbid for this database.


5)  If the four steps above are not available because you have lost all the files
for your database, you are not using a recovery catalog, you are not using
autobackup of your controlfile, etc., but you have an old control file available,
mount the database with the old control file then query v$database as in step 1
to obtain the dbid of your database.


6)  If the platform is UNIX and you have a datafile still on disk for the problem database, you may
be able to obtain the DBID using the strings command as in the following example:

$ strings undotbs01.dbf  | grep MAXVALUE

3587267724, MAXVALUE
... etc.

The output above shows the DBID in this example to be 3587267724

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: