Oracle之BBED之(二）-----BBED更改数据块

本次修改测试环境

SQL> select * from test01;


ID NAME
---------- ------------------------------
1 AAAAAAA
2 BBBBBB
3 CCCCCC

本次通过修改test01表中的BBBBBB选项

根据ORACLE之BBED之（一）使用BBED dump数据文件

BBED> dump
 File: /u01/app/oracle/oradata/Oracle10g/test01.dbf (6)
 Block: 12               Offsets:    0 to 8191           Dba:0x0180000c
------------------------------------------------------------------------
 06a20000 0c008001 1c8e0600 00000206 b7560000 01000000 cace0000 198e0600 
 00000000 02003200 09008001 04002100 0a010000 2d058000 d5001d00 00800000 
 c5880600 02000400 f3000000 1e008000 cf002500 01200000 1c8e0600 00000000 
 00000000 00010300 ffff1800 631f581f 581f0000 0300631f 7e1f711f 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

…………………………中间省略……………………

 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000 
 00000000 0000002c 020202c1 02074141 41414141 412c0002 02c10406 43434343 
 43432c00 0202c103 06424242 4242422c 000202c1 02064141 41414141 02061c8e 


 <32 bytes per line>

BBED修改数据块（设置模式为edit）

 

BBED> set modeedit

MODE                  Edit

（1）确定修改的字节

BBED> help find

FIND[/x|d|u|o|c]numeric/character string [ TOP | CURR ]

说明：x 使用十六进制进行寻找  d 使用十进制进行寻找 c 使用字符串进行寻找

 

BBED> find /cBBBBBB

 File:/u01/app/oracle/oradata/Oracle10g/test01.dbf (6)

 Block: 12               Offsets: 8169 to 8191           Dba:0x0180000c

------------------------------------------------------------------------

 42424242 42422c00 0202c102 06414141 41414102061c8e

 

 <32 bytes per line>

BBED> show all

FILE#                 6

BLOCK#                12

OFFSET                8169 偏移量在find之后会自己更改

DBA                   0x0180000c (251658366,12)

FILENAME              /u01/app/oracle/oradata/Oracle10g/test01.dbf

BIFILE                bifile.bbd

LISTFILE              /home/oracle/bbed.list

BLOCKSIZE             8192

MODE                  Browse

EDIT                  Unrecoverable

IBASE                 Dec

OBASE                 Dec

WIDTH                 80

COUNT                 8192

LOGFILE               log.bbd

SPOOL                 No

若是再重新查找则需要把偏移量重新设置，这时候如果dump则dump偏移量后面的数据

BBED> dump

 File:/u01/app/oracle/oradata/Oracle10g/test01.dbf (6)

 Block: 12               Offsets: 8169 to 8191           Dba:0x0180000c

------------------------------------------------------------------------

 42424242 42422c00 0202c102 06414141 41414102061c8e

 

 <32 bytes per line>

修改数据：

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

      [ DBA | FILE | FILENAME | BLOCK | OFFSET| symbol | *symbol ]

BBED> modify /cDDDDDD

 File:/u01/app/oracle/oradata/Oracle10g/test01.dbf (6)

 Block: 12               Offsets: 8169 to 8191           Dba:0x

---------------------------------------------------------------

 44444444 44442c00 0202c102 06414141 41414102061c8e

 

 <32 bytes per line>

修改校验值

BBED>sum apply

Check value for File6, Block 12:

current = 0x50b1,required = 0x50b1

刷新一下缓存

SQL> alter systemflush buffer_cache;

 

System altered.

查看修改结果：

SQL> select *from test01;

 

IDNAME

----------------------------------------

 1 AAAAAAA

 2 DDDDDD

 3 CCCCCC