oracle bbed for windows 修改记录

col checkpoint_change# for 99999999999999
col name for a50
select name,checkpoint_change# from v$datafile_header;
NAME CHECKPOINT_CHANGE#
-------------------------------------------------- ------------------
D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF 10737440458
D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF 10737440458
D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF 10737440458
D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF 10737440458

set linesize 1000
select file#||' '||name||' '||bytes from v$datafile;



SQL> select to_char(10737440458,'xxxxxxxxxxxxxxxxxxxxxxxxxxx') from dual;

TO_CHAR(10737440458,'XXXXXXX
----------------------------
2800056ca


--备注: linux 是 set dba 1,1 ,windows 是 set dba 1,2

BBED> d /v dba 1,2 offset 484 count 64
File: D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF (1)
Block: 2 Offsets: 484 to 547 Dba:0x00400002
-------------------------------------------------------
ca560080 02000000 b1d0c743 01000000 l 蔞......毙荂.... --2800056ca 能对上,排序不一样而已
03000000 600c0000 1000d147 02000000 l ....`.....袵....
00000000 00000000 00000000 00000000 l ................
00000000 00000000 00000000 00000000 l ................

<16 bytes per line>




SQL> select to_char(to_number('2ff0056ca','xxxxxxxxxxxxxx'))from dual;

TO_CHAR(TO_NUMBER('2FF0056CA','XXXXXXXXX
----------------------------------------
12868146890
SQL>

把ca560080 修改成ca5600FF

modify /x ca5600ff dba 1,2 offset 484
sum apply





--验证：
SQL> select name,checkpoint_change# from v$datafile_header;

NAME CHECKPOINT_CHANGE#
-------------------------------------------------- ------------------
D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF 12868146890
D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF 10737440458
D:\APP\ADMINISTRATOR\ORADATA\ORCL\UNDOTBS01.DBF 10737440458
D:\APP\ADMINISTRATOR\ORADATA\ORCL\USERS01.DBF 10737440458