Installing Oracle Block Browser and Editor tool (bbed)

Source: Internet
Author: User

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.