Search This Blog

Thursday, August 23, 2007

Determining 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 determine your DBID. Your DBID should be recorded along with other basic information about your database, as recommended in "Keeping Records of the Hardware and Software Configuration of the Server".

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

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:
c:\>rman TARGET /
Recovery Manager: Release - Production

Copyright (c) 1995, 2003, Oracle. All rights reserved.

connected to target database: RDBMS (DBID=774627068)



Anonymous said...

It is exact

Anonymous said...

i truly adore all your posting way, very interesting.
don't quit and keep writing in all honesty , because it just good worth to look through it,
impatient to find out more and more of your writing, have a pleasant day!

Kim said...

Hey, wonderful information. this post is very useful for me. thanks for sharing it..

Laptop encryption software uk

Mohammed Taj said...

Thank you very much