Re: flashback a physical standby database

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Tue, 21 Jul 2009 21:07:07 +0200
Message-ID: <486b2b610907211207w3d54fb59u499097f0d66d5dfe_at_mail.gmail.com>

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_at_10046.ch

10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland

Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info_at_10046.ch
http://www.10046.ch

---

On Tue, Jul 21, 2009 at 8:38 PM, steve montgomerie <stmontgo_at_gmail.com>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
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 21 2009 - 14:07:07 CDT