环境:
OS:Centos 7
DB:11.2.0.4
1.表数据内容
SQL> select * from bbed;
ID NAME
---------- --------------------
1 hxl
2 hxl02
2.获取数据内容的块信息
select
rowid,
dbms_rowid.rowid_relative_fno(rowid)rel_fno,
dbms_rowid.rowid_block_number(rowid)blockno,
dbms_rowid.rowid_row_number(rowid) rowno
from bbed;
ROWID REL_FNO BLOCKNO ROWNO
------------------ ---------- ---------- ----------
AAAVbBAAFAAApGFAAA 5 168325 0
AAAVbBAAFAAApGFAAB 5 168325 1
3.查找关键字hxl,确定其在block中的偏移量offset.
BBED> set dba 5,168325 offset 0
DBA 0x01429185 (21139845 5,168325)
OFFSET 0
BBED> find /c hxl
File: /u01/app/oracle/oradata/ora11g/tps_hxl01.dbf (5)
Block: 168325 Offsets: 8173 to 8191 Dba:0x01429185
------------------------------------------------------------------------
68786c30 322c0102 02c10203 68786c01 06080d
<32 bytes per line>
注意这里查找是从后面开始查找起来的,那么这样的话查找的是hxl02这条纪录.
4.dump查看具体内容
BBED> dump /v dba 5,168325 offset 8173 count 128
File: /u01/app/oracle/oradata/ora11g/tps_hxl01.dbf (5)
Block: 168325 Offsets: 8173 to 8191 Dba:0x01429185
-------------------------------------------------------
68786c30 322c0102 02c10203 68786c01 l hxl02,...á..hxl.
06080d l ...
<16 bytes per line>
5.修改block，将hxl 换成jjf
BBED> modify /c 'jjf' dba 5,168325 offset 8173
Warning: contents of previous BIFILE will be lost. Proceed? (Y/N) y
File: /u01/app/oracle/oradata/ora11g/tps_hxl01.dbf (5)
Block: 168325 Offsets: 8173 to 8191 Dba:0x01429185
------------------------------------------------------------------------
68786c20 322c0102 02c10203 68786c01 06080d
<32 bytes per line>
查看内容
BBED> dump /v dba 5,168325 offset 8173 count 128
File: /u01/app/oracle/oradata/ora11g/tps_hxl01.dbf (5)
Block: 168325 Offsets: 8173 to 8191 Dba:0x01429185
-------------------------------------------------------
6a6a6630 322c0102 02c10203 68786c01 l jjf02,...á..hxl.
06ba0f l .o.
<16 bytes per line>
6.应用变更
BBED> sum dba 5,168325
Check value for File 5, Block 168325:
current = 0xf89b, required = 0xf089
BBED> sum dba 5,168325 apply
Check value for File 5, Block 168325:
current = 0xf089, required = 0xf089
7.sql模式执行如下命令
SQL> alter system flush buffer_cache;
8.确认修改
SQL> select * from bbed;
ID NAME
---------- --------------------
1 hxl
2 jjf02