bbed恢复删除数据

Posted on 2011 年 08 月 29 日 by 惜分飞

一、创建模拟环境
SQL> create table hr.xifenfei (id number,name varchar2(20)) tablespace xff;

Table created.

SQL> insert into hr.xifenfei values(1,’xifenfei’);

1 row created.

SQL> insert into hr.xifenfei values(2,’xff’);

1 row created.

SQL> commit;

Commit complete.

SQL> select * from hr.xifenfei;

ID NAME
———- ——————–
1 xifenfei
2 xff

SQL> select rowid,
2 dbms_rowid.rowid_relative_fno(rowid)rel_fno,
3 dbms_rowid.rowid_block_number(rowid)blockno,
4 dbms_rowid.rowid_row_number(rowid) rowno
5 from hr.xifenfei;

ROWID REL_FNO BLOCKNO ROWNO
—————— ———- ———- ———-
AAAHy3AACAAAAISAAA 2 530 0
AAAHy3AACAAAAISAAB 2 530 1
查询file#，block，后面恢复要用

SQL> delete from hr.xifenfei where id=2;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select * from hr.xifenfei;

ID NAME
———- ——————–
1 xifenfei

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

二、bbed恢复删除数据
[oracle@localhost ~]$ bbed parfile=/tmp/parfile.cnf
Password:

BBED: Release 2.0.0.0.0 – Limited Production on Mon Aug 22 01:52:52 2011

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

BBED> show all
FILE# 2
BLOCK# 1
OFFSET 0
DBA 0x00800001 (8388609 2,1)
FILENAME /opt/oracle/oradata/xifenfei/xff01.dbf
BIFILE bifile.bbd
LISTFILE /tmp/list
BLOCKSIZE 8192
MODE Edit
EDIT Unrecoverable
IBASE Dec
OBASE Dec
WIDTH 80
COUNT 512
LOGFILE log.bbd
SPOOL No

BBED> set dba 2,530
DBA 0x00800212 (8389138 2,530)

BBED> find /c xff
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8170 to 8191 Dba:0x00800212
————————————————————————
7866662c 000202c1 02087869 66656e66 65690106 80e2

<32 bytes per line>

BBED> dump /v
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8170 to 8191 Dba:0x00800212
——————————————————-
7866662c 000202c1 02087869 66656e66 l xff,……xifenf
65690106 80e2 l ei….

<16 bytes per line>

BBED> dump /v offset 8160
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8160 to 8191 Dba:0x00800212
——————————————————-
0000003c 020202c1 03037866 662c0002 l …<......xff,.. 02c10208 78696665 6e666569 010680e2 l ....xifenfei.... <16 bytes per line>

BBED> dump /v offset 8164
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8164 to 8191 Dba:0x00800212
——————————————————-
020202c1 03037866 662c0002 02c10208 l ……xff,……
78696665 6e666569 010680e2 l xifenfei….

<16 bytes per line>

BBED> dump /v offset 8162
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8162 to 8191 Dba:0x00800212
——————————————————-
003c0202 02c10303 7866662c 000202c1 l .<......xff,.... 02087869 66656e66 65690106 80e2 l ..xifenfei.... <16 bytes per line>

BBED> dump /v offset 8163
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8163 to 8191 Dba:0x00800212
——————————————————-
3c020202 c1030378 66662c00 0202c102 l <......xff,..... 08786966 656e6665 69010680 e2 l .xifenfei.... <16 bytes per line>
通过尝试，推断出来3c的offset

BBED> modify /x 2c
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)
Block: 530 Offsets: 8163 to 8191 Dba:0x00800212
————————————————————————
2c020202 c1030378 66662c00 0202c102 08786966 656e6665 69010680 e2

<32 bytes per line>
修改3c为2c

BBED> sum apply
Check value for File 2, Block 530:
current = 0xb1b9, required = 0xb1b9

三、核对结果
SQL> startup
ORACLE instance started.

Total System Global Area 236000356 bytes
Fixed Size 451684 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL> select * from hr.xifenfei;

ID NAME
———- ——————–
1 xifenfei
2 xff

说明：
1）如果数据未删除：row flag的值为 32+8+4=44或者0x2c
2）如果数据被删除：row flag的值为 32+16+8+4=60或者0x3c

bbed修改数据内容

Posted on 2011 年 08 月 28 日 by 惜分飞

1、创建模拟表

SQL> create table hr.b(id number,name varchar2(100)) tablespace xff;

Table created.

SQL> insert into hr.b values(1,’aaa’);

1 row created.

Commit complete.

2、查看数据位置

QL> select rowid,

2 dbms_rowid.rowid_relative_fno(rowid)rel_fno,

3 dbms_rowid.rowid_block_number(rowid)blockno,

4 dbms_rowid.rowid_row_number(rowid) rowno

5 from hr.b;

ROWID REL_FNO BLOCKNO ROWNO

—————— ———- ———- ———-

AAAHytAACAAAAIKAAA 2 522 0

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

虽然bbed 可以在db open 状态来进行修改，但是建议在做任何修改操作之前先shutdown db。这样避免checkpoint 进程重写bbed 对block 的修改。也避免oracle 在bbed 修改完成之前读block 或者申明block 为corrupt。

[oracle@localhost ~]$ bbed parfile=/tmp/parfile.cnf（/tmp/parfile.cnf文件见bbed破坏数据文件）

Password:

BBED: Release 2.0.0.0.0 – Limited Production on Sat Aug 20 17:10:24 2011

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

BBED> show all

FILE# 2

BLOCK# 1

OFFSET 0

DBA 0x00800001 (8388609 2,1)

FILENAME /opt/oracle/oradata/xifenfei/xff01.dbf

BIFILE bifile.bbd

LISTFILE /tmp/list

BLOCKSIZE 8192

MODE Edit

EDIT Unrecoverable

IBASE Dec

OBASE Dec

WIDTH 80

COUNT 512

LOGFILE log.bbd

SPOOL No

3、设置dba位置

BBED> set dba 2,522

DBA 0x0080020a (8389130 2,522)

4、查询aaa位置

BBED> find /c aaa

File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)

Block: 522 Offsets: 8185 to 8191 Dba:0x0080020a

————————————————————————

61616101 067735

<32 bytes per line>

5、查看该位置内容

BBED> dump /v offset 8185

File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)

Block: 522 Offsets: 8185 to 8191 Dba:0x0080020a

——————————————————-

61616101 067735 l aaa..w5

<16 bytes per line>

BBED> show all

FILE# 2

BLOCK# 522

OFFSET 8185

DBA 0x0080020a (8389130 2,522)

FILENAME /opt/oracle/oradata/xifenfei/xff01.dbf

BIFILE bifile.bbd

LISTFILE /tmp/list

BLOCKSIZE 8192

MODE Edit

EDIT Unrecoverable

IBASE Dec

OBASE Dec

WIDTH 80

COUNT 512

LOGFILE log.bbd

SPOOL No

6、修改aaa为bbb

BBED> modify /c bbb

Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y

File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)

Block: 522 Offsets: 8185 to 8191 Dba:0x0080020a

————————————————————————

62626201 067735

<32 bytes per line>

BBED> dump /v

File: /opt/oracle/oradata/xifenfei/xff01.dbf (2)

Block: 522 Offsets: 8185 to 8191 Dba:0x0080020a

——————————————————-

62626201 067735 l bbb..w5

<16 bytes per line>

7、应用变更

BBED> sum

Check value for File 2, Block 522:

current = 0xa285, required = 0xa286

此时 current checksum 是0xa285，requiredchecksum 是0xa286

BBED> sum apply

Check value for File 2, Block 522:

current = 0xa286, required = 0xa286

加上apply参数，使checksum一致。即之前的修改生效。

8、开启数据测试

SQL> startup

ORACLE instance started.

Total System Global Area 236000356 bytes

Fixed Size 451684 bytes

Variable Size 201326592 bytes

Database Buffers 33554432 bytes

Redo Buffers 667648 bytes

Database mounted.

Database opened.

SQL> col name for a20

SQL> select * from hr.b;

ID NAME

———- ——————–

1 bbb

bbed破坏数据文件

Posted on 2011 年 08 月 14 日 by 惜分飞

一、安装bbed

[oracle@ECP-UC-DB1 bin]$ cd $ORACLE_HOME/rdbms/lib

[oracle@ECP-UC-DB1 lib]$ ls -al *bb*

-rw-r–r– 1 oracle oinstall 1863 Mar 11 2008 sbbdpt.o

-rw-r–r– 1 oracle oinstall 1191 Mar 11 2008 ssbbded.o

[oracle@ECP-UC-DB1 lib]$ make -f ins_rdbms.mk $ORACLE_HOME/rdbms/lib/bbed

[oracle@ECP-UC-DB1 lib]$ mv bbed $ORACLE_HOME/bin

[oracle@ECP-UC-DB1 lib]$ cd ~

二、bben入门

[oracle@ECP-UC-DB1 ~]$ bbed

Password: blockedit（默认该密码）

BBED: Release 2.0.0.0.0 – Limited Production on Sun Aug 14 19:56:10 2011

************* !!! For Oracle Internal Use 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 [ <SET parameter> | ALL ]

INFO

MAP[/v] [ DBA | FILENAME | FILE | BLOCK ]

</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 ]

MODIFY[/x|d|u|o|c] numeric/character string

ASSIGN[/x|d|u|o] <target spec>=<source spec>

<source spec> : [ value | <target spec options> ]

SUM [ DBA | FILE | FILENAME | BLOCK ] [ APPLY ]

PUSH [ DBA | FILE | FILENAME | BLOCK | OFFSET ]

POP [ALL]

REVERT [ DBA | FILE | FILENAME | BLOCK ]

UNDO

HELP [ <bbed command> | ALL ]

VERIFY [ DBA | FILE | FILENAME | BLOCK ]

CORRUPT [ DBA | FILE | FILENAME | BLOCK ]

三、创建测试表

[oracle@ECP-UC-DB1 ~]$ sqlplus chf/xifenfei

SQL*Plus: Release 10.2.0.4.0 – Production on Sun Aug 14 19:58:46 2011

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create table t_bbed (id number,name varchar2(100)) tablespace xff;

Table created.

SQL> insert into t_bbed values(1,’xifenfei’);

1 row created.

SQL> insert into t_bbed values(2,’xff’);

1 row created.

SQL> insert into t_bbed values(3,’chengfei’);

1 row created.

SQL> commit;

Commit complete.

SQL> conn / as sysdba

Connected.

SQL> alter system checkpoint;

System altered.

SQL> conn chf/xifenfei

Connected.

SQL> set serveroutput on

SQL> declare

ridtype number;

objnum number;

relfno number;

blno number;

rowno number;

rid rowid;

begin

select rowid into rid from t_bbed where id=1;

dbms_rowid.rowid_info(rid,ridtype,objnum,relfno,blno,rowno,’SMALLFILE’);

dbms_output.put_line(‘Row Typ-‘||to_char(ridtype));

dbms_output.put_line(‘Obj No-‘||to_char(objnum));

dbms_output.put_line(‘RFNO-‘||to_char(relfno));

dbms_output.put_line(‘Block No-‘||to_char(blno));

dbms_output.put_line(‘Row No-‘||to_char(rowno));

end;–查看rowid对应的文件号，块号等信息

Row Typ-1

Obj No-52721

RFNO-6

Block No-780

Row No-1

PL/SQL procedure successfully completed.

四、bben准备工作

1、创建参数文件

[oracle@ECP-UC-DB1 ~]$ cat parfile.conf

blocksize=8192

listfile=list

mode=edit

2、创建数据文件列表

[oracle@ECP-UC-DB1 ~]$ cat list

1 /opt/oracle/oradata/test/xifenfei01.dbf 2097160192

五、修改数据块中内容

[oracle@ECP-UC-DB1 ~]$ bbed parfile=parfile.conf

Password:

BBED: Release 2.0.0.0.0 – Limited Production on Sun Aug 14 20:35:41 2011

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

1、定位需要修改块

BBED> set dba 1,780

DBA 0x0040030c (4195084 1,780)

2、查看相关内容

BBED> find /c xifenfei

File: /opt/oracle/oradata/test/xifenfei01.dbf (1)

Block: 780 Offsets: 8180 to 8191 Dba:0x0040030c

————————————————————————

78696665 6e666569 01062bce

<32 bytes per line>

3、dump文件中内容

BBED> dump /v dba 1,780 offset 8180 count 32

File: /opt/oracle/oradata/test/xifenfei01.dbf (1)

Block: 780 Offsets: 8170 to 8191 Dba:0x0040030c

——————————————————-

7866662c 010202c1 02087869 66656e66 l xff,……xifenf

65690106 2bce l ei..+.

<16 bytes per line>

4、修改数据块内容

BBED> modify 500 dba 1,780

Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y

File: /opt/oracle/oradata/test/xifenfei01.dbf (1)

Block: 780 Offsets: 8180 to 8191 Dba:0x0040030c

————————————————————————

01f46665 6e666569 01062bce

<32 bytes per line>

BBED> find /c xienfei

BBED-00212: search string not found

BBED> exit

六、验证修改是否成功

1、dbv验证

[oracle@ECP-UC-DB1 ~]$ dbv file =/opt/oracle/oradata/test/xifenfei01.dbf

DBVERIFY: Release 10.2.0.4.0 – Production on Sun Aug 14 20:30:56 2011

DBVERIFY – Verification starting : FILE = /opt/oracle/oradata/test/xifenfei01.dbf

Page 780 is marked corrupt

Corrupt block relative dba: 0x0180030c (file 6, block 780)

Bad check value found during dbv:

Data in bad block:

type: 6 format: 2 rdba: 0x0180030c

last change scn: 0x0000.0012ce2b seq: 0x1 flg: 0x06

spare1: 0x0 spare2: 0x0 spare3: 0x0

consistency value in tail: 0xce2b0601

check value in block header: 0x6382

computed block checksum: 0x1c

DBVERIFY – Verification complete

Total Pages Examined : 1280

Total Pages Processed (Data) : 690

Total Pages Failing (Data) : 0

Total Pages Processed (Index): 0

Total Pages Failing (Index): 0

Total Pages Processed (Other): 31

Total Pages Processed (Seg) : 0

Total Pages Failing (Seg) : 0

Total Pages Empty : 558

Total Pages Marked Corrupt : 1

Total Pages Influx : 0

Highest block SCN : 1232338 (0.1232338)

2、rman验证

[oracle@ECP-UC-DB1 ~]$ $ORACLE_HOME/bin/rman target /

Recovery Manager: Release 10.2.0.4.0 – Production on Sun Aug 14 20:39:55 2011

connected to target database: TEST (DBID=2056006906)

RMAN> backup check logical validate datafile 6;

Starting backup at 2011-08-14 20:40:06

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=155 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00006 name=/opt/oracle/oradata/test/xifenfei01.dbf

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2011-08-14 20:40:08

RMAN> exit

Recovery Manager complete.

3、直接查询验证

[oracle@ECP-UC-DB1 ~]$ sqlplus chf/xifenfei

SQL*Plus: Release 10.2.0.4.0 – Production on Sun Aug 14 20:40:14 2011

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select file#,block#,blocks from v$database_block_corruption;

FILE# BLOCK# BLOCKS

———- ———- ———-

6 780 1

SQL> conn / as sysdba

Connected.

SQL> alter system flush BUFFER_CACHE;

System altered.

SQL> select * from chf.t_bbed;

select * from chf.t_bbed

ERROR at line 1:

ORA-01578: ORACLE data block corrupted (file # 6, block # 780)

ORA-01110: data file 6: ‘/opt/oracle/oradata/test/xifenfei01.dbf’

13429648788

qq咨询

专业Oracle数据库恢复技术支持

专业Oracle数据库恢复，或许是您恢复数据的最后机会@phone:17813235971

Tag Archives: bbed

bbed恢复删除数据

bbed修改数据内容

bbed破坏数据文件

2025 年五月
S	M	T	W	T	F	S
« Apr
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30	31