联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
学习ORACLE三剑客:互联网,ORACLE资料,交流.今天在朋友的帮助下,了结了一个心结:在WIN平台中完美的使用bbed(8i/9i部分版本/10g 11g不支持),今天在朋友的帮助下解决了该问题
9i中bbed相关程序
Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\XIFENFEI>cd E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win
C:\Users\XIFENFEI>e:
E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win>dir
驱动器 E 中的卷没有标签。
卷的序列号是 000C-3B41
E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win 的目录
2012/09/24 19:45 <DIR> .
2012/09/24 19:45 <DIR> ..
2006/07/29 13:33 147,728 bbed.exe
2006/06/28 11:32 20,752 heteroxa9.dll
2004/10/26 16:35 49,152 kpp95rdr.dll
2004/10/26 16:35 45,056 kpp97rdr.dll
2012/09/24 19:49 250 log.bbd
2006/07/29 02:08 229,648 njssl9.dll
2006/06/28 11:33 61,712 ocijdbc9.dll
2002/04/26 16:22 733,184 oip9.dll
2006/07/29 14:02 1,589,520 oraclient9.dll
2006/07/29 15:25 602,384 oracommon9.dll
2006/06/28 09:54 651,536 ORACORE9.DLL
2006/06/27 08:44 1,736,976 oractxx9.dll
2006/07/29 14:02 2,691,344 orageneric9.dll
2006/07/29 13:56 24,576 oraimr9.dll
2006/07/29 15:19 3,014,656 orajox9.dll
2006/06/28 03:09 155,920 oraldapclnt9.dll
2006/06/28 03:09 24,848 oraldapjclnt9.dll
2006/07/29 02:18 741,648 oran9.dll
2006/07/29 02:10 41,232 oranad9.dll
2006/07/29 02:06 33,040 oranbeq9.dll
2006/07/29 02:08 24,848 ORANCDS9.DLL
2006/07/29 02:07 98,576 orancrypt9.dll
2006/07/29 02:07 33,040 ORANGSS9.DLL
2006/07/29 02:07 24,848 oranhost9.dll
2006/07/29 02:06 33,040 oranipc9.dll
2006/07/29 02:08 176,400 oranjni9.dll
2006/07/29 02:07 213,264 ORANK59.DLL
2006/07/29 02:06 180,496 oranl9.dll
2006/07/29 02:07 74,000 oranldap9.dll
2006/07/29 02:08 28,944 oranldapj9.dll
2006/06/28 06:32 499,984 ORANLS9.DLL
2006/07/29 02:06 33,040 orannmp9.dll
2006/07/29 02:07 53,520 orannts9.dll
2006/07/29 02:07 28,944 orannzentr9.dll
2006/07/29 02:08 28,944 ORANNZMCS9.DLL
2006/07/29 02:07 586,000 orannzsbb9.dll
2006/07/29 02:07 24,848 oranoname9.dll
2006/07/29 02:08 57,616 oranoncj9.dll
2006/07/29 02:07 45,328 ORANRAD9.DLL
2006/07/29 02:06 225,552 oranro9.dll
2006/07/29 02:08 41,232 oransgr9.dll
2006/07/29 02:06 49,424 orantcp9.dll
2006/07/29 02:07 53,520 ORANTCPS9.DLL
2006/07/29 02:07 28,944 orantns9.dll
2006/07/29 13:58 57,784 oraobjop9.dll
2006/07/29 14:58 311,568 oraocci9.dll
2006/07/29 14:02 24,848 oraodm9.dll
2006/06/26 19:19 2,314,240 oraolapapi9.dll
2006/07/29 13:58 57,784 oraolapop9.dll
2006/07/18 08:53 377,104 oraordim9.dll
2006/07/29 12:39 61,712 ORAPLC9.DLL
2006/07/29 12:40 909,584 ORAPLP9.DLL
2006/07/29 12:39 3,281,168 ORAPLS9.DLL
2006/07/29 13:58 57,784 ORAPRTOP9.DLL
2003/01/22 18:59 20,480 orarac9.dll
2002/04/26 17:18 28,944 ORASLAX9.DLL
2006/06/28 06:33 69,904 ORASNLS9.DLL
2006/06/28 16:04 483,600 ORASQL9.DLL
2002/04/29 14:04 246,032 oratrace9.dll
2002/04/29 14:04 86,288 oratracepls9.dll
2006/06/28 06:32 69,904 ORAUNLS9.DLL
2006/07/29 14:02 24,848 oravsn9.dll
2005/03/29 17:17 24,576 orawsec9.dll
2006/07/29 14:02 24,848 orawtc9.dll
2001/04/16 19:19 191,248 orawwg9.dll
2006/06/27 01:50 520,464 ORAXML9.DLL
2006/06/27 01:50 41,232 ORAXMLG9.DLL
2006/06/27 01:50 172,304 ORAXSD9.DLL
2010/06/29 05:38 181,560 vspp97.dll
2010/06/29 05:38 83,256 vsqp9.dll
2010/06/29 05:38 177,464 vsw97.dll
72 个文件 25,234,522 字节
2 个目录 58,747,236,352 可用字节
执行bbed程序报错
E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win>bbed Message 112 not found; No message file for product=RDBMS, facility=BBED BBED-00113: file not found
分析原因:因为在11g中ORACLE并没有在?/RDBMS/MESG/中提供bbedus.msb程序,导致bbed运行时候无法显示相关提示信息,从而出现类此该错误
解决方法:在11g环境中需要从10g库中拷贝bbedus.msb文件放置到?/RDBMS/MESG/中即可
运行bbed程序
E:\study\Oracle\数据库非常规恢复\bbed\win-bbed\bbed_win>bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Mon Sep 24 19:45:40 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED> info all;
File# Name Size(blks)
----- ---- ----------
BBED> show all;
FILE# 0
BLOCK# 1
OFFSET 0
DBA 0x00000000 (0 0,1)
FILENAME
BIFILE bifile.bbd
LISTFILE
BLOCKSIZE 2048
MODE Browse
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No
站长能打把windows 版的bbed打个包，提供download不。谢谢了哇
问你一个问题，我按照这个安装好了。
但是会出现偏差1。
SQL> select rowid from emp where rownum @lookup_rowid AAAQ+jAAEAAAAAeAAA
OBJECT FILE BLOCK ROW
———- ———- ———- ———-
69539 4 30 0
在bbed里看
set dba 4，31
看到才对。
BBED> set dba 4,31
DBA 0x0100001f (16777247 4,31)
BBED> p *kdbr
rowdata[529]
————
ub1 rowdata[529] @8150 0x2c
BBED> x /rnccntnnn
rowdata[529] @8150
————
flag@8150: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8151: 0x01
cols@8152: 8
col 0[3] @8153: 7369
col 1[5] @8157: SMITH
col 2[5] @8163: CLERK
col 3[3] @8169: 7902
col 4[7] @8173: 1980-12-17 00:00:00
col 5[2] @8181: 800
col 6[0] @8184: *NULL*
col 7[2] @8185: 20
9i下正常，10g，11G都是有偏差。
为何我按照你的要求装，还是会报错：
G:\\oracle\\product\\11.2.0\\dbhome_1\\BIN\\bbed_win>bbed
Message 112 not found; No message file for product=RDBMS, facility=BBED
BBED-00113: file not found
Vae,
你的11grdbms/mesg/中缺少msb文件，所以你启动bbed的时候，提示你no fund相关字符
bbedus.msb
bbedzhs.msb
我拷贝bbedus.msb，bbedzhs.msb到/rdbms/mesg目录下也是一样的报错，在10g，11g下都尝试了下，都还是会报错：
11g:
G:\\oracle\\product\\11.2.0\\dbhome_1\\BIN\\bbed_win>bbed
Message 112 not found; No message file for product=RDBMS, facility=BBED
BBED-00113: file not found
10g:
G:\oracle\product\10.2.0\db_2\BIN\bbed_win>bbed
Message 112 not found; No message file for product=RDBMS, facility=BBED
BBED-00113: file not found
Vae,
确定你的oracle_home是否正确，另外你的bbed程序是否正确
搞定了，是ORACLE_HOME的问题，谢了
win中10g，运行不了啊，已经把文件放到Oracle_home下了
lly,
是需要把文件放到bin文件夹下
Vae,
设置 正确的oracle_home
echo %oracle_home% 看看当前的oraclehome 是否是在当前的目录下。