[20210311]如何建立bbed安装包.txt

--//这个跟我的一次经历有关，帮别人恢复一个坏块里数据，对方机器里面没有安装bbed，而且bbed的安装要从10g上拷贝一些文件然后
--//编译，网上有一些链接讲解如何安装编译bbed在11g下。可以参考链接：
--//http://blog.itpub.net/267265/viewspace-745588/ => [20121004]11G下编译bbed.txt

--//今天尝试在11g做一个安装包，以后直接解压拷贝就可以使用，我仅仅介绍如何制作的方法。

1.环境：
SCOTT@book> @ ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.确定需要文件：
$ ldd $(which bbed)
        linux-vdso.so.1 =>  (0x00007fff0974c000)
        ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        libclntsh.so.11.1 => /u01/app/oracle/product/11.2.0.4/dbhome_1/lib/libclntsh.so.11.1 (0x00007f2b46c6e000)
        libnnz11.so => /u01/app/oracle/product/11.2.0.4/dbhome_1/lib/libnnz11.so (0x00007f2b468a0000)
        libdl.so.2 => /lib64/libdl.so.2 (0x0000003799800000)
        libm.so.6 => /lib64/libm.so.6 (0x00000032cac00000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x000000379a000000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x000000379c400000)
        libc.so.6 => /lib64/libc.so.6 (0x0000003799000000)
        libaio.so.1 => /usr/lib64/libaio.so.1 (0x00007f2b4669d000)
        /lib64/ld-linux-x86-64.so.2 (0x0000003798c00000)
--//注下划线文件找不到,这个很特殊，大家可以网上检索就知道了。
--//实际上只要拷贝/u01下的2个文件。

$ mkdir -p bbedins
$ cd bbedins
--//拷贝上面看到的文件到该目录包括bbed执行文件。
$ ll
total 63440
-rwxr-xr-x 1 oracle oinstall   255300 2021-03-10 17:19:53 bbed
-rwxr-xr-x 1 oracle oinstall   144776 2021-03-10 17:22:18 ld-linux-x86-64.so.2
-rwxr-xr-x 1 oracle oinstall     3768 2021-03-10 17:22:12 libaio.so.1
-rwxr-xr-x 1 oracle oinstall 53793394 2021-03-10 17:20:37 libclntsh.so.11.1
-rwxr-xr-x 1 oracle oinstall  1726320 2021-03-10 17:22:06 libc.so.6
-rwxr-xr-x 1 oracle oinstall    23360 2021-03-10 17:21:00 libdl.so.2
-rwxr-xr-x 1 oracle oinstall   614992 2021-03-10 17:21:13 libm.so.6
-rw-r--r-- 1 oracle oinstall  7996693 2021-03-10 17:20:46 libnnz11.so
-rwxr-xr-x 1 oracle oinstall   114352 2021-03-10 17:22:00 libnsl.so.1
-rwxr-xr-x 1 oracle oinstall   149968 2021-03-10 17:21:23 libpthread.so.0

3.启动bbed，确定还有那些文件需要：
$ ps -ef | grep bbe[d]
oracle   18754 18369  0 08:31 pts/2    00:00:00 /usr/local/bin/rlwrap -s 9999 -c -r -i -f /usr/local/share/rlwrap/bbed /u01/app/oracle/product/11.2.0.4/dbhome_1/bin/bbed parfile=bbed.par cmdfile=cmd.par
oracle   18755 18754  0 08:31 pts/7    00:00:00 bbed app/oracle/product/11.2.0.4/dbhome_1/bin/bbed parfile=bbed.par cmdfile=cmd.par
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
--//进程号 18755.

$ ls -l /proc/18755/fd
total 0
lrwx------ 1 oracle oinstall 64 2021-03-11 08:31:28 0 -> /dev/pts/7
lrwx------ 1 oracle oinstall 64 2021-03-11 08:31:28 1 -> /dev/pts/7
lrwx------ 1 oracle oinstall 64 2021-03-11 08:31:19 2 -> /dev/pts/7
lr-x------ 1 oracle oinstall 64 2021-03-11 08:31:28 3 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/bbedus.msb
lr-x------ 1 oracle oinstall 64 2021-03-11 08:31:28 4 -> /u01/app/oracle/product/11.2.0.4/dbhome_1/oracore/mesg/lrmus.msb
lr-x------ 1 oracle oinstall 64 2021-03-11 08:31:28 5 -> /home/oracle/bbed/filelist.txt
lrwx------ 1 oracle oinstall 64 2021-03-11 08:31:28 6 -> /mnt/ramdisk/book/system01.dbf
l-wx------ 1 oracle oinstall 64 2021-03-11 08:31:28 7 -> /home/oracle/bbed/log.bbd
lr-x------ 1 oracle oinstall 64 2021-03-11 08:31:28 8 -> /home/oracle/bbed/cmd.par
--//注意/u01目录下几个文件。

$ cd bbedins
$ cp /u01/app/oracle/product/11.2.0.4/dbhome_1/rdbms/mesg/bbedus.ms?  .
$ cp /u01/app/oracle/product/11.2.0.4/dbhome_1/oracore/mesg/lrmus.ms? .

--//$ find . -type f -exec ls -l {} \;
$ ll
total 63468
-rwxr-xr-x 1 oracle oinstall   255300 2021-03-10 17:19:53 bbed
-rw-r--r-- 1 oracle oinstall       75 2021-03-11 09:24:38 bbed.par
-rw-r--r-- 1 oracle oinstall     8704 2021-03-11 09:24:22 bbedus.msb
-rwxr-xr-x 1 oracle oinstall    10299 2021-03-11 09:24:22 bbedus.msg
-rw-r--r-- 1 oracle oinstall       27 2021-03-11 08:55:01 cmd.par
-rw-r--r-- 1 oracle oinstall     1352 2021-03-11 09:00:23 filelist.txt
-rwxr-xr-x 1 oracle oinstall   144776 2021-03-10 17:22:18 ld-linux-x86-64.so.2
-rwxr-xr-x 1 oracle oinstall     3768 2021-03-10 17:22:12 libaio.so.1
-rwxr-xr-x 1 oracle oinstall 53793394 2021-03-10 17:20:37 libclntsh.so.11.1
-rwxr-xr-x 1 oracle oinstall  1726320 2021-03-10 17:22:06 libc.so.6
-rwxr-xr-x 1 oracle oinstall    23360 2021-03-10 17:21:00 libdl.so.2
-rwxr-xr-x 1 oracle oinstall   614992 2021-03-10 17:21:13 libm.so.6
-rw-r--r-- 1 oracle oinstall  7996693 2021-03-10 17:20:46 libnnz11.so
-rwxr-xr-x 1 oracle oinstall   114352 2021-03-10 17:22:00 libnsl.so.1
-rwxr-xr-x 1 oracle oinstall   149968 2021-03-10 17:21:23 libpthread.so.0
-rw-r--r-- 1 oracle oinstall     4608 2021-03-11 09:26:20 lrmus.msb
-rw-r--r-- 1 oracle oinstall     4433 2021-03-11 09:26:20 lrmus.msg

--//使用tar命令打包。
$ cd /home/oracle/
$ tar czf bbedins.tgz bbedins

3.测试：
--//拷贝tar包到另外的服务器，解压：
# cd /home/oracle
# tar xzvf bbedins.tgz
bbedins/
bbedins/bbedus.msb
bbedins/bbed.par
bbedins/bbed
bbedins/lrmus.msg
bbedins/libnsl.so.1
bbedins/bbedus.msg
bbedins/libaio.so.1
bbedins/libm.so.6
bbedins/libclntsh.so.11.1
bbedins/ld-linux-x86-64.so.2
bbedins/libc.so.6
bbedins/libpthread.so.0
bbedins/libnnz11.so
bbedins/lrmus.msb
bbedins/libdl.so.2
bbedins/filelist.txt
bbedins/cmd.par

# chown -R oracle:oinstall bbedins
--//注好像现在的tar命令做了改进，自动完成，只要你服务器有oracle用户和oinstall组。也就是这步可能可以省略。
--//登录oracle用户测试：

$ rlwrap ./bbed parfile=bbed.par cmdfile=cmd.par
./bbed: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

$ export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/oracle/bbedins

$ rlwrap ./bbed parfile=bbed.par cmdfile=cmd.par
BBED: Release 2.0.0.0.0 - Limited Production on Thu Mar 11 09:43:49 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************

BBED> set count 64
        COUNT           64

BBED> set width 160
        WIDTH           160

BBED> help verify
Message 1029 not found; No message file for product=RDBMS, facility=BBED

$ cp bbedus.ms? /u01/app/oracle/product/18.0.0/db_home/rdbms/mesg/
$ rlwrap ./bbed parfile=bbed.par cmdfile=cmd.par
BBED: Release 2.0.0.0.0 - Limited Production on Thu Mar 11 09:45:11 2021
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
************* !!! For Oracle Internal Use only !!! ***************

BBED> set count 64
        COUNT           64

BBED> set width 160
        WIDTH           160

BBED> help verify
VERIFY [ DBA | FILE | FILENAME | BLOCK ]

--//这样基本能正常使用了。
4.补充说明：
$ ldd bbed
        linux-vdso.so.1 =>  (0x00007ffcde366000)
        libclntsh.so.11.1 => /home/oracle/bbedins/libclntsh.so.11.1 (0x00007f26fe18b000)
        libnnz11.so => /home/oracle/bbedins/libnnz11.so (0x00007f26fddbd000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00007f26fdbb9000)
        libm.so.6 => /lib64/libm.so.6 (0x00007f26fd8b7000)
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f26fd69a000)
        libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f26fd480000)
        libc.so.6 => /lib64/libc.so.6 (0x00007f26fd0b2000)
        libaio.so.1 => /lib64/libaio.so.1 (0x00007f26fceaf000)
        /lib64/ld-linux-x86-64.so.2 (0x000055e8185de000)
--//实际上仅仅需要2个oracle的库文件。另外我发现我们一些服务器LD_LIBRARY_PATH环境变量并没有定义。
--//需要自己人为定义例子：
$ export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/local/lib:/lib64:/usr/lib64:/usr/local/lib64:/home/oracle/bbedins

5.附上参数文件配置：

$ cat cmd.par
set count 64
set width 160

$ cat bbed.par
blocksize=8192
#listfile=filelist.txt
mode=edit
PASSWORD=blockedit
SPOOL=Y
--//listfile那行我注解了。filelist.txt的生成可以执行select file#||' '||name c100 from v$dbfile order by 1;：例子如下：
SYS@book> select file#||' '||name c100 from v$dbfile order by 1;
C100
----------------------------------------
1 /mnt/ramdisk/book/system01.dbf
2 /mnt/ramdisk/book/sysaux01.dbf
3 /mnt/ramdisk/book/undotbs01.dbf
4 /mnt/ramdisk/book/users01.dbf
5 /mnt/ramdisk/book/example01.dbf
6 /mnt/ramdisk/book/tea01.dbf
7 /mnt/ramdisk/book/mssm01.dbf
8 /mnt/ramdisk/book/big.dbf
8 rows selected.