Oracle: Identify the database ID (DBID)

Title:

Oracle: Identify the database ID (DBID)

Author:

Douglas O’Leary <dkoleary@olearycomputers.com>

Description:

Oracle: Identify the database ID (DBID)

Date created:

07/22/2010

Date updated:

07/22/2010

Disclaimer:

Standard: Use the information that follows at your own risk. If you screw up a system, don’t blame it on me…

The DBID will come into play if you have to recover a control file from an automated rman backup. Go figure, this information isn’t readily available unless you know where to look. You can find the DBID in the following places:

  1. from the v$database view:

    SQL> select name, dbid from v$database;

NAME            DBID
--------- ----------
OCI1      1369681761

  2. From the rman opening screens:

    $ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jul 22 16:40:46 2010
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
connected to target database: OCI1 (DBID=1369681761)

  1. From the alert log: look for a automatic backup.