Re: flashback a physical standby database

  • From: Don Seiler <don@xxxxxxxxx>
  • To: stmontgo@xxxxxxxxx
  • Date: Fri, 21 Aug 2009 06:28:51 -0500

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

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.


On Tue, Jul 21, 2009 at 1:38 PM, steve montgomerie<stmontgo@xxxxxxxxx> 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 ...
> RAC as primary with no rac on single instance physical standby
> OEL 4.5

Don Seiler

Other related posts: