flashback a physical standby database

From: steve montgomerie <stmontgo_at_gmail.com>
Date: Tue, 21 Jul 2009 14:38:02 -0400
Message-ID: <5d4504220907211138v2f3a5361mf8851f336b1c92a7_at_mail.gmail.com>



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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 21 2009 - 13:38:02 CDT

Original text of this message