Re: flashback a physical standby database

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

Ahhh yes -- that's true as well. If you create a guarantee restore point while in MOUNT, oracle will implicitly turn it on for you.

Stefan

---

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 9:27 PM, Bradd Piontek <piontekdd_at_gmail.com> wrote:

> I have no idea why, but I have not had to enable that in my standby's for
> it to work. Maybe it is because you are creating a restore point while in
> MOUNT mode and not OPEN?
> As for the original question (I got over-anxious and didn't read the
> requirements :) ). LogMiner or Flashback Query (assuming the data is still
> in UNDO) would be your likely solutions to finding the issues.
> Bradd Piontek
> "Next to doing a good job yourself,
> the greatest joy is in having someone
> else do a first-class job under your
> direction."
> -- William Feather
>
>
> On Tue, Jul 21, 2009 at 2:22 PM, Martin Brown <martinfbrown_at_hotmail.com>wrote:
>
>> I've been looking at this note and thinking it's a possible solution for
>> some of my testing requirements. But, I have a question... is a very
>> important step missing from this document? What about "alter database
>> flashback on;"? Or is it not required for the standby?
>>
>>
>> ------------------------------
>> From: piontekdd_at_gmail.com
>> Date: Tue, 21 Jul 2009 13:47:44 -0500
>> Subject: Re: flashback a physical standby database
>> To: stmontgo_at_gmail.com
>> CC: oracle-l_at_freelists.org
>>
>>
>> Absolutely. I use this in 10gR2 to allow apps to verify the standby
>> database and do updates,and then flashback the database so i don't have to
>> rebuild the standby. Works awesome. Check out How To Open Physical
>> Standby For Read Write Testing and Flashback (805438.1) on Metalink for
>> detailed steps.
>> *
>> *Bradd Piontek
>> "Next to doing a good job yourself,
>> the greatest joy is in having someone
>> else do a first-class job under your
>> direction."
>> -- William Feather
>>
>>
>> On Tue, Jul 21, 2009 at 1: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
>>
>>
>>
>> ------------------------------
>> NEW mobile Hotmail. Optimized for YOUR phone. Click here.<http://windowslive.com/Mobile?ocid=TXT_TAGLM_WL_CS_MB_new_hotmail_072009>
>>
>
>

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

Received on Tue Jul 21 2009 - 14:33:15 CDT