Re: Standby for testing and Flashback

From: hrishy <>
Date: Thu, 20 Mar 2008 09:12:28 +0000 (GMT)
Message-ID: <>


We have used this in 10.2.3 and it works. We use gurantee restore points no need to recreate the controlfile.
We use it for reporting though.


  • Ravi Gaur <> 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

Rise to the challenge for Sport Relief with Yahoo! For Good

Received on Thu Mar 20 2008 - 04:12:28 CDT

Original text of this message