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 Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s