SQL>SELECT dbid FROM v$database;
DBID
———-
1411146558
2) If you are using a recovery catalog then connect to the recovery catalog via
RMAN and issue the “list incarnation” command. You must first nomount the target
database. For example:
D:\> rman target /@mydb rcvcat /@rcat
Recovery Manager: Release 8.1.7.4.1 – Production
RMAN-06193: connected to target database (not started)
RMAN-06008: connected to recovery catalog database
RMAN> startup nomount
RMAN-06196: Oracle instance started
Total System Global Area 94980124 bytes
Fixed Size 75804 bytes
Variable Size57585664 bytes
Database Buffers 37240832 bytes
Redo Buffers 77824 bytes
RMAN> list incarnation;
RMAN-03022: compiling command: list
List of Database Incarnations
DB Key ; Inc Key DB Name ; DB ID CUR Reset SCN; Reset Time
——- ——- ——– —————- — ———- ———-
1 YES 282854 03-DEC-02
——————————————————————————–
3) If you have a saved copy of the screen details from a previous RMAN session
you may refer to this output for the dbid. For example:
D:\> rman target /@mydb rcvcat /@rcat
Recovery Manager: Release 8.1.7.4.1 – Production
RMAN-06005: connected to target database: ORCL817 (DBID=1411146558)
RMAN-06008: connected to recovery catalog database
——————————————————————————–
4)If you are using RMAN with version 9i you have the ability to configure the
automatic backup of your control files. If you have this feature on locate one
of your control file autobackups The name of this file will tell you the dbid
of your database. For example:
D:\ORACLE\ORA92\DATABASE> dir
Volume in drive D has no label.
Volume Serial Number is 3E3B-12FD
Directory of D:\ORACLE\ORA92\DATABASE
In this case 2282329623 is the dbid for this database.
5)If the four steps above are not available because you have lost all the files
for your database, you are not using a recovery catalog, you are not using
autobackup of your controlfile, etc., but you have an old control file available,
mount the database with the old control file then query v$database as in step 1
to obtain the dbid of your database.
6)If the platform is UNIX and you have a datafile still on disk for the problem database, you may
be able to obtain the DBID using the strings command as in the following example:
$ strings undotbs01.dbf | grep MAXVALUE
3587267724, MAXVALUE
… etc.
The output above shows the DBID in this example to be 3587267724
Source Site :
1-Mike Blog
Thank you
Osama Mustafa
Sharing for Knowledge
Technology Geek 