Email: service@parnassusdata.com 7 x 24 online support!
Recovery deleted Oracle table my mistake without backup / flashback
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.
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.