Show Oracle Database DBID

The database ID or DBID is a unique identification number computed when the database is created.

To find out this number, you can either:

1) Login to RMAN,  it will display the DBID upon connection to the target database.
    e.g. shell> rman target /


2) You can obtain the DBID by querying V$DATABASE
   eg.  SQL> select dbid from v$database;

If the database is down and you can’t access either of these two methods. There is a third way.
Assuming you have some RMAN backups for the database, the DBID is the first big number of the backup file.
For instance, if the file name was c-1235460798-20100929-01 then the DBID is 1235460798

Leave a Comment

Your email address will not be published. Required fields are marked *