Re: How to recover previous rows after update
Date: Mon, 5 Dec 2011 08:59:10 -0800 (PST)
Message-ID: <2182dc82-8f82-41a9-88a3-484c0f89bb05_at_g21g2000yqc.googlegroups.com>
On Dec 2, 9:37 pm, Anupam Kumar <haker.z..._at_gmail.com> wrote:
> Hi,
> One user has accidentally upadated and commited the transaction. Now
> my job is to restore the previous data for that table. Is there any
> way to do it. Its already been 24 hr past when It happen.. I'm not
> sure wether I can use Flashback or not.
>
> Pease help.
>
> Thanks in advance,
> Anupam
Besides all the new features and trick stuff like PITR, logical backups are very useful for this type of thing (viz., user error). I personally have found daily exports to be quite useful, especially being redundant with proper backups.
PITR means Point In Time Recovery, and there are examples in the docs, on MOS and on the web. In general, you restore the database (or tablespace if it contains all the relevant data) on to another database, stopping before the problematic transaction took place. Then, either update from the proper table or do a table level destructive export/import.
It does help to post the exact Oracle version/patch level and the same for the OS and platform, database options and edition, as well as any space limitations you have.
jg
-- _at_home.com is bogus. Dang, I would've bought one of the originals if they had just been selling them when I bought a car: http://www.signonsandiego.com/news/2011/dec/02/carmaker-closes-without-green-energy-aid/Received on Mon Dec 05 2011 - 10:59:10 CST