Friday, 1 August 2014

Oracle: How to Find the Database ID (DBID)

Every Oracle database has it's unique identifier called DBID which is necessary in most critical situations like recovery from loss of all control file using rman autobackup.

How to Find Oracle DBID

How to find Oracle DBID ?


Method 1:

You can easily find using V$database view:


SQL> select dbid from v$database;

      DBID
----------
3561501577

Method 2:

Find using RMAN:


C:\windows\system32>rman target /

Recovery Manager: Release 11.2.0.1.0 - Production on Fri Aug 1 18:06:14 2014

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: TEST11 (DBID=3561501508)



No comments:

Post a Comment