一、 bbed安装：

1、ORACLE 11G下安装BBED，需要从ORACLE 10G中复制三个包 sbbdpt.o 、ssbbded.o 

并将两个文件移到$ORACLE_HOME/rdbms/lib/ 目录下 , bbedus.msb 移到 $ORACLE_HOME/mesg/ 下面

[oracle]$ pwd

/u01/app/oracle/product/11.2.0/db_1/rdbms/lib node1-> ll bbedus.msb -rw-r--r--. 1 oracle oinstall 8704 Mar 5 17:39 bbedus.msb node1-> ll sbbdpt.o -rw-r--r--. 1 oracle oinstall 1863 Mar 5 17:39 sbbdpt.o node1-> ll ssbbded.o -rw-r--r--. 1 oracle oinstall 1191 Mar 5 17:39 ssbbded.o

2、 编译

[oracle]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed Linking BBED utility (bbed)

3、安装成功登陆如下：

[oracle]$ bbed Password: 默认密码是：blockedit BBED>

4、 配置bbed

BBED> set file 1 block 1 BBED-00312: no LISTFILE specified > 原因没有配置

-- 将sql 查询结果，写入 bbedfile.txt 文件， 并配置 bbed 的 par.bbd

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

[oracle@12c01 bbed]$ cat bbedfile.txt 

1 /home/oracle/app/oracle/oradata/andycdb/system01.dbf 859832320 3 /home/oracle/app/oracle/oradata/andycdb/sysaux01.dbf 576716800 4 /home/oracle/app/oracle/oradata/andycdb/undotbs01.dbf 62914560 5 /home/oracle/app/oracle/oradata/andycdb/pdbseed/system01.dbf 262144000 6 /home/oracle/app/oracle/oradata/andycdb/pdbseed/sysaux01.dbf 367001600 7 /home/oracle/app/oracle/oradata/andycdb/users01.dbf 5242880 8 /home/oracle/app/oracle/oradata/andycdb/pdbseed/undotbs01.dbf 104857600 9 /home/oracle/app/oracle/oradata/andycdb/pdb01/system01.dbf 272629760 10 /home/oracle/app/oracle/oradata/andycdb/pdb01/sysaux01.dbf 398458880 11 /home/oracle/app/oracle/oradata/andycdb/pdb01/undotbs01.dbf 104857600 12 /home/oracle/app/oracle/oradata/andycdb/pdb01/users01.dbf 17039360 13 /home/oracle/app/oracle/oradata/andycdb/pdb01/clone01.dbf 1048576 26 /home/oracle/app/oracle/oradata/andycdb/cdb_users01.dbf 5242880 27 /home/oracle/app/oracle/oradata/andycdb/pdb01/pdb01_users01.dbf 5242880 28 /home/oracle/app/oracle/oradata/andycdb/undotbs02 5242880 29 /home/oracle/app/oracle/oradata/andycdb/pdb01/undotbs02 5242880 30 /home/oracle/app/oracle/oradata/andycdb/pdb01/undotbs03 5242880 [oracle bbed]$ cat par.bbd  blocksize=8192 listfile=bbedfile.txt mode=edit

5、 正式登陆使用

[oracle bbed]$ bbed parfile=par.bbd

BBED> info File# Name Size(blks) ----- ---- ---------- 1 /home/oracle/app/oracle/oradata/andycdb/system01.dbf 104960 3 /home/oracle/app/oracle/oradata/andycdb/sysaux01.dbf 70400 ...... 省略

BBED> set file 31 block 1

FILE# 31 BLOCK# 1 > 成功

本文转自 张冲andy 博客园博客，原文链接：http://www.cnblogs.com/andy6/p/8512430.html   ，如需转载请自行联系原作者