兽魂歌,刘玉璞,陈昊个人资料
bbed介绍：
bbed(oracle block browerand editor tool)，用来直接查看和修改数据文件数据的一个工具，是oracle一款内部工具，可以直接修改oracle数据文件块的内容，在一些极端恢复场景下比较有用。该工具不受oracle支持，所以默认是没有生成可执行文件的，在使用前需要重新连接。
本文详细介绍了关于oracle 11g下编译使用bbed的方法教程，下面话不多说，来一起看看详细的介绍：
环境：rhel 6.4 + oracle 11.2.0.4
1. 拷贝缺失文件
11g中缺失几个相关文件，但我们实际可以从10g拷贝相关文件到11g对应目录下：
$oracle_home/rdbms/lib/sbbdpt.o $oracle_home/rdbms/lib/ssbbded.o $oracle_home/rdbms/mesg/bbedus.msb $oracle_home/rdbms/mesg/bbedus.msg
2. 编译bbed
make -f $oracle_home/rdbms/lib/ins_rdbms.mk bbed=$oracle_home/bin/bbed $oracle_home/bin/bbed
成功编译的结果如下：
[oracle@jy-db01 dbhome_1]$ make -f $oracle_home/rdbms/lib/ins_rdbms.mk bbed=$oracle_home/bin/bbed $oracle_home/bin/bbed linking bbed utility (bbed) rm -f /u02/app/oracle/product/11.2.0/dbhome_1/bin/bbed gcc -o /u02/app/oracle/product/11.2.0/dbhome_1/bin/bbed -m64 -z noexecstack -l/u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ -l/u02/app/oracle/product/11.2.0/dbhome_1/lib/ -l/u02/app/oracle/product/11.2.0/dbhome_1/lib/stubs/ /u02/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o /u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o /u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/sbbdpt.o `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -ldbtools11 -lclntsh `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnnz11 -lzt11 -lztkg11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lnro11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/ldflags` -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 -lclient11 -lnnetd11 -lvsn11 -lcommon11 -lgeneric11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -wl,-rpath,/u02/app/oracle/product/11.2.0/dbhome_1/lib -lm `cat /u02/app/oracle/product/11.2.0/dbhome_1/lib/sysliblist` -ldl -lm -l/u02/app/oracle/product/11.2.0/dbhome_1/lib
3. bbed使用测试
--3.1 bbed命令测试可用 [oracle@jy-db01 dbhome_1]$ bbed password: --密码默认是blockedit bbed: release 2.0.0.0.0 - limited production on mon jan 18 15:13:09 2016 copyright (c) 1982, 2011, oracle and/or its affiliates. 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 [ <set parameter> | 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 ] </nuf>: 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] <target spec>=<source spec> <target spec> : [ dba | file | filename | block | offset | symbol | *symbol ] <source spec> : [ value | <target spec options> ] sum [ dba | file | filename | block ] [ apply ] push [ dba | file | filename | block | offset ] pop [all] revert [ dba | file | filename | block ] undo help [ <bbed command> | all ] verify [ dba | file | filename | block ] corrupt [ dba | file | filename | block ] bbed> --3.2 bbed命令参数 [oracle@jy-db01 tmp]$ bbed help=y password - required parameter filename - database file name blocksize - database block size listfile - list file name mode - [browse/edit] spool - spool to logfile [no/yes] cmdfile - bbed command file name logfile - bbed log file name parfile - parameter file name bifile - bbed before-image file name revert - rollback changes from bifile [no/yes] silent - hide banner [no/yes] help - show all valid parameters [no/yes]
另外，一般使用bbed都是在参数配置文件中写好配置参数，然后直接调用配置文件，比如：
--编辑/tmp/bbed.par参数配置文件 blocksize=8192 listfile=/tmp/listfile.txt mode=edit --编辑/tmp/listfile.txt文件 5 /u02/oradata/jingyu/dbs_d_jingyu01.dbf 31457280 6 /u02/oradata/jingyu/dbs_i_jingyu01.dbf 31457280 --调用bbed cd /tmp bbed parfile=bbed.par
reference
•
•
总结
以上就是这篇文章的全部内容了，希望本文的内容对大家的学习或者工作能带来一定的帮助，如果有疑问大家可以留言交流，谢谢大家对移动技术网的支持。
如对本文有疑问，请在下面进行留言讨论，广大热心网友会与你互动！！ 点击进行留言回复
Oracle字符串函数length、upper、lower、initcap、 concat、instr、replace
我要评论
网友评论