Oracle Unconventional recovery method: Skip archiving with bbed

First, bbed tools

Installation of 1.BBED

Oracle 11g missing bbed package, oracle11g bbed Install and example

1. Upload (SBBDPT.O ssbbded.o BBEDUS.MSB, the three files copy the linux64 version of Oracle) files

$ORACLE _HOME/RDBMS/LIB/SSBBDED.O

$ORACLE _HOME/RDBMS/LIB/SBBDPT.O

$ORACLE _HOME/RDBMS/MESG/BBEDUS.MSB

Execute the following command:

CD $ORACLE _home/rdbms/lib

Make-f $ORACLE _home/rdbms/lib/ins_rdbms.mk bbed= $ORACLE _home/bin/bbed $ORACLE _home/bin/bbed

2. Enter bbed

Bbed

Blockedit

$vi Par.txt

blocksize=8192

Listfile=filelist.txt

Mode=edit

$vi filelist.txt

Select File#| | Chr (9) | | name| | Chr (9) | | bytes from V$datafile;

1/U01/APP/ORACLE/ORADATA/OCP/SYSTEM01.DBF 512000000

2/U01/APP/ORACLE/ORADATA/OCP/SYSAUX01.DBF 412000000

3/U01/APP/ORACLE/ORADATA/OCP/USERS01.DBF 215000000

Bbed Parfile=par.txt

Blockedit

3. Common commands: Set, find, dump, modify, sum apply, examine, map, print, Verity

(1) Set file 3 Block 32

Set DBA 0x01000020

Set offset 0--0 indicates first byte start

Set Block 1--1 represents the start of the first chunk

Set Count 8192--default is to display 512 bytes

(2) find/x 05d67g--Check the specified string in the specified data block location

F--find, which indicates that the query string continues to proceed from the current position 05d67g

(3) Dump--16 view block

Dump/v--View the hexadecimal content as text to "translate" hexadecimal content, equivalent to executing the strings command on the current block

(4) modify/x d43--Modify the specified block to specify the contents of the data block within the offset

(5) Sum apply-Calculates the checksum value of the modified block of data, and writes the position of offset 16-17 of the data block

(6) Map

map/v

P KCBH

P KTBBH

P KDBH

P KDBT

P KCVFH

P KCVFH.KCVFHRFN

P KCVFH.KCVFHCKP

P *kdbr[0]--First line record

X/rnc-examine/read number char translates into a document that we can read with 16