Shulou(Shulou.com)06/01 Report--

BBED introduction:

BBED (Oracle Block Browerand EDitor Tool), a tool used to view and modify data file data directly, is an internal tool of Oracle, which can directly modify the contents of Oracle data file blocks, which is useful in some extreme recovery scenarios. This tool is not supported by Oracle, so no executable file is generated by default, and you need to reconnect before using it.

This article gives a detailed introduction to the tutorial on compiling and using BBED under Oracle 11g. Let's take a look at the detailed introduction.

Environment: RHEL 6.4 + Oracle 11.2.0.4

1. Copy missing files

Several related files are missing in 11g, but we can actually copy them from 10g to 11g corresponding directory:

$ORACLE_HOME/rdbms/lib/sbbdpt.o$ORACLE_HOME/rdbms/lib/ssbbded.o$ORACLE_HOME/rdbms/mesg/bbedus.msb$ORACLE_HOME/rdbms/mesg/bbedus.msg

two。 Compile BBED

Make-f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbed

The result of successful compilation is as follows:

[oracle@JY-DB01 dbhome_1] $make-f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk BBED=$ORACLE_HOME/bin/bbed $ORACLE_HOME/bin/bbedLinking BBED utility (bbed) rm-f / u02/app/oracle/product/11.2.0/dbhome_1/bin/bbedgcc-o / u02/app/oracle/product/11.2.0/dbhome_1/bin/bbed-M64-z noexecstack-L/u02/app/oracle/product/11.2.0/dbhome_1 / rdbms/lib/-L/u02/app/oracle/product/11.2.0/dbhome_1/lib/-L/u02/app/oracle/product/11.2.0/dbhome_1/lib/stubs/ / u02/app/oracle/product/11.2.0/dbhome_1/lib/s0main.o / u02/app/oracle/product/11.2.0/dbhome_1/rdbms/lib/ssbbded.o / u02/app/oracle/product/11.2.0 / dbhome_1/rdbms/lib/sbbdpt.o `cat / u02/app/oracle/product/11.2.0/dbhome_1/lib/ ldSecrets`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-ldbtools11-lclntsh `cat / u02/app/oracle/product/11.2.0/dbhome_1/lib/l dSecrets`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnro11 `cat / u02/app/oracle/product/11.2.0/dbhome_1/lib/ ldSecrets`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnnz11- Lzt11-lztkg11-lclient11-lnnetd11-lvsn11-lcommon11-lgeneric11-lmm-lsnls11-lnls11-lcore11-lsnls11-lnls11-lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lnls11 `cat / u02/app/oracle/product/11.2.0/dbhome_1/lib/ ldfants`-lncrypt11-lnsgr11-lnzjs11-ln11-lnl11-lnro11 `cat / u02/app/oracle/product/11.2.0/dbhome_1/lib/ ldfants`-lncrypt11-lnsgr11-lnzjs11-lnzjs11-ln11-ln11-lnl11-ln11- Lcommon11-lgeneric11-lsnls11-lnls11-lcore11-lsnls11-lnls11-lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lnls11-lclient11-lnnetd11-lvsn11-lcommon11-lgeneric11-lsnls11-lnls11-lcore11-lsnls11-lnls11-lcore11-lsnls11-lnls11-lxml11-lcore11-lunls11-lsnls11-lnls11-lcore11-lcore11 `lnls11 / lnls11 sysliblist`-cat -rpath,/u02/app/oracle/product/11.2.0/dbhome_1/lib-lm `cat / u02/app/oracle/product/11.2.0/dbhome_1/lib/ sysliblist`-ldl-lm-L/u02/app/oracle/product/11.2.0/dbhome_1/lib

3. BBED usage testing

-- 3.1 bbed command test available [oracle@JY-DB01 dbhome_1] $bbedPassword:-- password defaults to blockeditBBED: Release 2.0.0.0.0-Limited Production on Mon Jan 18 15:13:09 2016Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.*! For Oracle Internal Use only!! * BBED > help allSET DBA [dba | file# Block#] SET FILENAME 'filename'SET FILE file#SET BLOCK [+ / -] block#SET OFFSET [[+ / -] byte offset | symbol | * symbol] SET BLOCKSIZE bytesSET LIST [FILE]' filename'SET WIDTH character_countSET COUNT bytes_to_displaySET IBASE [HEX | OCT | DEC] SET OBASE [HEX | OCT | DEC] SET MODE [BROWSE | EDIT] SET SPOOL [Y | N] SHOW [| ALL] INFOMAP [/ 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]: 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 rowf-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 rowidFIND [/ x | d | o | c] numeric/character string [TOP | CURR] COPY [DBA | FILE | FILENAME | BLOCK] TO [DBA | FILE | FILENAME | BLOCK] numeric/character string [/ x | d | o | c] numeric/character string [DBA | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol] Assign [/ x | d | u | o] = [DBA | | FILE | FILENAME | BLOCK | OFFSET | symbol | * symbol]: [value |] SUM [DBA | FILE | FILENAME | BLOCK] [APPLY] PUSH [DBA | FILE | FILENAME | BLOCK | OFFSET] POP [ALL] REVERT [DBA | FILE | FILENAME | BLOCK] UNDOHELP [| ALL] VERIFY [DBA | FILE | FILENAME | BLOCK] CORRUPT [DBA | FILE | FILE | FILENAME] FILENAME >-3.2. The command parameter [FILENAME] $BLOCK-BLOCK- SizeLISTFILE-List file nameMODE-[browse/edit] SPOOL-Spool to logfile [no/yes] CMDFILE-BBED command file nameLOGFILE-BBED logfile namePARFILE-Parameter file nameBIFILE-BBED before-image file nameREVERT-Rollback changes from BIFILE [no/yes] SILENT-Hide banner [no/yes] HELP-Show all valid parameters [no/yes]

In addition, when using bbed, you usually write the configuration parameters in the parameter configuration file, and then call the configuration file directly, such as:

-- Editing / tmp/bbed.par parameter configuration file blocksize=8192listfile=/tmp/listfile.txtmode=edit-- editing / tmp/listfile.txt file 5 / u02/oradata/jingyu/dbs_d_jingyu01.dbf 314572806 / u02/oradata/jingyu/dbs_i_jingyu01.dbf 31457280-calling bbedcd / tmpbbed parfile=bbed.par

Reference

Oracle BBED tool description

Quick start oracle bbed in four steps

Summary

The above is the whole content of this article, I hope that the content of this article can bring some help to your study or work, if you have any questions, you can leave a message and exchange, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.