oracle expdp dmp 被加密恢复---惜分飞

惜分飞-Tel:17813235971

已于 2022-10-05 15:43:49 修改

阅读量889

点赞数

文章标签： oracle 5g 数据库

于 2020-03-20 22:24:41 首次发布

原文链接：http://www.xifenfei.com/2020/03/expdp-dmp-recovery.html

版权

有朋友oracle数据库dmp备份被加密,后缀为:.DMP.voyager,通过分析发现文件加密2M左右

这里可以看出来dmp文件为expdp方式导出(expdp本质上xml方式存储,exp使用直接二进制方式存储),通过工具分析可恢复表情况.
通过工具对该dmp文件进行分析

CPFL> OPEN F:\BaiduNetdisk\KINGDEE85GH_2020-03-17.DMP.voyager

TABLE_NAME                                         START_POS       DATA_BYTE

-------------------------------------------------- --------------- ---------------

KINGDEE85GH.T_WFD_PROCESSDEF 116300288 648396035

KINGDEE85GH.T_DYN_DYNAMICCONFIGURE 864710656 181453794

KINGDEE85GH.T_RPTS_STORAGEFILEDATA 1078767616 21548951

KINGDEE85GH.T_BOT_RULESEGMENT 1100324864 10372516

KINGDEE85GH.T_LOG_APP                              1110712320      12603573

KINGDEE85GH.T_PM_PERMITEM                          1123336192      7282412

KINGDEE85GH.T_PM_USERORGPERM 1130635264 6692320

KINGDEE85GH.T_DYN_APPSOLUTION 1137336320 801697

KINGDEE85GH.T_PM_MAINMENUITEM 1138155520 3573943

KINGDEE85GH.T_PM_PERMUIGROUP 1141751808 2159245

KINGDEE85GH.T_SYS_ENTITYREF 1143922688 4183869

KINGDEE85GH.T_PM_ROLEPERM                          1148116992      2758960

KINGDEE85GH.T_BAS_SYSMENUITEM 1150885888 3304627

KINGDEE85GH.T_JP_PAGE 1154211840 3019174

…………

KINGDEE85GH.T_XT_CHECKTIME                         1212776448      41

KINGDEE85GH.T_XT_SYNCHTIME                         1212784640      41

SYSTEM.SYS_EXPORT_SCHEMA_02 1212792832 215423380

-------------------------------------------------- --------------- ---------------

Scanned Find 895 segments.

通过这个基本上可以确定丢失了100多M数据，其他数据理论上可以恢复.
创建用户

SQL> create user KINGDEE85GHidentified by oracle;

User created.

SQL> grant dba to KINGDEE85GH;

Grant succeeded.

unexpdp数据(自动创建表和导入数据)

CPFL> unexpdp table KINGDEE85GH.T_WFD_PROCESSDEF

unexpdp table: KINGDEE85GH.T_WFD_PROCESSDEF storage(START_POSITION:116300288 DATA_BYTE:748396035)

824 rows unexpdp

查看恢复结果

如果你有oracle expdp dmp被加密或者破坏,可以参考对其进行处理,参见:
exp dmp文件损坏恢复
 oracle dmp被加密恢复

关注