bbed is an internal tool for Oracle, and typically uses bbed to recover some of the failed databases, such as data file header inconsistencies caused by power outages or abnormal shutdown of the operating system, and system tablespace corruption, which can be recovered using the bbed tool. compiling in 11G usually reports the following error:[email protected] lib]$ make-f ins_rdbms.mk $ORACLE _home/rdbms/lib/bbed
Linking bbed utility (bbed)
Rm-f/opt/oracle/products/11.2.0/rdbms/lib/bbed
Gcc-o/opt/oracle/products/11.2.0/rdbms/lib/bbed-m64-l/opt/oracle/products/11.2.0/rdbms/lib/-L/opt/oracle/ products/11.2.0/lib/-l/opt/oracle/products/11.2.0/lib/stubs/ /opt/oracle/products/11.2.0/lib/s0main.o/opt /ORACLE/PRODUCTS/11.2.0/RDBMS/LIB/SSBBDED.O/OPT/ORACLE/PRODUCTS/11.2.0/RDBMS/LIB/SBBDPT.O ' cat/opt/oracle/ Products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-ldbtools11-lclntsh ' Cat/opt/oracle/products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnro11 ' CAT/ Opt/oracle/products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnnz11-lzt11- lztkg11-lztkg11-lclient11-lnnetd11 -lvsn11-lcommon11-lgeneric11-lmm-lsnls11-lnls11 -LCORE11-LSNLS11- Lnls11-lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lnls11 ' CAT/OPT/ORACLE/PRODUCTS/11. 2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnL11-lnro11 ' cat/opt/oracle/products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11- lclient11-lnnetd11 -lvsn11-lcommon11-lgeneric11 -lsnls11-lnls11 -LCORE11-LSNLS11-LNLS11- lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lnls11-lclient11-lnnetd11 -lvsn11-l common11-lgeneric11-lsnls11-lnls11 -LCORE11-LSNLS11-LNLS11-LCORE11-LSNLS11-LNLS11-LXML11-LCORE11-LUNLS11 -lsnls11-lnls11-lcore11-lnls11 ' Cat/opt/oracle/products/11.2.0/lib/sysliblist '-Wl,-rpath,/opt/ oracle/products/11.2.0/lib-lm ' Cat/opt/oracle/products/11.2.0/lib/sysliblist '-ldl-lm -l/opt/oracle/products/11.2.0/lib
GCC:/opt/oracle/products/11.2.0/rdbms/lib/ssbbded.o:no such file or directory
GCC:/opt/oracle/products/11.2.0/rdbms/lib/sbbdpt.o:no such file or directory
Make: * * * [/opt/oracle/products/11.2.0/rdbms/lib/bbed] Error 1
because of the lack of the corresponding library files, but we can be copied from the 10G:
[[email protected] lib]$ ls *sbb*
SBBDPT.O SSBBDED.O
[email protected] lib]$ SCP *sbb* 192.168.56.12: ' pwd '
The authenticity of host ' 192.168.56.12 (192.168.56.12) ' can ' t be established.
RSA key fingerprint is de:78:11:e4:45:be:48:83:50:5f:c8:6e:08:ad:ae:7e.
Is you sure want to continue connecting (yes/no)? Yes
warning:permanently added ' 192.168.56.12 ' (RSA) to the list of known hosts.
[email protected] ' s password:
SCP:/u01/app/oracle/product/10.2.0/db_1/rdbms/lib:no such file or directory
[email protected] lib]$ SCP *sbb* 192.168.56.12:/opt/oracle/products/11.2.0/rdbms/lib
[email protected] ' s password:
SBBDPT.O 100% 1863 1.8kb/s 00:00
SSBBDED.O 100% 1191 1.2kb/s 00:00
[Email protected] mesg]$ SCP *bbed* 192.168.56.12:/OPT/ORACLE/PRODUCTS/11.2.0/RDBMS/MESG
[email protected] ' s password:
Bbedus.msb 100% 8704 8.5kb/s 00:00
Bbedus.msg 100% 10KB 10.0kb/s 00:00
Recompile :
[Email protected] lib]$ make-f ins_rdbms.mk $ORACLE _home/rdbms/lib/bbed
Linking bbed utility (bbed)
Rm-f/opt/oracle/products/11.2.0/rdbms/lib/bbed
Gcc-o/opt/oracle/products/11.2.0/rdbms/lib/bbed-m64-l/opt/oracle/products/11.2.0/rdbms/lib/-L/opt/oracle/ products/11.2.0/lib/-l/opt/oracle/products/11.2.0/lib/stubs/ /opt/oracle/products/11.2.0/lib/s0main.o/opt /ORACLE/PRODUCTS/11.2.0/RDBMS/LIB/SSBBDED.O/OPT/ORACLE/PRODUCTS/11.2.0/RDBMS/LIB/SBBDPT.O ' cat/opt/oracle/ Products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-ldbtools11-lclntsh ' Cat/opt/oracle/products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnro11 ' CAT/ Opt/oracle/products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnnz11-lzt11- lztkg11-lztkg11-lclient11-lnnetd11 -lvsn11-lcommon11-lgeneric11-lmm-lsnls11-lnls11 -LCORE11-LSNLS11- Lnls11-lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lnls11 ' CAT/OPT/ORACLE/PRODUCTS/11. 2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnL11-lnro11 ' cat/opt/oracle/products/11.2.0/lib/ldflags ' -lncrypt11-lnsgr11-lnzjs11-ln11-lnl11- lclient11-lnnetd11 -lvsn11-lcommon11-lgeneric11 -lsnls11-lnls11 -LCORE11-LSNLS11-LNLS11- lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lnls11-lclient11-lnnetd11 -lvsn11-l common11-lgeneric11-lsnls11-lnls11 -LCORE11-LSNLS11-LNLS11-LCORE11-LSNLS11-LNLS11-LXML11-LCORE11-LUNLS11 -lsnls11-lnls11-lcore11-lnls11 ' Cat/opt/oracle/products/11.2.0/lib/sysliblist '-Wl,-rpath,/opt/ oracle/products/11.2.0/lib-lm ' Cat/opt/oracle/products/11.2.0/lib/sysliblist '-ldl-lm -l/opt/oracle/products/11.2.0/lib
[Email protected] lib]$ ls-l bbed
-rwxr-xr-x 1 Oracle Oinstall 262144 SEP 4 03:46 bbed
[email protected] mesg]$ bbed
Password:blockedit
Bbed:release 2.0.0.0.0-limited Production on Thu Sep 4 03:54:08 2014
Copyright (c) 1982, the Oracle and/or its affiliates. All rights reserved.
************* !!! For Oracle Internal with only!!! ***************
Bbed> Help All
SET DBA [DBA | file#, block#]
SET filename ' filename '
SET FILE file#
SET BLOCK [+/-]block#
SET OFFSET [[+/-]byte offset | symbol | *symbol]
SET BLOCKSIZE bytes
SET list[file] ' filename '
SET WIDTH Character_count
SET COUNT Bytes_to_display
SET IBASE [HEX | OCT | DEC]
SET OBASE [HEX | OCT | DEC]
SET MODE [BROWSE | EDIT]
SET SPOOL [Y | N
SHOW [| ALL]
INFO
MAP[/V] [DBA | FILENAME | FILE | BLOCK]
DUMP[/V] [DBA | FILENAME | FILE | BLOCK | OFFSET | COUNT]
PRINT[/X|D|U|O|C] [DBA | FILE | FILENAME | BLOCK | OFFSET | Symbol | *symbol]
EXAMINE[/NUF] [DBA | FILE | FILENAME | BLOCK | OFFSET | Symbol | *symbol]
</nuf>:
N-A number which specifies a repeat count.
U-a letter which specifies a unit size:
B-B1, Ub1 (byte)
H-B2, UB2 (Half-word)
W-B4, UB4 (word)
R-oracle Table/index Row
F-a letter which specifies a display format:
X-hexadecimal
D-decimal
u-unsigned Decimal
O-octal
C-character (native)
N-oracle number
T-oracle Date
I-oracle rowID
FIND[/X|D|U|O|C] numeric/character string [TOP | CURR]
COPY [DBA | FILE | FILENAME | BLOCK] to [DBA | FILE | FILENAME | BLOCK]
MODIFY[/X|D|U|O|C] Numeric/character string
[DBA | FILE | FILENAME | BLOCK | OFFSET | Symbol | *symbol]
Assign[/x|d|u|o] <target Spec>=<source spec>
<target spec>: [DBA | FILE | FILENAME | BLOCK | OFFSET | Symbol | *symbol]
<source spec>: [value |]
SUM [DBA | FILE | FILENAME | BLOCK] [APPLY]
PUSH [DBA | FILE | FILENAME | BLOCK | OFFSET]
POP [All]
REVERT [DBA | FILE | FILENAME | BLOCK]
UNDO
Help [| ALL]
VERIFY [DBA | FILE | FILENAME | BLOCK]
corrupt [DBA | FILE | FILENAME | BLOCK]
Bbed>
For more information:
Installing Oracle Block Browser and Editor tool (bbed)