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.