Oracle BBED工具介绍(四)
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 00111555 55000000 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
<32 bytes per line>
修改完了以后,对应位置的数据就改变了,不过这时数据块是损坏状态,试一下。
BBED> verify
DBVERIFY - Verification starting
FILE = /export/home/oradata/orcl/users01.dbf
BLOCK = 17
Block 17 is corrupt
Corrupt block relative dba: 0x01000011 (file 0, block 17)
Fractured block found during verification
Data in bad block:
type: 32 format: 2 rdba: 0x01000011
last change scn: 0x0000.000735ed seq: 0x2 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x7bed2002
check value in block header: 0x7f77
computed block checksum: 0x6700
DBVERIFY - Verification complete
Total Blocks Examined : 1
Total Blocks Processed (Data) : 0
Total Blocks Failing (Data) : 0
Total Blocks Processed (Index): 0
Total Blocks Failing (Index): 0
Total Blocks Empty : 0
Total Blocks Marked Corrupt : 1
Total Blocks Influx : 2
有1个块被标识为损坏,从刚才备份的那个文件覆盖它。
注意:filelist.txt 在file 中我们需要将我们的备份的数据文件也要加进去以后才能使用。
比如:
4 /export/home/oradata/orcl/users01.dbf 5242880
5 /export/home/oradata/orcl/users01.dbf.bak 5242880
BBED> copy file 5 block 17 to file 4 block 17
Warning: contents of previous BIFILE will be lost. Proceed (Y/N) y
File: /export/home/oradata/orcl/users01.dbf (4)
Block: 17 Offsets: 0 to 511 Dba:0x01000011
------------------------------------------------------------------------
00a20000 11000000 00000000 00000105 11a70000 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 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 0000000