Re: flashback a physical standby database
From: Bradd Piontek <piontekdd_at_gmail.com>
Date: Tue, 21 Jul 2009 13:47:44 -0500
Message-ID: <e9569ef30907211147p152ecc80ufef6162e8cdf6390_at_mail.gmail.com>
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,
Date: Tue, 21 Jul 2009 13:47:44 -0500
Message-ID: <e9569ef30907211147p152ecc80ufef6162e8cdf6390_at_mail.gmail.com>
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
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 21 2009 - 13:47:44 CDT