p01.dbf (5)
Block: 1 Offsets: 44 to 63 Dba:0x01400001
------------------------------------------------------------------------
00fa0000 00200000 04000300 00000000 00000000
(3)修改文件号（4--->5）
ub2 kccfhfno @52 0x0004
BBED> d /v offset 52
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 52 to 71 Dba:0x01400001
-------------------------------------------------------
04000300 00000000 00000000 00000000 l ................
00000000
BBED> m /x 05 offset 52
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 52 to 71 Dba:0x01400001
------------------------------------------------------------------------
05000300 00000000 00000000 00000000 00000000 ?
(4)修改文件创建时SCN
BBED> p kcvfhcrs
struct kcvfhcrs, 8 bytes @100
ub4 kscnbas @100 0x00004b14
ub2 kscnwrp @104 0x0000
sys@PROD> select file#,CREATION_CHANGE# from v$datafile where file#=5;
FILE# CREATION_CHANGE#
---------- ----------------
5 363921
sys@PROD> select to_char('363921','xxxxxxxxxxxxx') from dual;
TO_CHAR('36392
--------------
58d91 ===（倒：918d0500）==》00058d91
BBED> d /v offset 100
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 100 to 119 Dba:0x01400001
-------------------------------------------------------
144b0000 00000000 30cf3e32 a41da532 l .K......0?>2¤.￥2
ec4f1900
BBED> m /x 918d offset 100
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 100 to 119 Dba:0x01400001
------------------------------------------------------------------------
918d0000 00000000 30cf3e32 a41da532 ec4f1900
BBED> m /x 0500 offset 102
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 102 to 121 Dba:0x01400001
------------------------------------------------------------------------
05000000 000030cf 3e32a41d a532ec4f 19000000
BBED> d /v offset 100
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 100 to 119 Dba:0x01400001
-------------------------------------------------------
918d0500 00000000 30cf3e32 a41da532 l ........0?>2¤.￥2
ec4f1900
(5)修改文件创建时间
ub4 kcvfhcrt @108 0x323ecf30
BBED> p kcvfhcrt
ub4 kcvfhcrt @108 0x323ecf30
sys@PROD> select file#,to_char(CREATION_TIME,'yyyy-mm-dd hh24:mi:ss') createTime,
2 (to_char(CREATION_TIME,'yyyy')-1988)*12*31*24*3600+
3 (to_char(CREATION_TIME,'mm')-1)*31*24*3600+
4 (to_char(CREATION_TIME,'dd')-1)*24*3600+
5 to_char(CREATION_TIME,'hh24')*3600+
6 to_char(CREATION_TIME,'mi')*60+
7 to_char(CREATION_TIME,'ss') createTimeSCN
8 from v$datafile WHERE file# in(4,5);
FILE# CREATETIME CREATETIMESCN
---------- ------------------- -------------
4 2014-03-23 16:17:52 842977072
5 2014-03-29 10:32:22 843474742
sys@PROD> select '4' file#, to_char('842977072','xxxxxxxxxxxxxx') from dual;
F TO_CHAR('842977
- ---------------
4 323ecf30 ===>倒：30cf3e32
sys@PROD> select '5' file#,to_char('843474742','xxxxxxxxxxxxxx') from dual;
sys@PROD> select '5' file#,to_char('843474742','xxxxxxxxxxxxxx') from dual;
F TO_CHAR('843474
- ---------------
5 32466736 ==》36674632
BBED> d /v offset 108
File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
Block: 1 Offsets: 108 to 127 Dba:0x01400001
--------------------------------