Saturday, April 16, 2011

How To Determine the DBID ?

The DBID is a unique identifier. It is found in all datafile headers. The DBID is used to identifiy the database a file belongs to.  There may be situations where we need the recovery of the spfile or control file from autobackup, such as disaster recovery when we have lost all database files , then in such case  we will need  to determine the DBID to restore the database . If we do not have a record of the DBID of database, there are two places from where we can easily find it.

1.) The DBID is used in forming the filename for the control file autobackup. Below is the name of my autobackup controlfile name    ==  C-1502483083-20110416-00

Here 1502483083 specifies  the DBID   and 20110416  specifies the date i.e, 16th april 2011

2.) If we 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 sys/xxxx@noida
Recovery Manager: Release - Production on Sat Apr 16 17:23:28 2011
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
connected to target database: NOIDA (DBID=1502483083)

Enjoy      J J J

No comments: