Re: How to recover previous rows after update
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 3 Dec 2011 05:59:34 +0000 (UTC)
Message-ID: <pan.2011.12.03.05.59.34_at_gmail.com>
On Fri, 02 Dec 2011 21:37:15 -0800, Anupam Kumar wrote:
Date: Sat, 3 Dec 2011 05:59:34 +0000 (UTC)
Message-ID: <pan.2011.12.03.05.59.34_at_gmail.com>
On Fri, 02 Dec 2011 21:37:15 -0800, Anupam Kumar 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
- What is the version of the database?
- Is the flashback on? What is the retention target, if the flashback is on? The default flashback retention is 24 hours. Even if the flashback is on, if the retention target is not set to more than 24 hours, you will not be able to get the data back. Skip this question if the answer to the first question starts with number 9.
- Is there a chance that the data may still reside in UNDO segments? AS OF TIME queries query UNDO segments. If the data is there, it can be restored. If the database is active, chances are very slim.
- Do you have a backup? Are you sure?
- Is your resume up to date? This maybe the right time to update your resume. You should leave this episode out of your resume.
-- http://mgogala.byethost5.comReceived on Fri Dec 02 2011 - 23:59:34 CST