一, 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> 成功
来源: http://www.linuxidc.com/Linux/2018-08/153364.htm