如何从control file中找到DBID和DBNAME第一次在JavaEye写博客，真紧张啊！? 场景如下：[ 给定一个坏掉的contr
如何从control file中找到DBID和DBNAME
第一次在JavaEye写博客，真紧张啊！
?
场景如下：
[ 给定一个坏掉的control file，如何从中找出DBID和DBNAME ]
方法1： 使用BBED(block browser edit)，dump出control file,从中寻找dbid,dbname
1.1 配置bbed
1.1.1 安装bbed
[oracle@single udump]$ view test_ora_5628.trc
1 /opt/ora10g/admin/test/udump/test_ora_5628.trc
2 Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
3 With the Partitioning, OLAP and Data Mining options
4 ORACLE_HOME = /opt/ora10g/product/10.2.0/db_1
5 System name: Linux
6 Node name: single
7 Release: 2.6.18-92.el5PAE
8 Version: #1 SMP Fri May 23 22:26:05 EDT 2008
9 Machine: i686
10 Instance name: test
11 Redo thread mounted by this instance: 0 <none>
12 Oracle process number: 15
13 Unix process pid: 5628, image: oracle@single (TNS V1-V3)
14
15 *** SERVICE NAME:() 2010-07-12 07:41:29.190
16 *** SESSION ID:(159.1) 2010-07-12 07:41:29.190
17 Hex dump of (file 0, block 1)
18 Dump of memory from 0xB7FB7E00 to 0xB7FBBE00
19 B7FB7E00 0000C215 00000001 00000000 04010000 [................]
20 B7FB7E10 0000FF58 00000000 0A200300 7D7171CD [X......... ..qq}]
21 B7FB7E20 534E4F4D 00524554 000013E2 000001C2 [MONSTER.........]
22 B7FB7E30 00004000 00010000 00000000 00000000 [.@..............]
23 B7FB7E40 00000000 00000000 00000000 00000000 [................]
这样得到的dbid不用转换顺序，换为十进制就可以了，dbname就在下面一行，这就不多说了。
DBID:7D7171CD? 转换为十进制 => 2104586701?
DBNAME:MONSTER
?
?
? 