联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
通过一段时间的测试和使用,obet修复了不少bug,关于obet的以往功能和特性的文章:
Oracle数据块编辑工具( Oracle Block Editor Tool)-obet
obet(Oracle Block Editor Tool)第二版发布
并且也在客户的生产环境上进行了实战:obet快速修改scn/resetlogs恢复数据库(缺少归档,ORA-00308）.利用周末的时间又对obet的工具进行了功能增强,增加了dbv(数据块校验)功能.
Oracle dbv的不足
1. oracle dbv需要在安装oracle服务端的环境下才能执行
2. oracle dbv对于文件大小不正确(文件头记录block数和实际文件大小不匹配),文件头损坏等情况都可能导致dbv无法执行,类似下面的报错
C:UsersXFF>dbv file=H:BaiduNetdiskkingdeesystem01.dbf DBVERIFY: Release 11.2.0.4.0 - Production on 星期日 1月 11 17:30:29 2026 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. DBV-00107: 未知标头格式 (0) (2054913149) C:UsersXFF>
C:UsersXFF>dbv file=H:BaiduNetdiskkingdeeusers01.dbf DBVERIFY: Release 11.2.0.4.0 - Production on 星期日 1月 11 20:10:05 2026 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. DBV-00102: FILE (H:BAIDUNETDISKKINGDEEUSERS01.DBF) 在 end read 操作 (-1) 期间出现文件 I/O 错误 C:UsersXFF>
3. oracle dbv一条命令执行检测一个数据文件,如果数据文件多,检查起来很繁琐
4. oracle dbv么有检查进度,对于io性能较慢,数据文件较大的情况,无法跟踪检查进度.
obet的dbv功能使用
1. 配置listfile.txt文件,格式为file# name
1 H:BaiduNetdiskkingdeesystem01.dbf 5 H:BaiduNetdiskkingdeeEAS_D_EAS_STANDARD.ORA
2. 启动obet,执行open listfile.txt(如果不在obet目录提供完整路径)
OBET> open listfile.txt
Loaded 2 files from config file 'listfile.txt'.
OBET> info
Loaded files (2 total):
----------------------------------------
Number Path
----------------------------------------
1 H:BaiduNetdiskkingdeesystem01.dbf
5 H:BaiduNetdiskkingdeeEAS_D_EAS_STANDARD.ORA
----------------------------------------
3. 执行dbv命令(logfile
OBET> dbv =============================================== DBV (Data Block Verification) Block Size: 8192 bytes =============================================== Verifying file #1: H:BaiduNetdiskkingdeesystem01.dbf (131841 blocks) - Started: 2026-01-11 18:03:58 file 1, block 0: checksum error (expected 0xC4DA, got 0xC478), bad block file 1, block 1: checksum error (expected 0xF835, got 0xB835), bad block Progress: 10000 / 131841 blocks checked... Progress: 20000 / 131841 blocks checked... ………………. Progress: 120000 / 131841 blocks checked... Progress: 130000 / 131841 blocks checked... File #1 completed: 0 all zero, 0 soft corrupted, 0 tailchk error, 2 checksum error, 0 rdba error Verifying file #5: H:BaiduNetdiskkingdeeEAS_D_EAS_STANDARD.ORA (4194303 blocks) - Started: 2026-01-11 18:04:08 Progress: 10000 / 4194303 blocks checked... Progress: 20000 / 4194303 blocks checked... …………………… Progress: 260000 / 4194303 blocks checked... Progress: 270000 / 4194303 blocks checked... file 5, block 277678: tailchk error (expected 0x0228BB21, got 0x0228AD21), bad block file 5, block 277679: rdba error (expected 277679, got 277615), bad block file 5, block 277680: rdba error (expected 277680, got 277616), bad block file 5, block 277681: rdba error (expected 277681, got 277617), bad block ……………… file 5, block 277692: rdba error (expected 277692, got 277628), bad block file 5, block 277693: rdba error (expected 277693, got 277629), bad block file 5, block 277694: rdba error (expected 277694, got 277630), bad block file 5, block 279406: tailchk error (expected 0x02281E22, got 0x00000700), bad block file 5, block 279407: rdba error (expected 279407, got 448), bad block file 5, block 279408: rdba error (expected 279408, got 0), bad block ……………… Progress: 280000 / 4194303 blocks checked... Progress: 290000 / 4194303 blocks checked... Progress: 300000 / 4194303 blocks checked... Progress: 310000 / 4194303 blocks checked... file 5, block 312932: tailchk error (expected 0x0106C0B8, got 0x010629B8), bad block file 5, block 312933: rdba error (expected 312933, got 312869), bad block file 5, block 312934: rdba error (expected 312934, got 312870), bad block file 5, block 312935: rdba error (expected 312935, got 312871), bad block file 5, block 312936: rdba error (expected 312936, got 312872), bad block file 5, block 312937: rdba error (expected 312937, got 312873), bad block file 5, block 312938: rdba error (expected 312938, got 312874), bad block file 5, block 312939: rdba error (expected 312939, got 312875), bad block ……………… Progress: 4180000 / 4194303 blocks checked... Progress: 4190000 / 4194303 blocks checked... File #5 completed: 1 all zero, 0 soft corrupted, 13 tailchk error, 1 checksum error, 255 rdba error DBV completed at: 2026-01-11 18:09:30 =============================================== DBV Summary: Total blocks checked: 4325872 Total all zero blocks found: 1 Total all rdba error blocks found: 255 Total all tailchk error blocks found: 13 Total all soft corrupted blocks found: 0 Total all checksum error blocks found: 3 Total bad blocks found: 272 =============================================== Detailed report saved to: dbv_20260111180358.log OBET>
检测效果截图
