Re: Standby for testing and Flashback

From: Ravi Gaur <ravigaur1_at_gmail.com>
Date: Thu, 20 Mar 2008 07:14:47 -0500
Message-ID: <289232290803200514l677c0224mf51e3ac60be2ee05@mail.gmail.com>


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_at_gmail.com> 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_at_gmail.com> 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."

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 20 2008 - 07:14:47 CDT

Original text of this message