有朋友oracle数据库dmp备份被加密,后缀为:.DMP.voyager,通过分析发现文件加密2M左右
![](http://www.xifenfei.com/wp-content/uploads/2020/03/20200320134933.jpg)
这里可以看出来dmp文件为expdp方式导出(expdp本质上xml方式存储,exp使用直接二进制方式存储),通过工具分析可恢复表情况.
通过工具对该dmp文件进行分析
[size=0.8em][size=1em][size=1em]CPFL> OPEN F:\BaiduNetdisk\KINGDEE85GH_2020-03-17.DMP.voyager
[size=1em]TABLE_NAME START_POS DATA_BYTE
[size=1em]-------------------------------------------------- --------------- ---------------
[size=1em]KINGDEE85GH.T_WFD_PROCESSDEF 116300288 648396035
[size=1em]KINGDEE85GH.T_DYN_DYNAMICCONFIGURE 864710656 181453794
[size=1em]KINGDEE85GH.T_RPTS_STORAGEFILEDATA 1078767616 21548951
[size=1em]KINGDEE85GH.T_BOT_RULESEGMENT 1100324864 10372516
[size=1em]KINGDEE85GH.T_LOG_APP 1110712320 12603573
[size=1em]KINGDEE85GH.T_PM_PERMITEM 1123336192 7282412
[size=1em]KINGDEE85GH.T_PM_USERORGPERM 1130635264 6692320
[size=1em]KINGDEE85GH.T_DYN_APPSOLUTION 1137336320 801697
[size=1em]KINGDEE85GH.T_PM_MAINMENUITEM 1138155520 3573943
[size=1em]KINGDEE85GH.T_PM_PERMUIGROUP 1141751808 2159245
[size=1em]KINGDEE85GH.T_SYS_ENTITYREF 1143922688 4183869
[size=1em]KINGDEE85GH.T_PM_ROLEPERM 1148116992 2758960
[size=1em]KINGDEE85GH.T_BAS_SYSMENUITEM 1150885888 3304627
[size=1em]KINGDEE85GH.T_JP_PAGE 1154211840 3019174
[size=1em]…………
[size=1em]KINGDEE85GH.T_XT_CHECKTIME 1212776448 41
[size=1em]KINGDEE85GH.T_XT_SYNCHTIME 1212784640 41
[size=1em]SYSTEM.SYS_EXPORT_SCHEMA_02 1212792832 215423380
[size=1em]-------------------------------------------------- --------------- ---------------
[size=1em]Scanned Find 895 segments.
|
通过这个基本上可以确定丢失了100多M数据,其他数据理论上可以恢复.
创建用户 [size=0.8em][size=1em][size=1em]SQL> create user KINGDEE85GHidentified by oracle;
[size=1em]User created.
[size=1em]SQL> grant dba to KINGDEE85GH;
[size=1em]Grant succeeded.
|
unexpdp数据(自动创建表和导入数据) [size=0.8em][size=1em][size=1em]CPFL> unexpdp table KINGDEE85GH.T_WFD_PROCESSDEF
[size=1em]unexpdp table: KINGDEE85GH.T_WFD_PROCESSDEF storage(START_POSITION:116300288 DATA_BYTE:748396035)
[size=1em]824 rows unexpdp
|
查看恢复结果
![](http://www.xifenfei.com/wp-content/uploads/2020/03/20200320142445.jpg)
![](http://www.xifenfei.com/wp-content/uploads/2020/03/20200320142034.jpg)
如果你有oracle expdp dmp被加密或者破坏,无法正常导入数据库,可以联系我们对其进行恢复处理:提供(ORACLE数据库恢复技术支持):
Phone:13429648788 Q Q:107644445 E-Mail:dba@xifenfei.com
如果你的oracle dmp是exp方式导出,也可以联系我们对其进行处理,参见:
exp dmp文件损坏恢复
oracle dmp被加密恢复
|