前言
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