Oracle: Identify the database ID (DBID)

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)
   	
    From the alert log: look for a automatic backup.
   	
    Other useful hints available at http://arjudba.blogspot.com/2008/05/how-to-discover-find-dbid.html