oracle--BBED (dump 深入实践三)

一,工具介绍

　　bbed是Block Browser and Editor（块浏览编辑器）的缩写，它是Oracle数据库在安装时一起附带的工具。

?????? 一般此工具倾向于仅作为Oracle内部使用，且Oracle公司并不公开此工具使用细节。

?? ? ? 由于bbed可以对Oracle数据库中的数据块进行内容修改和破坏，因此此工具功能强大同时伴有很高的使用风险。

二,工具安装

　　模块和库地址:

https://files.cnblogs.com/files/kingle-study/BBED.zip

[[email?protected] ~]$ cd BBED/
[[email?protected] BBED]$ ls
bbedus.msb  bbedus.msg  BBED配置说明.txt  sbbdpt.o  ssbbded.o
[[email?protected] BBED]$ l
-bash: l: command not found
[[email?protected] BBED]$ ls
bbedus.msb  bbedus.msg  BBED配置说明.txt  sbbdpt.o  ssbbded.o
[[email?protected] BBED]$ mv ssbbded.o sbbdpt.o $ORACLE_HOME/rdbms/lib/  ---文件拷贝到oracle 库下面
[[email?protected] BBED]$ mv bbedus* $ORACLE_HOME/rdbms/mesg/            ----文件拷贝到oracle 模块下面
[[email?protected] BBED]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLEME/bin/bbed  ---执行编译安装

Linking BBED utility (bbed)
rm -f /u01/app/oracle/product/11.2.0/db_1/bin/bbed
gcc -o /u01/app/oracle/product/11.2.0/db_1/bin/bbed -m64 -z 
noexecstack -L/u01/app/oracle/prob/ -L/u01/app/oracle/product/11.2.0
/db_1/lib/ -L/u01/app/oracle/product/11.2.0/db_1/lib/stubst/11.2.0
/db_1/lib/s0main.o /u01/app/oracle/product/11.2.0/db_1/rdbms
/lib/ssbbded.o /u01/app/o/rdbms/lib/sbbdpt.o `cat /u01/app/oracle
/product/11.2.0/db_1/lib/ldflags`    -lncrypt11 -lnsg -ldbtools11 -lclntsh
  `cat /u01/app/oracle/product/11.2.0/db_1/lib/ldflags`    -lncrypt11 
-ll11 -lnro11 `cat /u01/app/oracle/product/11.2.0/db_1/lib/ldflags`    
-lncrypt11 -lnsgr11 -lnz -lzt11 -lztkg11 -lclient11 -lnnetd11  -lvsn11 
-lcommon11 -lgeneric11 -lmm -lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11
 -lxml11 -lcore11 -lunls11 -lsnls11 -lnls11 -lcore11 -lnls11 `cat 
/.2.0/db_1/lib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 -ln11 -lnl11 
-lnro11 `cat /u01/app/oraib/ldflags`    -lncrypt11 -lnsgr11 -lnzjs11 
-ln11 -lnl11 -lclient11 -lnnetd11  -lvsn11 -lcomm11 -lnls11  -lcore11 
-lsnls11 -lnls11 -lcore11 -lsnls11 -lnls11 -lxml11 -lcore11 -lunls11 
-lsnls11 -lclient11 -lnnetd11  -lvsn11 -lcommon11 -lgeneric11 -lsnls11
 -lnls11  -lcore11 -lsnls111 -lnls11 -lxml11 -lcore11 -lunls11 -lsnls11
 -lnls11 -lcore11 -lnls11   `cat /u01/app/oraclesysliblist` -Wl,-rpath,/u01/app/oracle/product/11.2.0/db_1/lib -lm    
`cat /u01/app/oracle/prliblist` -ldl -lm   -L/u01/app/oracle/product/11.2.0/db_1/lib
[[email?protected] BBED_10g_源码 x64]$ bbed
Password: 默认密码  blockeidt

?

三,配置文件

SQL> select file#||‘ ‘||name||‘ ‘||bytes from v$datafile ;

FILE#||‘‘||NAME||‘‘||BYTES
--------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/oracle01/system01.dbf 849346560
2 /u01/app/oracle/oradata/oracle01/sysaux01.dbf 1121976320
3 /u01/app/oracle/oradata/oracle01/undotbs01.dbf 304087040
4 /u01/app/oracle/oradata/oracle01/users01.dbf 5242880
5 /u01/app/oracle/oradata/oracle01/example01.dbf 363069440
6 /u01/app/oracle/oradata/oracle01/test01.dbf 10485760
7 /u01/app/oracle/oradata/oracle01/test101.dbf 10485760

把输出的内容写道bbed.txt文件下面
cat bbed.txt
[[email?protected] BBED]$ cat bbed.txt
1 /u01/app/oracle/oradata/oracle01/system01.dbf 849346560
2 /u01/app/oracle/oradata/oracle01/sysaux01.dbf 1121976320
3 /u01/app/oracle/oradata/oracle01/undotbs01.dbf 304087040
4 /u01/app/oracle/oradata/oracle01/users01.dbf 5242880
5 /u01/app/oracle/oradata/oracle01/example01.dbf 363069440
6 /u01/app/oracle/oradata/oracle01/test01.dbf 10485760
7 /u01/app/oracle/oradata/oracle01/test101.dbf 10485760


bbed配置文件编写:
[[email?protected] BBED]$ cat par.bbd
blocksize=8192
listfile=bbed.txt
mode=edit

?

四,启动与体验

[[email?protected] BBED]$ bbed --help
LRM-00116: syntax error at ‘-‘ following ‘-‘
PASSWORD - Required parameter
FILENAME - Database file name
BLOCKSIZE - Database block size  可编辑的数据文件标准块大小。
LISTFILE - List file name        列出可编辑的文件 
MODE - [browse/edit]  bbed可运行模式（browser或edit）
SPOOL - Spool to logfile [no/yes]    操作记录写出到bbed.log文件 (Y或N)
CMDFILE - BBED command file name     可执行命令的文件名清单
LOGFILE - BBED log file name          用户日志文件文件名。默认为log.bbd  
PARFILE - Parameter file name          列有命令项的参数文件
BIFILE - BBED before-image file name   undo文件文件名。默认为bifile.bbd
REVERT - Rollback changes from BIFILE [no/yes]
SILENT - Hide banner [no/yes]  不将输出打印到标准输出上（Y或N）  
HELP - Show all valid parameters [no/yes]
BBED-00105: LRM error 110 occurred during command line parsing
[[email?protected] BBED]$ bbed password=blockedit parfile=par.bbd

BBED: Release 2.0.0.0.0 - Limited Production on Sun May 5 14:54:37 2019

Copyright (c) 1982,2011,Oracle and/or its affiliates.? All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> info
?File#? Name??????????????????????????????????????????????????????? Size(blks)
?-----? ----??????????????????????????????????????????????????????? ----------
???? 1? /u01/app/oracle/oradata/oracle01/system01.dbf?????????????????? 103680
???? 2? /u01/app/oracle/oradata/oracle01/sysaux01.dbf?????????????????? 136960
???? 3? /u01/app/oracle/oradata/oracle01/undotbs01.dbf?????????????????? 37120
???? 4? /u01/app/oracle/oradata/oracle01/users01.dbf?????????????????????? 640
???? 5? /u01/app/oracle/oradata/oracle01/example01.dbf?????????????????? 44320
???? 6? /u01/app/oracle/oradata/oracle01/test01.dbf?????????????????????? 1280
???? 7? /u01/app/oracle/oradata/oracle01/test101.dbf????????????????????? 1280

（编辑：威海站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!