BBED工具
**************************************************
1、BBED的安装
oracle 11g中缺bbed包, 需要从10g 中copy过来
俺这里提供下载
64位bbed包: http://pan.baidu.com/s/1rbRrw
32位bbed包: http://pan.baidu.com/s/105rRc
注意三个文件上传到两个目录下
将这三个文件上传到下面的目录(sbbdpt.o ssbbded.o bbedus.msb,该三个文件拷贝oracle的linux64版本的)文件$ORACLE_HOME/rdbms/lib/ssbbded.o
$ORACLE_HOME/rdbms/lib/sbbdpt.o
$ORACLE_HOME/rdbms/mesg/bbedus.msb
执行如下命令:
[oracle@orale lib]$ cd $ORACLE_HOME/rdbms/lib
[oracle@orale lib]$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed
2、进入BBED 密码默认是 blockedit
[oracle@orale lib]$ bbed parfile=/home/oracle/par.txt
或者
[oracle@orale lib]$ bbedPassword:
BBED: Release 2.0.0.0.0 - Limited Production on Thu Nov 28 11:20:33 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************
BBED>
然后你还需要建两个文件
首先到sqlplus执行下这条语句
SQL> select file#||chr(9)||name||chr(9)||bytes from v$datafile;
FILE#||CHR(9)||NAME||CHR(9)||BYTES
--------------------------------------------------------------------------------
1 /u01/app/oracle/oradata/mypl/system01.dbf 524288000
2 /u01/app/oracle/oradata/mypl/sysaux01.dbf 340787200
3 /u01/app/oracle/oradata/mypl/undotbs01.dbf 209715200
4 /u01/app/oracle/oradata/mypl/users01.dbf 52428800
[oracle@orale lib]$ cd ~
[oracle@orale ~]$ vi par.txt
blocksize=8192listfile=filelist.txt
mode=edit
把之前执行的结果取过来加上后面两行就行了
[oracle@orale ~]$ vi filelist.txt
1 /u01/app/oracle/oradata/mypl/system01.dbf 524288000
2 /u01/app/oracle/oradata/mypl/sysaux01.dbf 340787200
3 /u01/app/oracle/oradata/mypl/undotbs01.dbf 209715200
4 /u01/app/oracle/oradata/mypl/users01.dbf 52428800
bbed parfile=par.txt
blockedit
搞定啦,
友情提示: 对数据结构不熟最好不要乱用BBED
不过虚拟机就随便啦