Yeah sure -- it's basically the manual process of doing what oracle's "snapshot standby" feature does in 11g. Been using it many times. Cheers ========================= Stefan P Knecht CEO & Founder s@xxxxxxxx 10046 Consulting GmbH Schwarzackerstrasse 29 CH-8304 Wallisellen Switzerland Phone +41-(0)8400-10046 Cell +41 (0) 79 571 36 27 info@xxxxxxxx http://www.10046.ch ========================= On Tue, Jul 21, 2009 at 8: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 ... > 10.2.0.4. RAC as primary with no rac on single instance physical standby > OEL 4.5 >