Re: Flashback, Restore Points and Standby databases

You can achieve by putting the restore points and convert your standby to  shapshot standby. You can go through the below blogs will help.

http://shivanandarao-oracle.com/2013/02/04/snapshot-standby-database-convert-physical-standby-database-to-snapshot-standby-database-read-write-mode-and-viceversa/

http://www.pafumi.net/Standby_Snapshot_DB.html

Hope this helps

Regards
Venkat

On 6 November 2014 19:52, Lyall Barbour <lyallbarbour_at_sanfranmail.com> wrote:

> Hello everyone,
> Oracle 11.2.0.4, RHEL 5.10, Primary database and two Standby databases,
> one physical, the second Logical.
>
> This weekend, my company will be doing a massive conversion of an
> Application system from a company that we bought, into our main App.
> Before this happens, the App Team wants a backup of the Production
> database. I'll be doing an RMAN level 0, but i'm also blowing up our
> Flashback area so that i can set some restore points along the way this
> weekend. I'm trying to figure out how, in the case of a major issue, if we
> Flashed back to a certain Point, what happens to the Logical Standby? Does
> any know? Will it be Flashback too? Do i have to set a Restore Point on
> it, in line with the Restore on Primary? Is there no way that they'll stay
> in sync after a restore? Do i just have to rebuild it?
>
> Thanks,
> Lyall Barbour
> -- http://www.freelists.org/webpage/oracle-l

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