Re: recover from TRUNCATE TABLE via physical standby?

From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Fri, 24 Aug 2012 10:11:41 +0100
Message-ID: <CAGdek=wY=V8uFrkt=nxU4s12fnfrgf7XJUB439cMfuzo=guqsA_at_mail.gmail.com>

On Thu, Aug 23, 2012 at 10:39 PM, Adric Norris <landstander668_at_gmail.com> 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>
>

Hi

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

regards,

-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com
--
http://www.freelists.org/webpage/oracle-l

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