Block Browser and EDitor

building

For 9i and 10g

~]$ cd $ORACLE_HOME/rdbms/lib
lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
lib]$ ./bbed
Password: blockedit

BBED: Release 2.0.0.0.0 - Limited Production on Tue Mar 8 14:35:08 2022

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED>

For 11g and latest

~]$ curl -o /soft/bbed_10g_x64.tar.gz /assets/software/tools/bbed_10g_x64.tar.gz
~]$ mkdir /soft/bbed_10g_x64
~]$ tar -zxvf /soft/bbed_10g_x64.tar.gz -C /soft/bbed_10g_x64

~]$ cp -a /soft/bbed_10g_x64/ssbbded.o $ORACLE_HOME/rdbms/lib/
~]$ cp -a /soft/bbed_10g_x64/sbbdpt.o $ORACLE_HOME/rdbms/lib/
~]$ cp -a /soft/bbed_10g_x64/bbedus.msb $ORACLE_HOME/rdbms/mesg/
~]$ cp -a /soft/bbed_10g_x64/bbedus.msg $ORACLE_HOME/rdbms/mesg/

~]$ cd $ORACLE_HOME/rdbms/lib
lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed
lib]$ ./bbed
Password: blockedit

BBED: Release 2.0.0.0.0 - Limited Production on Tue Mar 8 14:35:08 2022

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED>

operation

查询数据文件信息，并保存至 bbed filelist 文件中.

SQL> set heading off
SQL> set feedback off
SQL> spool /u01/bbedlist.parf
SQL> select file#||' '||name||' '||bytes from v$datafile;
1 /u01/app/oracle/oradata/orcl/system01.dbf 461373440
2 /u01/app/oracle/oradata/orcl/undotbs01.dbf 414187520
3 /u01/app/oracle/oradata/orcl/sysaux01.dbf 272629760
4 /u01/app/oracle/oradata/orcl/users01.dbf 5242880
5 /u01/app/oracle/oradata/ccdata.dbf 1825570816
SQL> spool off;

创建 parameter file.

cat >> /u01/bbed.par <<EOF
blocksize=8192
listfile=/u01/bbedlist.parf
mode=edit
EOF

连接 bbed.

[oracle@centos7 lib]$ ./bbed parfile=/u01/bbed.par password=blockedit

BBED: Release 2.0.0.0.0 - Limited Production on Tue Mar 8 15:24:27 2022

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

************* !!! For Oracle Internal Use only !!! ***************

BBED> show
        FILE#           1
        BLOCK#          1
        OFFSET          0
        DBA             0x00400001 (4194305 1,1)
        FILENAME        /u01/app/oracle/oradata/orcl/system01.dbf
        BIFILE          bifile.bbd
        LISTFILE        /u01/bbedlist.parf
        BLOCKSIZE       8192
        MODE            Edit
        EDIT            Unrecoverable
        IBASE           Dec
        OBASE           Dec
        WIDTH           80
        COUNT           512
        LOGFILE         log.bbd
        SPOOL           No

BBED>