Re: Standby for testing and Flashback
Date: Thu, 20 Mar 2008 09:12:28 +0000 (GMT)
We have used this in 10.2.3 and it works.
We use gurantee restore points no need to recreate the
We use it for reporting though.
- 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
> 3) Open the physical standby for RW
> 4) Allow the developers to work in it and make
> 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
> - Ravi Gaur
Rise to the challenge for Sport Relief with Yahoo! For Good Received on Thu Mar 20 2008 - 04:12:28 CDT