你在这里

You are here:

首页

博客

PDSERVICE的博客

Recovery deleted Oracle table my mistake without backup / flashback

Posted by PDSERVICE on 10月 15, 2020 In

The case is:

In the images table, and by mistake, a user has deleted all records from this table and committed the delete command. There is no back up to restore the data.

The DB is Oracle 18C, in RAC configuration, and the storage is on ASM on an external storage. This is the all the data that I have now.

	  we can recover BLOB/CLOB by scanning the datafile . You can try it with our software : non-dictionary (ASM) => scan all datafile find => you will get the lob.

	  software download: https://zcdn.parnassusdata.com/DUL5108rc16_java.zip

	  you can also reference video : https://www.youtube.com/watch?v=3OT1OsAfOM0

	  the software can directly read datafile on asm , but you can also copy it . you'd better stop the oracle instance first , otherwise it may overwrite the space stored blob/clob data. 