oracle bbed(oracle block browser and editor tool)安装与使用bbed工具可以用来更改数据block,但不被官方所支持。安装过程如下
安装过程如下:
$ cd $oracle_home/rdbms/lib
$ ls -al *bb*.o
-rw-r--r-- 1 oracle oinstall 1671 may 10 2008 sbbdpt.o
-rw-r--r-- 1 oracle oinstall 900 may 10 2008 ssbbded.o
$ make -f ins_rdbms.mk $oracle_home/rdbms/lib/bbed
linking bbed utility (bbed)
rm -f /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/bbed
ld -b64 -o /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/bbed -l/u01/app/oracle/product/10.2.0/db_1/rdbms/lib/ -l/u01/app/oracle/product/10.2.0/db_1/lib/ -bnoerrmsg /u01/app/oracle/product/10.2.0/db_1/lib/s0main.o /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/ssbbded.o /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/sbbdpt.o -bi:/usr/lib/aio.exp `cat /u01/app/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 /u01/app/oracle/product/10.2.0/db_1/rdbms/lib/defopt.o -ldbtools10 `cat /u01/app/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/app/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lmm -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 `cat /u01/app/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lnro10 `cat /u01/app/oracle/product/10.2.0/db_1/lib/ldflags` -lnsslb10 -lncrypt10 -lnsgr10 -lnzjs10 -ln10 -lnnz10 -lnl10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lpls10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lclient10 -lnnetd10 -lvsn10 -lcommon10 -lgeneric10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lcore10 -lsnls10 -lnls10 -lxml10 -lcore10 -lunls10 -lsnls10 -lnls10 -lcore10 -lnls10 -lld -lm `cat /u01/app/oracle/product/10.2.0/db_1/lib/sysliblist` -lm `if [ \`/usr/bin/uname -v\` = 4 ]; then echo -bi:/u01/app/oracle/product/10.2.0/db_1/lib/pw-syscall.exp; fi;` -lsql10 /u01/app/oracle/product/10.2.0/db_1/lib/nautab.o /u01/app/oracle/product/10.2.0/db_1/lib/naeet.o /u01/app/oracle/product/10.2.0/db_1/lib/naect.o /u01/app/oracle/product/10.2.0/db_1/lib/naedhs.o
$ cp $oracle_home/rdbms/lib/bbed $oracle_home/bin
$ bbed
password: blockedit>
bbed: release 2.0.0.0.0 - limited production on mon jun 20 20:00:06 2011
copyright (c) 1982, 2007, oracle. all rights reserved.
************* !!! for oracle internal use only !!! ***************
bbed> help all
set dba [ dba | file#, block# ]
set filename 'filename'
set file file#
set block [+/-]block#
set offset [ [+/-]byte offset | symbol | *symbol ]
set blocksize bytes
set list[file] 'filename'
set width character_count
set count bytes_to_display
set ibase [ hex | oct | dec ]
set obase [ hex | oct | dec ]
set mode [ browse | edit ]
set spool [ y | n ]
show [ | all ]
info
map[/v] [ dba | filename | file | block ]
dump[/v] [ dba | filename | file | block | offset | count ]
print[/x|d|u|o|c] [ dba | file | filename | block | offset | symbol | *symbol ]
examine[/nuf] [ dba | file | filename | block | offset | symbol | *symbol ]
:
n - a number which specifies a repeat count.
u - a letter which specifies a unit size:
b - b1, ub1 (byte)
h - b2, ub2 (half-word)
w - b4, ub4(word)
r - oracle table/index row
f - a letter which specifies a display format:
x - hexadecimal
d - decimal
u - unsigned decimal
o - octal
c - character (native)
n - oracle number
t - oracle date
i - oracle rowid
find[/x|d|u|o|c] numeric/character string [ top | curr ]
copy [ dba | file | filename | block ] to [ dba | file | filename | block ]
modify[/x|d|u|o|c] numeric/character string
[ dba | file | filename | block | offset | symbol | *symbol ]
assign[/x|d|u|o] =
: [ dba | file | filename | block | offset | symbol | *symbol ]
: [ value | ]
sum [ dba | file | filename | block ] [ apply ]
push [ dba | file | filename | block | offset ]
pop [all]
revert [ dba | file | filename | block ]
undo
help [ | all ]
verify [ dba | file | filename | block ]
corrupt [ dba | file | filename | block ]
bbed>
,
