[20160529]windows下使用bbed.txt
--windows下 oracle 9.2.0.8 自带bbed,10g以后的版本就没有带.可以从9i for windows下打包bbed,在10,11g for windows下使用.
--我们生产系统目前还存一套oracle 9.2.0.8 for windows的系统,很久以前我就做好了,好像我参考了惜分飞的链接,我自己很少
--使用,最近拿来用用看:
1.整理需要的文件:
D:\tools\bbed>ls -lR
total 24603
-rw-rw-rw- 1 user group 651536 Jun 28 2006 ORACORE9.DLL
-rw-rw-rw- 1 user group 24848 Jul 29 2006 ORANCDS9.DLL
-rw-rw-rw- 1 user group 33040 Jul 29 2006 ORANGSS9.DLL
-rw-rw-rw- 1 user group 213264 Jul 29 2006 ORANK59.DLL
-rw-rw-rw- 1 user group 499984 Jun 28 2006 ORANLS9.DLL
-rw-rw-rw- 1 user group 28944 Jul 29 2006 ORANNZMCS9.DLL
-rw-rw-rw- 1 user group 45328 Jul 29 2006 ORANRAD9.DLL
-rw-rw-rw- 1 user group 53520 Jul 29 2006 ORANTCPS9.DLL
-rw-rw-rw- 1 user group 61712 Jul 29 2006 ORAPLC9.DLL
-rw-rw-rw- 1 user group 909584 Jul 29 2006 ORAPLP9.DLL
-rw-rw-rw- 1 user group 3281168 Jul 29 2006 ORAPLS9.DLL
-rw-rw-rw- 1 user group 57784 Jul 29 2006 ORAPRTOP9.DLL
-rw-rw-rw- 1 user group 28944 Apr 26 2002 ORASLAX9.DLL
-rw-rw-rw- 1 user group 69904 Jun 28 2006 ORASNLS9.DLL
-rw-rw-rw- 1 user group 483600 Jun 28 2006 ORASQL9.DLL
-rw-rw-rw- 1 user group 69904 Jun 28 2006 ORAUNLS9.DLL
-rw-rw-rw- 1 user group 520464 Jun 27 2006 ORAXML9.DLL
-rw-rw-rw- 1 user group 41232 Jun 27 2006 ORAXMLG9.DLL
-rw-rw-rw- 1 user group 172304 Jun 27 2006 ORAXSD9.DLL
-rwxrwxrwx 1 user group 147728 Jul 29 2006 bbed.exe
-rw-rw-rw- 1 user group 84 Nov 13 2012 bbed.par
-rwxrwxrwx 1 user group 39 May 28 20:25 bbed1.bat
-rw-rw-rw- 1 user group 18432 May 28 22:09 bifile.bbd
-rw-rw-rw- 1 user group 30 May 28 20:23 cmd.par
drwxrwxrwx 1 user group 0 Oct 22 2013 dbms
-rw-rw-rw- 1 user group 546 May 28 20:22 filelist.txt
-rw-rw-rw- 1 user group 20752 Jun 28 2006 heteroxa9.dll
-rw-rw-rw- 1 user group 49152 Mar 4 2005 kpp95rdr.dll
-rw-rw-rw- 1 user group 45056 Mar 4 2005 kpp97rdr.dll
-rw-rw-rw- 1 user group 9388 May 28 22:38 log.bbd
-rw-rw-rw- 1 user group 229648 Jul 29 2006 njssl9.dll
-rw-rw-rw- 1 user group 61712 Jun 28 2006 ocijdbc9.dll
-rw-rw-rw- 1 user group 733184 Apr 26 2002 oip9.dll
-rw-rw-rw- 1 user group 1589520 Jul 29 2006 oraclient9.dll
-rw-rw-rw- 1 user group 602384 Jul 29 2006 oracommon9.dll
-rw-rw-rw- 1 user group 1736976 Jun 27 2006 oractxx9.dll
-rw-rw-rw- 1 user group 2691344 Jul 29 2006 orageneric9.dll
-rw-rw-rw- 1 user group 24576 Jul 29 2006 oraimr9.dll
-rw-rw-rw- 1 user group 3014656 Jul 29 2006 orajox9.dll
-rw-rw-rw- 1 user group 155920 Jun 28 2006 oraldapclnt9.dll
-rw-rw-rw- 1 user group 24848 Jun 28 2006 oraldapjclnt9.dll
-rw-rw-rw- 1 user group 741648 Jul 29 2006 oran9.dll
-rw-rw-rw- 1 user group 41232 Jul 29 2006 oranad9.dll
-rw-rw-rw- 1 user group 33040 Jul 29 2006 oranbeq9.dll
-rw-rw-rw- 1 user group 98576 Jul 29 2006 orancrypt9.dll
-rw-rw-rw- 1 user group 24848 Jul 29 2006 oranhost9.dll
-rw-rw-rw- 1 user group 33040 Jul 29 2006 oranipc9.dll
-rw-rw-rw- 1 user group 176400 Jul 29 2006 oranjni9.dll
-rw-rw-rw- 1 user group 180496 Jul 29 2006 oranl9.dll
-rw-rw-rw- 1 user group 74000 Jul 29 2006 oranldap9.dll
-rw-rw-rw- 1 user group 28944 Jul 29 2006 oranldapj9.dll
-rw-rw-rw- 1 user group 28944 Jun 27 2006 oranms.dll
-rw-rw-rw- 1 user group 69904 Jun 27 2006 oranmsp.dll
-rw-rw-rw- 1 user group 33040 Jul 29 2006 orannmp9.dll
-rw-rw-rw- 1 user group 53520 Jul 29 2006 orannts9.dll
-rw-rw-rw- 1 user group 28944 Jul 29 2006 orannzentr9.dll
-rw-rw-rw- 1 user group 586000 Jul 29 2006 orannzsbb9.dll
-rw-rw-rw- 1 user group 24848 Jul 29 2006 oranoname9.dll
-rw-rw-rw- 1 user group 57616 Jul 29 2006 oranoncj9.dll
-rw-rw-rw- 1 user group 225552 Jul 29 2006 oranro9.dll
-rw-rw-rw- 1 user group 41232 Jul 29 2006 oransgr9.dll
-rw-rw-rw- 1 user group 49424 Jul 29 2006 orantcp9.dll
-rw-rw-rw- 1 user group 28944 Jul 29 2006 orantns9.dll
-rw-rw-rw- 1 user group 57784 Jul 29 2006 oraobjop9.dll
-rw-rw-rw- 1 user group 311568 Jul 29 2006 oraocci9.dll
-rw-rw-rw- 1 user group 24848 Jul 29 2006 oraodm9.dll
-rw-rw-rw- 1 user group 2314240 Jun 26 2006 oraolapapi9.dll
-rw-rw-rw- 1 user group 57784 Jul 29 2006 oraolapop9.dll
-rw-rw-rw- 1 user group 377104 Jul 18 2006 oraordim9.dll
-rw-rw-rw- 1 user group 246032 Apr 29 2002 oratrace9.dll
-rw-rw-rw- 1 user group 86288 Apr 29 2002 oratracepls9.dll
-rw-rw-rw- 1 user group 24848 Jul 29 2006 oravsn9.dll
-rw-rw-rw- 1 user group 24576 Mar 29 2005 orawsec9.dll
-rw-rw-rw- 1 user group 24848 Jul 29 2006 orawtc9.dll
-rw-rw-rw- 1 user group 191248 Apr 16 2001 orawwg9.dll
-rw-rw-rw- 1 user group 151552 Feb 8 2002 vspp97.dll
-rw-rw-rw- 1 user group 65536 Feb 8 2002 vsqp9.dll
-rw-rw-rw- 1 user group 122880 Feb 8 2002 vsw97.dll
dbms=:
total 0
drwxrwxrwx 1 user group 0 Oct 22 2013 mesg
dbms\mesg=:
total 28
-rw-rw-rw- 1 user group 8704 Oct 4 2012 bbedus.msb
-rw-rw-rw- 1 user group 10270 Oct 4 2012 bbedus.msg
-rw-rw-rw- 1 user group 7680 Apr 26 2008 bbedzhs.msb.xxx
--//我估计好多dll是不需要的.
2.建立如下文件:
D:\tools\bbed>cat bbed.par
blocksize=8192
listfile=d:\tools\bbed\filelist.txt
mode=edit
PASSWORD=blockedit
D:\tools\bbed>cat cmd.par
set count 128
set width 210
--//如果显示宽度不足,可以设置width小一些.
D:\tools\bbed>cat bbed1.bat
@echo off
bbed parfile=bbed.par cmdfile=cmd.par
3.建立filelist.txt文件:
SYS@test> select file#||''||name c80 from v$dbfile ;
C80
-------------------------------------------------------------------
6 D:\APP\ORACLE\ORADATA\TEST\USERS01.DBF
5 D:\APP\ORACLE\ORADATA\TEST\UNDOTBS01.DBF
3 D:\APP\ORACLE\ORADATA\TEST\SYSAUX01.DBF
1 D:\APP\ORACLE\ORADATA\TEST\SYSTEM01.DBF
2 D:\APP\ORACLE\ORADATA\TEST\PDBSEED\SYSTEM01.DBF
4 D:\APP\ORACLE\ORADATA\TEST\PDBSEED\SYSAUX01.DBF
7 D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSTEM01.DBF
8 D:\APP\ORACLE\ORADATA\TEST\TEST01P\SYSAUX01.DBF
9 D:\APP\ORACLE\ORADATA\TEST\TEST01P\SAMPLE_SCHEMA_USERS01.DBF
10 D:\APP\ORACLE\ORADATA\TEST\TEST01P\EXAMPLE01.DBF
10 rows selected.
--将结果copy and paste到filelist.txt.
4.使用注意:
SCOTT@test01p> select rowid,dept.* from dept;
ROWID DEPTNO DNAME LOC
------------------ ---------- -------------- -------------
AAAWh9AAJAAAACFAAA 10 ACCOUNTING NEW YORK
AAAWh9AAJAAAACFAAB 20 RESEARCH DALLAS
AAAWh9AAJAAAACFAAC 30 SALES CHICAGO
AAAWh9AAJAAAACFAAD 40 OPERATIONS DALLAS
SCOTT@test01p> @ rowid AAAWh9AAJAAAACFAAA
OBJECT FILE BLOCK ROW DBA TEXT
---------- ---------- ---------- ---------- -------------------- ----------------------------------------
92285 9 133 0 9,133 alter system dump datafile 9 block 133 ;
--//使用注意一点,比如要访问上面的块,block要加1.例子:
BBED> set dba 9,134
DBA 0x02400086 (37748870 9,134)
--//注意block+1,不过很奇怪的问题是在9i下测试,就不需要+1,不知道为什么?
BBED> p kdbr
sb2 kdbr[0] @118 8062
sb2 kdbr[1] @120 8040
sb2 kdbr[2] @122 8020
sb2 kdbr[3] @124 7996
sb2 kdbr[4] @126 -1
BBED> p *kdbr[0]
rowdata[436]
------------
ub1 rowdata[436] @8162 0x2c
BBED> x /rncc
rowdata[436] @8162
------------
flag@8162: 0x2c (KDRHFL, KDRHFF, KDRHFH)
lock@8163: 0x00
cols@8164: 3
col 0[2] @8165: 10
col 1[10] @8168: ACCOUNTING
col 2[8] @8179: NEW YORK
BBED> verify
DBVERIFY - Verification starting
FILE = D:\APP\ORACLE\ORADATA\TEST\TEST01P\SAMPLE_SCHEMA_USERS01.DBF
BLOCK = 133
--//这里有正确了.
--//OK,现在可以正常使用了.需要的可以从这里下载:
--// http://pan.baidu.com/s/1i4R88K1
--//不要在生产系统上使用这些特殊的工具.