Oracle 11g下编译使用BBED的方法教程
BBED介绍:
BBED(OracleBlockBrowerandEDitorTool),用来直接查看和修改数据文件数据的一个工具,是Oracle一款内部工具,可以直接修改Oracle数据文件块的内容,在一些极端恢复场景下比较有用。该工具不受Oracle支持,所以默认是没有生成可执行文件的,在使用前需要重新连接。
本文详细介绍了关于Oracle11g下编译使用BBED的方法教程,下面话不多说,来一起看看详细的介绍:
环境:RHEL6.4+Oracle11.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.mkBBED=$ORACLE_HOME/bin/bbed$ORACLE_HOME/bin/bbed
成功编译的结果如下:
[oracle@JY-DB01dbhome_1]$make-f$ORACLE_HOME/rdbms/lib/ins_rdbms.mkBBED=$ORACLE_HOME/bin/bbed$ORACLE_HOME/bin/bbed LinkingBBEDutility(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-znoexecstack-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.1bbed命令测试可用 [oracle@JY-DB01dbhome_1]$bbed Password:--密码默认是blockedit BBED:Release2.0.0.0.0-LimitedProductiononMonJan1815:13:092016 Copyright(c)1982,2011,Oracleand/oritsaffiliates.Allrightsreserved. *************!!!ForOracleInternalUseonly!!!*************** BBED>helpall SETDBA[dba|file#,block#] SETFILENAME'filename' SETFILEfile# SETBLOCK[+/-]block# SETOFFSET[[+/-]byteoffset|symbol|*symbol] SETBLOCKSIZEbytes SETLIST[FILE]'filename' SETWIDTHcharacter_count SETCOUNTbytes_to_display SETIBASE[HEX|OCT|DEC] SETOBASE[HEX|OCT|DEC] SETMODE[BROWSE|EDIT] SETSPOOL[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-anumberwhichspecifiesarepeatcount. u-aletterwhichspecifiesaunitsize: b-b1,ub1(byte) h-b2,ub2(half-word) w-b4,ub4(word) r-Oracletable/indexrow f-aletterwhichspecifiesadisplayformat: x-hexadecimal d-decimal u-unsigneddecimal o-octal c-character(native) n-Oraclenumber t-Oracledate i-Oraclerowid FIND[/x|d|u|o|c]numeric/characterstring[TOP|CURR] COPY[DBA|FILE|FILENAME|BLOCK]TO[DBA|FILE|FILENAME|BLOCK] MODIFY[/x|d|u|o|c]numeric/characterstring [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> --3.2bbed命令参数 [oracle@JY-DB01tmp]$bbedhelp=y PASSWORD-Requiredparameter FILENAME-Databasefilename BLOCKSIZE-Databaseblocksize LISTFILE-Listfilename MODE-[browse/edit] SPOOL-Spooltologfile[no/yes] CMDFILE-BBEDcommandfilename LOGFILE-BBEDlogfilename PARFILE-Parameterfilename BIFILE-BBEDbefore-imagefilename REVERT-RollbackchangesfromBIFILE[no/yes] SILENT-Hidebanner[no/yes] HELP-Showallvalidparameters[no/yes]
另外,一般使用bbed都是在参数配置文件中写好配置参数,然后直接调用配置文件,比如:
--编辑/tmp/bbed.par参数配置文件 blocksize=8192 listfile=/tmp/listfile.txt mode=edit --编辑/tmp/listfile.txt文件 5/u02/oradata/jingyu/dbs_d_jingyu01.dbf31457280 6/u02/oradata/jingyu/dbs_i_jingyu01.dbf31457280 --调用bbed cd/tmp bbedparfile=bbed.par
Reference
•OracleBBED工具说明
•四步快速启动oraclebbed
总结
以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作能带来一定的帮助,如果有疑问大家可以留言交流,谢谢大家对毛票票的支持。