咨询微信： dbservice1234 7 x 24 在线支持！

首页

下载 DBRECOVER

oracle Data recovery Issue

oracle Data recovery Issue

Posted by PDSERVICE on 10月 24, 2018 In
===SUMMARY OF THE ISSUE====
 
 
 
1. We lost data from few partitions and need  to restore and recover the data
 
 .The table is a Range partition and nearly we have lost 9 partitions.Each partition size is nearly 350GB( 9 partiions *350G=3TB)
 
2. The only backup available is from Jan 25 2015. This backup does not include SYSTEM tablespace backups.
 
3. We built a new environment and first restored datafiles from Jan 2015 backups.
 
4. Then used the most recent backup(Oct 2016) to restore SYSTEM tablespace to the new environment.Facing issues to open the database.
 
5. Data is available in the backup datafiles.Need to recover the data from datafiles.
 
 
 
I have gone through the  oracle PRM-DUL document and could not see any case study to recover the LOB data from the partitions,which were truncated.
We have to recover the data from few partitions(Lost 9 partitions) from Range partitioned table. 
Partitions contains the data "FILE_BLOB" BLOB, "FILE_XML" CLOB. Could you please provide the document which will explains to recover the LOB  data   from the partitioned table.
 
 prm can recover blob/clob from dropped partition in non-dictionary mode; first you use recovery wizard with non-dictionary mode , and scan the whole database /tablespace , and then you get your dropped partition listed by data object id ; select the dropped partition object in object tree, specify every column with right data type, and then you can use data bridge to recover your data. 
 
 pls let me know if you still have problem, actually this procedure is similar to recover from dropped table, but you have to specify  every column's data type, especially the lob column .