Re: URGENT: Please help with an recovery option...

In article <6s1lj4$bil_at_chronicle.concentric.net>, Nnoor_at_cris.com says...
>
>
>I am still kicking myself... I ran an update query on a table
>which also modified some data which it wasn't supposed to (failed
>to include an option in the where clause). Is there any way to
>get teh data to the way it was? Any type of roll back? Anything?

If you are running to DB in archivelog mode, then you can restore the whole DB to a point in time prior to the update. If this is impossible or impractical, a neat tool I use is DB*Trax which analyses the redo log files and can build undo operations even for comitted data. Again, if the change was made a while ago, the DB needs to have been running in archivelog mode as the commits will probably have been archived by now.

Finally, if all else fails, restore a backup of the DB onto a different machine (or just the bit you require if short of space - there is an Oracle white paper on how to do a partial 'full' restore, it is a bit fiddly), take some exports of the old versions of the tables, and then muck around with these copies and your current versions until they are in synch again.

Cheers
Martin

-- 
Martin Rapier, Database Administrator
Corporate Information & Computing Services.
University of Sheffield Tel 0114 222 1137
The opinions expressed here may be those of my employer, or they may not.
http://rhino.shef.ac.uk:3001/mr-home/