BBED> print kcvfhcpc
ub4 kcvfhcpc? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? @140? ? ? 0x00000237
BBED> dump/v dba 1,1 offset 140 count 30
?File: /u01/app/oradata/sydb/system01.dbf (1)
?Block: 1? ? ? Offsets:? 140 to? 169? Dba:0x00400001
-------------------------------------------------------
?37020000 fe522034 36020000 00000000 l 7...6.......
?00000000 00000000 00000000 0000? ? l ...........…
BBED> print kcvfhccc
ub4 kcvfhccc? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? @148? ? ? 0x00000236
BBED> dump/v dba 1,1 offset 148 count 30
?File: /u01/app/oradata/sydb/system01.dbf (1)
?Block: 1? ? ? Offsets:? 148 to? 177? Dba:0x00400001
-------------------------------------------------------
?36020000 00000000 00000000 00000000 l 6...............
?00000000 00000000 00000000 0000? ? l ..............
?
再确认数据文件7信息:
?
BBED> print kcvfhckp
struct kcvfhckp, 36 bytes? ? ? ? ? ? ? ? ? @484? ?
? struct kcvcpscn, 8 bytes? ? ? ? ? ? ? ? @484? ?
? ? ? ub4 kscnbas? ? ? ? ? ? ? ? ? ? ? ? ? @484? ? ? 0x00303f2a
? ? ? ub2 kscnwrp? ? ? ? ? ? ? ? ? ? ? ? ? @488? ? ? 0x0000
? ub4 kcvcptim? ? ? ? ? ? ? ? ? ? ? ? ? ? @492? ? ? 0x34452bad
? ub2 kcvcpthr? ? ? ? ? ? ? ? ? ? ? ? ? ? @496? ? ? 0x0001
BBED> dump/v dba 7,1 offset 484 count 30
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? Offsets:? 484 to? 513? Dba:0x01c00001
-------------------------------------------------------
?2a3f3000 00000000 ad2b4534 01000000 l *?0.........
?a8000000 65000000 10000000 0200? ? l e.........
?<16 bytes per line>
BBED> dump/v dba 7,1 offset 492 count 30
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? Offsets:? 492 to? 521? Dba:0x01c00001
-------------------------------------------------------
?ad2b4534 01000000 a8000000 65000000 l ....e...
?10000000 02000000 00000000 0000? ? l ...........…
BBED> print kcvfhcpc
ub4 kcvfhcpc? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? @140? ? ? 0x00000164
BBED> dump/v dba 7,1 offset 140
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? Offsets:? 140 to? 169? Dba:0x01c00001
-------------------------------------------------------
?64010000 fe522034 63010000 00000000 l d...c.......
?00000000 00000000 00000000 0000? ? l ...........…
BBED> print kcvfhccc
ub4 kcvfhccc? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? @148? ? ? 0x00000163
BBED> dump/v dba 7,1 offset 148
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? Offsets:? 148 to? 177? Dba:0x01c00001
-------------------------------------------------------
?63010000 00000000 00000000 00000000 l c...............
?00000000 00000000 00000000 0000? ? l ..............
?
00303f2a 刚好是v$recover_file 中查询到的CHANGE#值
SQL> select to_number('00303f2a','xxxxxxxxx') from dual;
TO_NUMBER('00303F2A','XXXXXXXXX')
---------------------------------
? ? ? ? ? ? ? ? ? ? ? ? ? 3161898
修改值:
?
BBED> modify /x a943 dba 7,1 offset 484
BBED> set offset +2
? ? ? ? OFFSET? ? ? ? ? 486
BBED> modify /x 3000
BBED> dump /v dba 7,1 offset 484
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? Offsets:? 484 to? 513? Dba:0x01c00001
-------------------------------------------------------
?a9433000 00000000 ad2b4534 01000000 l ........
?a8000000 65000000 10000000 0200? ? l e......…
BBED> modify /x 74314534 dba 7,1 offset 492
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? ? ? ? ? ? Offsets:? 492 to? 521? ? ? ? ? Dba:0x01c00001
------------------------------------------------------------------------
?74314534 01000000 a8000000 65000000 10000000 02000000 00000000 0000
BBED> modify /x 37020000 dba 7,1 offset 140
?File: /disk2/oradata/sydb/tbs03.dbf (7)
?Block: 1? ? ? ? ? ? ? ? Offsets:? 140 to? 169? ? ? ? ? Dba:0x01c000