一,bb安装:
1,ORACLE 11 g下安装bb,需要从ORACLE 10 g中复制三个包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→bbedus。msb
-rw-r——r。8704 3月5日17:39 oracle oinstall bbedus。msb
node1→sbbdpt。o
-rw-r——r。1863 3月5日17:39 oracle oinstall sbbdpt。o
node1→ssbbded。o
-rw-r——r。1191 3月5日17:39 oracle oinstall ssbbded.o
2、编译
(oracle)使美元- f $ ORACLE_HOME/rdbms/lib/ins_rdbms。可bb=$ ORACLE_HOME/bin/bb $ ORACLE_HOME/bin/bb
链接bb效用(bb)
3、安装成功登陆如下:
(oracle)美元bb
密码:默认密码是:blockedit
BBED>
4、配置bb
BBED>设置文件1块1
bb - 00312:没有指定LISTFILE祝辞原因没有配置
——将sql查询结果,写入bbedfile。txt文件,并配置bb的par.bbd
完成;选择文件# | |的| |名称| |的| |字节从v $丢失;
[oracle@12c01 bb]猫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 bb)猫par.bbd 美元;
blocksize=8192
listfile=bbedfile。txt
模式=编辑
5,正式登陆使用
(oracle bb)美元bb parfile=持平。bdd
BBED>信息
文件#名称大小(黑色)
- - - - - - - - - - - - - - - - - - - - - -
1/home/oracle/app/oracle/oradata/andycdb/system01.dbf 104960
3/home/oracle/app/oracle/oradata/andycdb/sysaux01.dbf 70400
……省略
BBED>设置文件31块1
文件# 31日
块# 1比;成功
,
