flashback a physical standby database

  • From: steve montgomerie <stmontgo@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 21 Jul 2009 14:38:02 -0400

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

Other related posts: