Kbase P11114: Can I undo a delete after the transaction has been committed
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Can I undo a DELETE after the transaction has been committed.
GOAL:
Can I recover data after it's been deleted from the database.
FIX:
Not directly.
When a record is deleted, its content is replaced in the database block with a placeholder. Therefore, once the DELETE has been committed there is no trace whatsoever left of how the record looked like before it was deleted.
The only option, in case after imaging is enabled, is to go back to backup and to roll forward your ai extents with:
rfutil <dbname> -C roll forward endtime <yyyy:mm:dd:hh:mm:ss> -a <ainame>
The time specified after the 'endtime' option should be some time before the record was deleted.
Of course, this way all the work done on the database after that point in time is lost.