由于oracle后续版本对于bbed的支持不是太友好(从10g之后无法直接编译使用,win版本偏移量错误等),基于这些情况,结合当前ai的便利,自己动手写了一个基础版的obet(Oracle Block Editor Tool),用来实现在某些情况下Oracle 数据块的编辑工作.目前(2025年11月7日)发布第一版主要功能有:
1. 通过16进制查看数据文件任何偏移量位置的数据(d/dump)
2. 通过16进制编辑数据文件任何偏移量位置的数据(m/modify)
3. 对oracle 数据块的tailchk自动修复(tailchk apply)
4. 对oracle 数据块的checksum自动修复(sum apply)
5. 数据文件之间部分数据拷贝功能(coopy)
启动软件界面
[root@iZbp11c0qyuuo1gr7j98upZ tmp]# ./obet
=============================================
Welcome to Oracle Block Editor Tool (OBET)
=============================================
***** !!! For Oracle Internal Use only !!! *****
[Software Function Description]
- View and edit data block in hexadecimal format
- Automatically repair tailchk and checksum
- Copy data between different data files
- Mark data block as corrupted block
[Developer Information]
- Name: XiFenFei
- Phone: +86-17813235971
- Email: dba@xifenfei
- Q Q: 107644445
- WeChat: 17813235971
- Website: https://www.xifenfei.com
[Version Details]
- Software Version: v2025.11.001
- Build Date: 2025.11.07
=============================================
Type 'help' for command list | 'exit' to quit
=============================================
==================================================
Software License Status: Authorized
==================================================
使用说明
OBET> help
OBET (Oracle Block Editor Tool) commands:
open <config_file> - Load file list from config file (format: <num> <path>)
info - Show loaded file list (from open command)
set filename <path> - Set target file path (required)
set file <num> - Set filename using loaded file number (from open list)
set blocksize <size> - Set block size (2048,4096,[8192],16384,32768)
set block <num> - Set block number (starts from 0, default: 1)
set offset <offset> - Set offset within block (< blocksize, default: 0)
set count <bytes> - Set number of bytes to read (default: 32)
set mode edit/browse - Enable edit/browse mode
d/dump [options] - Display data (options: block X, offset Y, count N)
m/modify <hex> [opts] - Modify data with hex (opts: block X, offset Y)
undo - Undo last modification
sum [block X] - Calculate checksum for block (default: current block)
sum apply [block X] - Apply checksum: write calculated value to block
tailchk [block X] - Calculate tailchk for block (default: current block)
tailchk apply [block X] - Apply tailchk: write calculated value to block
copy <src> to <dest> - Copy data between files
<src> format: file,block,offset,count (e.g., 1,1,10,64)
<dest> format: file[,block][,offset] (e.g., 3 or 3,1 or 3,1,128)
corrupt [block X] - Mark block as corrupted (default: current block)
show - Display current settings (filename, blocksize, block, offset, count, mode)
license - Show/manage software license (registration code required)
version - Show software version and developer information
help - Show this help message
quit/exit - Exit OBET
加载数据文件
--使用open打开数据文件列表(格式: 编号 路径)
OBET> open /tmp/3.txt
Loaded 4 files from config file '/tmp/3.txt'.
OBET> info
Loaded files (4 total):
----------------------------------------
Number Path
----------------------------------------
1 /u01/xifenfei/system01.dbf
2 /u01/xifenfei/sysaux01.dbf
3 /u01/xifenfei/undotbs01.dbf
4 /u01/xifenfei/users01.dbf
----------------------------------------
OBET> set file 1
filename set to: /u01/xifenfei/system01.dbf (file#1)
--或者直接使用 set filename
OBET> set filename /tmp/system01.dbf
filename set to: /tmp/system01.dbf
进入数据文件特定位置
OBET> set file 2
filename set to: /u01/xifenfei/sysaux01.dbf (file#2)
OBET> set block 5
block set to: 5
OBET> set offset 128
offset set to: 128
16进制方式查看数据
OBET> d
File: /u01/xifenfei/system01.dbf
Block: 1 Offsets: 0 to 31
--------------------------------------------------------------------------------
00002000 0BA20000 01004000 00000000 00000104 224D0000 00000000 0004200B A2DB266A
<32 bytes read>
OBET> dump block 521 offset 128
File: /u01/xifenfei/system01.dbf
Block: 521 Offsets: 128 to 159
--------------------------------------------------------------------------------
00412080 5E068D05 C6040000 00000000 00000000 00000000 00000000 00000000 00000000
<32 bytes read>
OBET> set count 128
count set to: 128
OBET> d
File: /u01/xifenfei/system01.dbf
Block: 1 Offsets: 0 to 127
--------------------------------------------------------------------------------
00002000 0BA20000 01004000 00000000 00000104 224D0000 00000000 0004200B A2DB266A
00002020 58494645 4E464549 AC020000 00720100 00200000 01000300 00000000 00000000
00002040 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00002060 08024000 07000000 00000000 7DC92131 64676345 06200E00 00000000 00000000
<128 bytes read>
16进制方式修改数据块内容(一般修改数据块内容之后建议校验tailchk和sum)
OBET> d
File: /u01/xifenfei/system01.dbf
Block: 1 Offsets: 0 to 127
--------------------------------------------------------------------------------
00002000 0BA20000 01004000 00000000 00000104 224D0000 00000000 0004200B A2DB266A
00002020 58494645 4E464549 AC020000 00720100 00200000 01000300 00000000 00000000
00002040 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00002060 08024000 07000000 00000000 7DC92131 64676345 06200E00 00000000 00000000
<128 bytes read>
OBET> m 0123
Confirm modification:
File: /u01/xifenfei/system01.dbf
Block: 1
Offset: 0 (file offset: 0x00002000)
Original value: 0B
New value: 0123
Confirm? (Y/YES to proceed): y
Verification successful: Data written correctly.
Modified 2 bytes at offset 0x00002000 successfully.
OBET> d
File: /u01/xifenfei/system01.dbf
Block: 1 Offsets: 0 to 127
--------------------------------------------------------------------------------
00002000 01230000 01004000 00000000 00000104 224D0000 00000000 0004200B A2DB266A
00002020 58494645 4E464549 AC020000 00720100 00200000 01000300 00000000 00000000
00002040 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00002060 08024000 07000000 00000000 7DC92131 64676345 06200E00 00000000 00000000
<128 bytes read>
tail和checksum修改
OBET> tailchk
Check tailchk for File /u01/xifenfei/system01.dbf, Block 1:
current = 0x010B0000, required = 0x01010000
OBET> sum
Check value for File /u01/xifenfei/system01.dbf, Block 1:
current = 0x224D, required = 0x28CC
OBET> tailchk apply
Confirm applying tailchk:
File: /u01/xifenfei/system01.dbf
Block: 1
Offset in block: 8188 (file offset: 0x00003FFC)
Original value: 0x010B0000
New value: 0x01010000
Confirm? (Y/YES to proceed): y
Verification successful: Stored tailchk matches calculated value (0x01010000).
Tailchk applied successfully.
OBET> sum apply
Confirm applying checksum:
File: /u01/xifenfei/system01.dbf
Block: 1
Offset in block: 16 (file offset: 0x00002010)
Original value: 0x224D
New value: 0x28C6
Confirm? (Y/YES to proceed): y
Verification successful: Stored checksum matches calculated value (0x28C6).
Checksum applied successfully.
两个数据文件之前拷贝数据(一般copy数据之后建议校验tailchk和sum)
一般情况下文件之间的拷贝就是数据号不一样,比如修改checkpoint,resetlog信息等,这里支持不一样偏移量,不一样数据块的拷贝
OBET> copy 1,1,0,128 to 3,5,128
Confirm copy:
Source: file#1 (/u01/xifenfei/system01.dbf), block 1, offset 0, 128 bytes
Target: file#3 (/u01/xifenfei/undotbs01.dbf), block 5, offset 128
Proceed? (Y/YES to confirm): y
Copy successful: 128 bytes copied from file #1 to file #3.
OBET> set file 3
filename set to: /u01/xifenfei/undotbs01.dbf (file#3)
OBET> d block 5 offset 128
File: /u01/xifenfei/undotbs01.dbf
Block: 5 Offsets: 128 to 255
--------------------------------------------------------------------------------
0000A080 0BA20000 01004000 00000000 00000104 224D0000 00000000 0004200B A2DB266A
0000A0A0 58494645 4E464549 AC020000 00720100 00200000 01000300 00000000 00000000
0000A0C0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
0000A0E0 08024000 07000000 00000000 7DC92131 64676345 06200E00 00000000 00000000
<128 bytes read>
OBET> set file 1
filename set to: /u01/xifenfei/system01.dbf (file#1)
OBET> dump block 1 offset 0
File: /u01/xifenfei/system01.dbf
Block: 1 Offsets: 0 to 127
--------------------------------------------------------------------------------
00002000 0BA20000 01004000 00000000 00000104 224D0000 00000000 0004200B A2DB266A
00002020 58494645 4E464549 AC020000 00720100 00200000 01000300 00000000 00000000
00002040 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
00002060 08024000 07000000 00000000 7DC92131 64676345 06200E00 00000000 00000000
<128 bytes read>
标记数据块为坏块功能
OBET> show
Current settings:
File: /u01/xifenfei/system01.dbf
Blocksize: 8192 bytes
Block: 1
Offset in block: 0 (file offset: 0x00002000)
Count: 128 bytes
Mode: edit
Loaded files: 4 (use 'info' to list)
OBET> corrupt
Confirm modification:
File: /u01/xifenfei/system01.dbf
Block: 1
Offset: 14 (file offset: 0x0000200E)
Original value: 01
New value: FF
Are you sure to set this block corrupted? (Y/YES to proceed): y
Verification successful: Block 1 marked as corrupted (offset 14 set to 0xFF).
Modification successful.
由于该工具直接编辑Oracle 底层数据块操作具有一定的破坏性和风险性,所以在没有授权的情况下无法对数据块进行修改(只能查看),具体授权操作
OBET> license
========================================
Software Registration
========================================
Your Hardware ID: XXXXXXXX ----->提供给我
Please send your Hardware ID to XiFenFei to register.
Website: https://www.xifenfei.com
Tel/WX: +86-17813235971
Enter Registration Code: XXXXXX-XXXXXXXX <-----输入注册码进行授权
Registration successful!
