Re: Standby for testing and Flashback
- From: "Ravi Gaur" <ravigaur1@xxxxxxxxx>
- To: "Syed Jaffar Hussain" <sjaffarhussain@xxxxxxxxx>
- Date: Thu, 20 Mar 2008 07:14:47 -0500
Thanks for all the responses. I assume the steps works the same for a RAC
env w/ ASM.
Sorry, I should have mentioned this -- this is a 4-node RAC w/ ASM on Sun
StorageTek. For testing on the standby site, only a single node will be
utilized though.
- Ravi
On Thu, Mar 20, 2008 at 4:43 AM, Syed Jaffar Hussain <
sjaffarhussain@xxxxxxxxx> wrote:
> Ravi,
>
> In 11g, Oracle introduced a new concept of 'Snapshot Standby
> Database/Active Standby' which enables you to open standby in RW mode (for
> testing, development purpose) and easily revert back it to standby mode
> again.
>
> However, in 10g, it is very well possible, In fact, I did discuss this on
> my blog :
>
> http://jaffardba.blogspot.com/2007/12/simulating-11g-snapshot-standby.html
>
> Mr. Alejandro documented the above clearly at this presentation:
>
>
> http://static7.userland.com/oracle/gems/alejandroVargas/MAAQuestionsAndAnswers.pdf
>
> Regards
>
> Jaffar
>
>
>
> On Thu, Mar 20, 2008 at 12:44 AM, Ravi Gaur <ravigaur1@xxxxxxxxx> wrote:
>
> > We have a 10gR2 production database (~1.4TB) that has a physical standby
> > on a remote server. The developers and DA folks want to utilize the standby
> > for configuration testing of some new tools and we're leaning towards the
> > flashback option in 10g.
> > A high level thought is to -
> > 1) Defer the archive log destination on production
> > 2) Setup flashback redo-logs on the production database
> > 3) Open the physical standby for RW
> > 4) Allow the developers to work in it and make changes
> > 5) At the end of the day, use flashback to restore the database back to
> > being a standby. Generate/apply a new standby controlfile, if needed.
> >
> > Anyone thinks this is going to work and has actually done anything
> > similar? I'll really appreciate if anyone can share the steps there.
> >
> > TIA,
> > - Ravi Gaur
> >
>
>
>
> --
> Best Regards,
>
> Syed Jaffar Hussain
> Oracle ACE
> 8i,9i & 10g OCP DBA
> RAC Certified Expert
>
> Official Oracle RAC SIG Representative for Saudi Arabian region (
> http://www.oracleracsig.org/)
> http://jaffardba.blogspot.com/
>
> http://apex.oracle.com/pls/otn/f?p=19297:4:1579866181463918::NO:4:P4_ID:126
>
> ----------------------------------------------------------------------------------
> "Winners don't do different things. They do things differently."
Other related posts:
