Re: recover from TRUNCATE TABLE via physical standby?

From: Marcin Przepiorowski <>
Date: Fri, 24 Aug 2012 10:11:41 +0100
Message-ID: <>

On Thu, Aug 23, 2012 at 10:39 PM, Adric Norris <> wrote:
> Here's the basic procedure which *seems* plausible, assuming that my
> understanding of the various pieces is correct, performed on the standby
> side:
> - Stop the Dataguard APPLY processes
> - Restart the standby database in MOUNT mode, and note the current SCN
> - Flashback to a point (shortly) before the TRUNCATE TABLE statement
> - Open the database read-only, and extract the desired data
> - Restart the standby database in MOUNT mode
> - Flashback/recover the standby database back to the original SCN
> - Restart the Dataguard APPLY process
> Anyone care to comment on whether or not the above is actually viable? I'm
> planning to perform all necessary testing/validation, but would like to
> ensure that I'm at least nominally sane before kicking off that kind of
> effort. <g>


Looks OK for me - I would rather create guarantee recovery point instead of noting current SCN.


Marcin Przepiorowski
Received on Fri Aug 24 2012 - 04:11:41 CDT

Original text of this message