联系:手机/微信(+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
Vae,
设置 正确的oracle_home
echo %oracle_home% 看看当前的oraclehome 是否是在当前的目录下。