accidentally deleted data needs to be recovered

Database
Fan

accidentally deleted data needs to be recovered

Hi

We have deleted some rows in table accidentally and we don’t maintain PJ in our system.

I can restore from a last backup available, but I can’t get the live data which was inserted just before couple of minutes.

How to recover it. please advice.

 

2 REPLIES
Senior Apprentice

Re: accidentally deleted data needs to be recovered

Hi,

 

You may not be able to do so using Teradata features.

 

IF the transaction that deleted the data is still active then cancelling that transaction (and thereby causing a rollback) will add the rows back in.

 

IF the insert statements were logged in DBQL (query log) WITH the sql and/or paraminfo then you might be able to reconstruct the inserts.

 

Other than that, with no PJ and a backup that isn't current enough, you'll have to get the insert statements and/or data from the application side. IF that is available then you may be able to use that to reconstruct the inserts.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com
Teradata Employee

Re: accidentally deleted data needs to be recovered

If there is a load date/timestamp/loadid in the records, and the records loaded since the deletion ca be identified, then those records can be extracted to a separate table, the damaged table can be restored from backup and then the new records can be reapplied from the extracted table.