BBED是oracle内部工具,BBED(Oracle Block Browerand EDitor Tool),顾名思义就是用来直接查看和修改数据文件数据的工具,可以直接修改数据块的内容,在特殊恢复中可能会用到,一般情况下还是不用BBED的,所以默认是没有生成BBED的可执行文件,而且从oracle 11G开始就默认不提供BBED的库文件,需要从10G拷贝过来编译。
在oracle 11G以上版本,要编译BBED的执行文件,需要从10G中把库文件拷贝到11g中,需要拷贝的4个文件如下:
C#
$ORACLE_HOME/rdbms/lib/ssbbded.o
$ORACLE_HOME/rdbms/lib/sbbdpt.o
$ORACLE_HOME/rdbms/mesg/bbedus.msb
$ORACLE_HOME/rdbms/mesg/bbedus.msg
1
2
3
4
$ORACLE_HOME/rdbms/lib/ssbbded.o
$ORACLE_HOME/rdbms/lib/sbbdpt.o
$ORACLE_HOME/rdbms/mesg/bbedus.msb
$ORACLE_HOME/rdbms/mesg/bbedus.msg
在10G中提取出来后,拷贝到11G中相应的目录即可,然后就可以编译了:
PgSQL
oracle@linux-fz9d:~/product/12.1/db_1/rdbms/lib> make -f /opt/oracle/product/12.1/db_1/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
Linking BBED utility (bbed)
rm -f /opt/oracle/product/12.1/db_1/bin/bbed
/opt/oracle/product/12.1/db_1/bin/orald -o /opt/oracle/product/12.1/db_1/bin/bbed -m64 -z noexecstack -Wl,--disable-new-dtags -L/opt/oracle/product/12.1/db_1/rdbms/lib/ -L/opt/oracle/product/12.1/db_1/lib/ -L/opt/oracle/product/12.1/db_1/lib/stubs/ /opt/oracle/product/12.1/db_1/lib/s0main.o /opt/oracle/product/12.1/db_1/rdbms/lib/ssbbded.o /opt/oracle/product/12.1/db_1/rdbms/lib/sbbdpt.o `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -ldbtools12 -lclntsh -lclntshcore `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnz12 -lzt12 -lztkg12 -lztkg12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lmm -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `cat /opt/oracle/product/12.1/db_1/lib/sysliblist` -Wl,-rpath,/opt/oracle/product/12.1/db_1/lib -lm `cat /opt/oracle/product/12.1/db_1/lib/sysliblist` -ldl -lm -L/opt/oracle/product/12.1/db_1/lib
1
2
3
4
5
oracle@linux-fz9d:~/product/12.1/db_1/rdbms/lib>make-f/opt/oracle/product/12.1/db_1/rdbms/lib/ins_rdbms.mkBBED=$ORACLE_HOME/bin/bbed$ORACLE_HOME/bin/bbed
LinkingBBEDutility(bbed)
rm-f/opt/oracle/product/12.1/db_1/bin/bbed
/opt/oracle/product/12.1/db_1/bin/orald-o/opt/oracle/product/12.1/db_1/bin/bbed-m64-znoexecstack-Wl,--disable-new-dtags -L/opt/oracle/product/12.1/db_1/rdbms/lib/ -L/opt/oracle/product/12.1/db_1/lib/ -L/opt/oracle/product/12.1/db_1/lib/stubs/ /opt/oracle/product/12.1/db_1/lib/s0main.o /opt/oracle/product/12.1/db_1/rdbms/lib/ssbbded.o /opt/oracle/product/12.1/db_1/rdbms/lib/sbbdpt.o `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -ldbtools12 -lclntsh -lclntshcore `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnnz12 -lzt12 -lztkg12 -lztkg12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lmm -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lnro12 `cat /opt/oracle/product/12.1/db_1/lib/ldflags` -lncrypt12 -lnsgr12 -lnzjs12 -ln12 -lnl12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 -lclient12 -lnnetd12 -lvsn12 -lcommon12 -lgeneric12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lcore12 -lsnls12 -lnls12 -lxml12 -lcore12 -lunls12 -lsnls12 -lnls12 -lcore12 -lnls12 `cat /opt/oracle/product/12.1/db_1/lib/sysliblist` -Wl,-rpath,/opt/oracle/product/12.1/db_1/lib -lm `cat /opt/oracle/product/12.1/db_1/lib/sysliblist` -ldl -lm -L/opt/oracle/product/12.1/db_1/lib
在编译过程中,我们指定了bbed执行文件的目录$ORACLE_HOME/bin,可以在此目录看到bbed可执行文件:
C#
oracle@linux-fz9d:~/product/12.1/db_1/rdbms/lib> ll $ORACLE_HOME/bin/bbed
-rwxr-xr-x 1 oracle oinstall 258912 Nov 11 07:57 /opt/oracle/product/12.1/db_1/bin/bbed
1
2
oracle@linux-fz9d:~/product/12.1/db_1/rdbms/lib>ll$ORACLE_HOME/bin/bbed
-rwxr-xr-x1oracleoinstall258912Nov1107:57/opt/oracle/product/12.1/db_1/bin/bbed
编译好之后,就可以尝试运行BBED了,由于BBED是oracle内部命令,不提供支持,设置了默认密码blockedit
PgSQL
oracle@linux-fz9d:~/product/12.1/db_1/rdbms/lib> bbed
Password:
BBED: Release 2.0.0.0.0 - Limited Production on Mon Nov 11 07:59:44 2013
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED>
1
2
3
4
5
6
7
8
9
10
oracle@linux-fz9d:~/product/12.1/db_1/rdbms/lib>bbed
Password:
BBED:Release2.0.0.0.0-LimitedProductiononMonNov1107:59:442013
Copyright(c)1982,2013,Oracleand/oritsaffiliates.Allrightsreserved.
*************!!!ForOracleInternalUseonly!!!***************
BBED>
关于BBED更多的介绍可关注博客其他文章,BBED更适合于运维,特殊恢复,还是一个非常强大的工具。
如果没有找到库文件,可点击我下载
转载请注明: 版权所有,文章允许转载,但必须以链接方式注明源地址,否则追究法律责任!
最后编辑:2013-11-11作者:Jerry
一个积极向上的小青年,热衷于分享--Focus on DB,BI,ETL