查看DBID的方法

前言

     DBID是DataBase IDentifier的缩写，意思就是数据库的唯一标识符。这个DBID在数据文件头和控制文件都是存在的，可以用于标示数据文件的归属。 对于不同数据库来说，DBID应当不同，而db_name则可能是相同的。 在我们进行数据库恢复时，有时必须要知道DBID，下面分两种情况总结了查询DBID的方法。

1. 当数据库能够mount或open时：

(1) 从v$database查询获得：

select dbid,open_mode from v$database; 

(2) rman登录时，显示出dbid；

(3) 从自动备份控制文件集的名字查询DBID;

(4) 通过oracle event来获取：

   a.dump数据文件头：

    [oracle@bond ~]$ sqlplus / as sysdba

    SQL> alter system set events 'immediate trace name file_hdrs level 3';

    

    System altered.

    SQL> oradebug setmypid;

    Statement processed.

    SQL> oradebug tracefile_name;

     /u01/app/oracle/diag/rdbms/bond/bond/trace/bond_ora_10759.trc

查看 bond_ora_10759.trc内容，以下是部分内容：

Trace file /u01/app/oracle/diag/rdbms/bond/bond/trace/bond_ora_10759.trc

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1

System name:    Linux

Node name:      bond

Release:        3.10.0-327.el7.x86_64

Version:        #1 SMP Thu Nov 19 22:10:57 UTC 2015

Machine:        x86_64

VM name:        VMWare Version: 6

Instance name: bond

Redo thread mounted by this instance: 1

Oracle process number: 28

Unix process pid: 10759, image: oracle@bond (TNS V1-V3)

*** 2019-08-17 18:00:58.374

*** SESSION ID:(36.9) 2019-08-17 18:00:58.374

*** CLIENT ID:() 2019-08-17 18:00:58.374

*** SERVICE NAME:(SYS$USERS) 2019-08-17 18:00:58.374

*** MODULE NAME:(sqlplus@bond (TNS V1-V3)) 2019-08-17 18:00:58.374

*** ACTION NAME:() 2019-08-17 18:00:58.374

 

DUMP OF DATA FILES: 5 files in database

 

DATA FILE #1: 

  name #7: /u01/app/oracle/oradata/bond/system01.dbf

creation size=0 block size=8192 status=0xe head=7 tail=7 dup=1

 tablespace 0, index=1 krfil=1 prev_file=0

 unrecoverable scn: 0x0000.00000000 01/01/1988 00:00:00

 Checkpoint cnt:103 scn: 0x0000.000fcb09 08/17/2019 17:55:17

 Stop scn: 0xffff.ffffffff 08/17/2019 17:50:52

 Creation Checkpointed at scn:  0x0000.00000007 08/24/2013 11:37:33

 thread:0 rba:(0x0.0.0)

 enabled  threads:  00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

  00000000 0000000