bbed破坏数据文件

一、安装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

Copyright (c) 1982, 2007, Oracle. All rights reserved.

************* !!! 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 ]

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

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

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

Copyright (c) 1982, 2007, Oracle. All rights reserved.

************* !!! 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

Copyright (c) 1982, 2007, Oracle. All rights reserved.

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: 0×0000.0012ce2b seq: 0×1 flg: 0×06

spare1: 0×0 spare2: 0×0 spare3: 0×0

consistency value in tail: 0xce2b0601

check value in block header: 0×6382

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

Copyright (c) 1982, 2007, Oracle. All rights reserved.

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

Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

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’