how to retrive data after we have commited the update query.

trgk03 · New User Joined: 20 Jan 2006 Posts: 12 Location: kochi

hi everybody,
one of my friend has by mistake updated the production data(a table) through a update query and commited.
the table has no backups.
can anybody suggest any method by which it can be retrieved back to its original state?
thanks in advance.

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

Trk,
In most shops after daily batch jobs when get over would be having a job scheduled for taking Image copy of teh table for backing up the table data.Check that.If its there you can build the table with the latest image copy..Get in touch with DBA for this.

Its always better to take an unload of table when venbturing in to this..

-Han.

Gautam512 · Posted: Wed Jul 19, 2006 3:05 am

hi,

if ur friend has access to update the table, then he might have access to delete that particular data. Check for keys and make ur record a unique one and delete.

ravi17s · New User Joined: 15 Aug 2003 Posts: 57

Its an Call for DBA!
Yes it is possible to recover by applying the LOG.

Please contact your DBA' soon.Sooner u inform them its easier to recover.

Thanks,
Ravi.

neelesht · Posted: Tue Jul 25, 2006 10:12 pm

Image copy is the best option.......In most of the shops it is must and DBA's do that.

Just try it.