Re: recover from TRUNCATE TABLE via physical standby?
From: Adric Norris <landstander668_at_gmail.com>
Date: Thu, 23 Aug 2012 17:31:07 -0500
Message-ID: <CAJueESqnZ9PsvEVmYkFBF9tnfsZuZfJnGD6rsF-gJkx5ncoGyw_at_mail.gmail.com>
I don't think it's quite so simple in this context. The FLASHBACK DATABASE command is (effectively) performing a restore/recover operation to a specific SCN, which can certainly be a point before the truncate occurred (like any point-in-time recovery).
On Thu, Aug 23, 2012 at 4:58 PM, <james.clarence.allen_at_census.gov> wrote:
Date: Thu, 23 Aug 2012 17:31:07 -0500
Message-ID: <CAJueESqnZ9PsvEVmYkFBF9tnfsZuZfJnGD6rsF-gJkx5ncoGyw_at_mail.gmail.com>
I don't think it's quite so simple in this context. The FLASHBACK DATABASE command is (effectively) performing a restore/recover operation to a specific SCN, which can certainly be a point before the truncate occurred (like any point-in-time recovery).
On Thu, Aug 23, 2012 at 4:58 PM, <james.clarence.allen_at_census.gov> wrote:
> Sorry. When you truncate a table the data I'd deleted and nothing gets
> logged.
> You truncate and it,s gone!
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 23 2012 - 17:31:07 CDT