联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
在win平台上开发了Oracle Recovery Tools小工具,可以实现坏块的快速恢复功能
具体参考相关文章:自研Oracle恢复小工具
由于之前工具使用c#开发不太方便实现跨平台(而且图形化在linux等操作系统上使用起来不方便),现在使用c语言写了小工具:Patch_blk(主要是seq_kcbh tailchk checksum类似坏块处理),模拟两个坏块
BBED> verify DBVERIFY - Verification starting FILE = /u01/app/oracle/oradata/xifenfei/system01.dbf BLOCK = 521 Block 521 is corrupt Corrupt block relative dba: 0x00400209 (file 0, block 521) Fractured block found during verification Data in bad block: type: 6 format: 2 rdba: 0x00400209 last change scn: 0x0000.000001d7 seq: 0x1 flg: 0x06 spare1: 0x0 spare2: 0x0 spare3: 0x0 consistency value in tail: 0x01d706fe check value in block header: 0x5205 computed block checksum: 0x0 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 Message 531 not found; product=RDBMS; facility=BBED BBED> verify block 522 DBVERIFY - Verification starting FILE = /u01/app/oracle/oradata/xifenfei/system01.dbf BLOCK = 522 Block 522 is corrupt Corrupt block relative dba: 0x0040020a (file 0, block 522) Fractured block found during verification Data in bad block: type: 6 format: 2 rdba: 0x0040020a last change scn: 0x0000.000001d7 seq: 0xff flg: 0x06 spare1: 0x0 spare2: 0x0 spare3: 0x0 consistency value in tail: 0x01d70601 check value in block header: 0x1e16 computed block checksum: 0x0 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 Message 531 not found; product=RDBMS; facility=BBED
配置坏块修复列表文件
[root@iZbp11c0qyuuo1gr7j98upZ tmp]# cat 1.txt /u01/app/oracle/oradata/xifenfei/system01.dbf 521 8192 N /u01/app/oracle/oradata/xifenfei/system01.dbf 522 8192 Y --列表文件说明 数据文件路径 文件号 数据块大小 是否人工干预(N表示不需要,Y表示需要)
执行修复操作
[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ./Patch_blk 1.txt ===== Processing line 1 ===== ===================================================== Processing: File=/u01/app/oracle/oradata/xifenfei/system01.dbf, Block=521, Size=8192, Mode=N ===================================================== === Step 1: Check seq_kcbh === Current value: 0x01 [OK] seq_kcbh is normal === Step 2: Check tailchk === Current (reversed): 0x01D706FE Expected (reversed): 0x01D70601 [Auto-repair] tailchk mismatch, will fix [Backup] Block saved to: ./20251104_230616/system01.dbf_block521 [Success] tailchk fixed [Verify] New tailchk (reversed): 0x01D70601 === Step 3: Check checksum === Current checksum: 0x0552 Computed checksum: 0xFA52 [Auto-repair] Checksum mismatch, will fix [Success] Checksum fixed [Verify] New checksum: 0xFA52 === Step 4: Final Verification === seq_kcbh: 0x01 (not 0xFF: PASS) tailchk: 0x01D70601 (expected 0x01D70601: PASS) Checksum: 0xFA52 (expected 0xFA52: PASS) [Result] Block repair completed successfully ===== Processing line 2 ===== ===================================================== Processing: File=/u01/app/oracle/oradata/xifenfei/system01.dbf, Block=522, Size=8192, Mode=Y ===================================================== === Step 1: Check seq_kcbh === Current value: 0xFF [WARNING] Block is marked as BAD. Repair? (yes/no): y [Backup] Block saved to: ./20251104/system01.dbf_block522 [Success] seq_kcbh updated to 0x01 === Step 2: Check tailchk === Current (reversed): 0x01D70601 Expected (reversed): 0x01D70601 [OK] tailchk is normal === Step 3: Check checksum === Current checksum: 0x161E Computed checksum: 0xE81E [WARNING] Checksum mismatch. Repair? (yes/no): y [Success] Checksum fixed [Verify] New checksum: 0xE81E === Step 4: Final Verification === seq_kcbh: 0x01 (not 0xFF: PASS) tailchk: 0x01D70601 (expected 0x01D70601: PASS) Checksum: 0xE81E (expected 0xE81E: PASS) [Result] Block repair completed successfully ===================================== Processing complete. Total: 2 Modify Success: 2 Modify None: 0 Skipped/Failed: 0 Blocks Backed Up: 2 =====================================
在修复坏块之前会对相关block进行备份
[root@iZbp11c0qyuuo1gr7j98upZ 20251104]# ls -ltra total 24 -rw-r--r-- 1 root root 8192 Nov 4 22:42 system01.dbf_block521 -rw-r--r-- 1 root root 8192 Nov 4 22:42 system01.dbf_block522 drwxr-xr-x 2 root root 4096 Nov 4 22:42 . drwxrwxrwt. 14 root root 4096 Nov 4 23:39 .. [root@iZbp11c0qyuuo1gr7j98upZ 20251104]#
Patch_blk修复坏块之后,检查坏块正常
BBED> verify DBVERIFY - Verification starting FILE = /u01/app/oracle/oradata/xifenfei/system01.dbf BLOCK = 521 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED BBED> verify block 522 DBVERIFY - Verification starting FILE = /u01/app/oracle/oradata/xifenfei/system01.dbf BLOCK = 522 DBVERIFY - Verification complete Total Blocks Examined : 1 Total Blocks Processed (Data) : 1 Total Blocks Failing (Data) : 0 Total Blocks Processed (Index): 0 Total Blocks Failing (Index): 0 Total Blocks Empty : 0 Total Blocks Marked Corrupt : 0 Total Blocks Influx : 0 Message 531 not found; product=RDBMS; facility=BBED
对于不太熟悉bbed的客户,可以通过这个工具快速实现常见坏块类型恢复
