Determining your Database DBID – RMAN

Determining your database DBID

In situations requiring the recovery of your SPFILE or control file from autobackup, such as disaster recovery when you have lost all database files, you will need to use your DBID. Your DBID should be recorded along with other basic information about your database, as recommended in “Deciding Between ARCHIVELOG and NOARCHIVELOG Mode”.

If you do not have a record of the DBID of your database, there are two places you can find it without opening your database.

* The DBID is used in forming the filename for the control file autobackup. Locate that file, and then refer to “Configuring the Control File Autobackup Format” to see where the DBID appears in the filename.
* If you have any text files that preserve the output from an RMAN session, the DBID is displayed by the RMAN client when it starts up and connects to your database. Typical output follows:

% rman TARGET /
Recovery Manager: Release – Production on Sun Jun 12 02:41:03 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: RDBMS (DBID=774627068)


the DBID will be the same if you upgrade your database from lower version to higher

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

%d bloggers like this: