Re: recover from TRUNCATE TABLE via physical standby?

From: Adric Norris <landstander668_at_gmail.com>
Date: Thu, 23 Aug 2012 17:30:09 -0500
Message-ID: <CAJueESrmmDqtony2SDdU1M_yKsDi+7emwLGdRtpiai-DudcjUg_at_mail.gmail.com>



I'll look into that option, but doesn't Flashback Data Archive have to be explicitly enabled for each relevant table? If so, that could be a problem if the number of potential candidate isn't well known up front. On Thu, Aug 23, 2012 at 4:52 PM, Kevin Jernigan <kevin.jernigan_at_oracle.com>wrote:

> You could enable Flashback Data Archive (Total Recall) on the table, then
> use Flashback Query to select from the table AS OF a timestamp right before
> the TRUNCATE. This would be much easier to implement, with no need to muck
> around with disconnecting the standby db etc...KJ
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 23 2012 - 17:30:09 CDT

Original text of this message