======================================================= Oracle: Identify the database ID (DBID) ======================================================= :Title: Oracle: Identify the database ID (DBID) :Author: Douglas O'Leary :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) 3. From the alert log: look for a automatic backup.