Re: Standby for testing and Flashback

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Thu, 20 Mar 2008 09:12:28 +0000 (GMT)
Message-ID: <162923.83092.qm@web27815.mail.ukl.yahoo.com>

Hi

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.

regards
Hrishy

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

---

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

http://uk.promotions.yahoo.com/forgood/

--
http://www.freelists.org/webpage/oracle-l

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