Re: flashback a physical standby database

From: Don Seiler <don_at_seiler.us>
Date: Fri, 21 Aug 2009 06:28:51 -0500
Message-ID: <94e86aed0908210428m159c6874l762cfb2a1d5ae29c_at_mail.gmail.com>

Yes I've done this to use the physical standby as my test for TTS export.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#CIHIABDH

It worked like a champ. Just be sure to drop the restore point when you're done, or Oracle will fill up your FRA with flashback logs.

Don.

On Tue, Jul 21, 2009 at 1:38 PM, steve montgomerie<stmontgo_at_gmail.com> wrote:
> Can I flashback a physical standby?
>
> Scenario is this..
> opps update on table last friday.
> Can't flashback the table ...snaphsot too old
>
> I was thinking that I might be able to open the standby , flashback, get the
> data , flash forward, resume recovery
>
> Or do I do TSPITR with RMAN on auxillary instance.
>
> We are ...
> 10.2.0.4. RAC as primary with no rac on single instance physical standby
> OEL 4.5
>

-- 
Don Seiler
http://seilerwerks.wordpress.com
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Aug 21 2009 - 06:28:51 CDT