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 10.1.0.2.0 - Production
Copyright (c) 1995, 2003, Oracle. All rights reserved.
connected to target database: RDBMS (DBID=774627068)
RMAN>
Thursday, August 23, 2007
Determining Database DBID
Subscribe to:
Post Comments (Atom)
4 comments:
It is exact
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!
Hey, wonderful information. this post is very useful for me. thanks for sharing it..
Laptop encryption software uk
Thank you very much
Post a Comment