BEPAAL DBID VAN EEN UNMOUNTED DATABASE

Het is handig om alle dbid van te voren in een lijst te zetten.

als je dit niet hebt gedaan en er is een calamiteit (CRASH) dan kan je het op de volgende manier bepalen op Linux omgeving

[oracle@dmo-node2 pfile]$ strings /u01/app/oracle/fast_recovery_area/CDBDMO/backupset/2014_09_30/o1_mf_nnndf_TAG20140930T155953_b2ofyn4d_.bkp |grep MAXVALUE,

2708288305, MAXVALUE,
...

dbid is dan 2708288305

Toelichting

DBID can be seen from backup piece or any image copy that holds either SYSTEM or SYSAUX or UNDO datafiles. 

LETOP: Though if you backup your database as backup as compressed then with this method you will not be able to discover DBID.

If you have SYSTEM datafile or UNDO datafile either as image copy or as backup piece then you can use,

strings file_name |grep MAXVALUE, (In case of SYSTEM datafile)

strings file_name |grep MAXVALUE (In case of UNDO datafile)

to find DBID.

If you have SYSAUX datafile either as image copy or as backup piece then you can use,

strings file_name |grep DBID= to find DBID.