利用BBED恢复数据文件头 - 数据库编程

----------------------- 30cf3e32 a41da532 ec4f1900 00000000 l 0?>2¤.￥2ìO...... d713a532 BBED> m /x 36674632 offset 108 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5) Block: 1 Offsets: 108 to 127 Dba:0x01400001 ------------------------------------------------------------------------ 36674632 a41da532 ec4f1900 00000000 d713a532 ?

sword kcvfhtsn                           @332      4

sys@PROD> select file#,TS# from  v$datafile where file# in(4,5);

     FILE#        TS#
---------- ----------
         4          4
         5          5

BBED> d /v offset 332
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1       Offsets:  332 to  351  Dba:0x01400001
-------------------------------------------------------
 04000000 05005553 45525300 00000000 l ......USERS.....
 00000000                            l ....

 <16 bytes per line>

BBED> m /x 05 offset 332
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1                Offsets:  332 to  351           Dba:0x01400001
------------------------------------------------------------------------
 05000000 05005553 45525300 00000000 00000000

ub4 kcvfhrfn @368 0x00000004

BBED> d /v offset 368
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1       Offsets:  368 to  387  Dba:0x01400001
-------------------------------------------------------
 04000000 00000000 00000000 00000000 l ................
 00000000                            l ....

 <16 bytes per line>

BBED> m /x 05 offset 368
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1                Offsets:  368 to  387           Dba:0x01400001
------------------------------------------------------------------------
 05000000 00000000 00000000 00000000 00000000

BBED> p kcvfhtnm
text kcvfhtnm[0]                            @338     U
text kcvfhtnm[1]                            @339     S
text kcvfhtnm[2]                            @340     E
text kcvfhtnm[3]                            @341     R
text kcvfhtnm[4]                            @342     S
text kcvfhtnm[5]                            @343      
text kcvfhtnm[6]                            @344      
text kcvfhtnm[7]                            @345      
text kcvfhtnm[8]                            @346      
text kcvfhtnm[9]                            @347      
text kcvfhtnm[10]                           @348      
text kcvfhtnm[11]                           @349      
text kcvfhtnm[12]                           @350 

sys@PROD>




 select file#,TS# from  v$datafile where file# in(4,5);

     FILE#        TS#
---------- ----------
         4          4
         5          5

sys@PROD> select TS#,NAME from v$tablespace where ts# in(4,5);

       TS# NAME
---------- --------------------------------------------------
         4 USERS
         5 TP1

BBED> d /v offset 338
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1       Offsets:  338 to  357  Dba:0x01400001
-------------------------------------------------------
 55534552 53000000 00000000 00000000 l USERS...........
 00000000

sys@PROD> select dump('USERS',16) from dual;

DUMP('USERS',16)
----------------------------
Typ=96 Len=5: 55,53,45,52,53


sys@PROD> select dump('TP1',16) from dual;

DUMP('TP1',16)
----------------------
Typ=96 Len=3: 54,50,31

BBED> m /x 54503100 offset 338
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1                Offsets:  338 to  357           Dba:0x01400001
------------------------------------------------------------------------
 54503100 53000000 00000000 00000000 00000000 

 <32 bytes per line>

BBED> m /x 00 offset 342
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1                Offsets:  342 to  361           Dba:0x01400001
------------------------------------------------------------------------
 00000000 00000000 00000000 00000000 00000000 

 <32 bytes per line>

BBED> d /v offset 338
 File: /u01/app/oracle/oradata/PROD/tp01.dbf (5)
 Block: 1       Offsets:  338 to  357  Dba:0x01400001
--------------------------------------------

利用BBED恢复数据文件头(四)