Re: Flashback, Restore Points and Standby databases
- From: Venkat srinivasan <srini.venkat.raman@xxxxxxxxx>
- To: lyallbarbour@xxxxxxxxxxxxxxx
- Date: Fri, 7 Nov 2014 11:27:19 +0530
Hi Lyall,
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@xxxxxxxxxxxxxxx>
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
> -- //www.freelists.org/webpage/oracle-l
Other related posts:
