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@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 > -- Don Seiler http://seilerwerks.wordpress.com ultimate: http://www.mufc.us -- //www.freelists.org/webpage/oracle-l