Re: Timing for Cloning with Flashback Database vs other methods
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: bbel5@xxxxxxxxxxxx
- Date: Fri, 5 Dec 2008 20:53:31 +0000
That sounds like
1) setup standby - physical
2) open standby read-write at time x
3) do stuff
4) flashback to before x
5) resume standby
all very clever, and indeed briefly mentioned in the age-inducing
presentation John refers to. I've never actually done it, because it seems
far too likely to go horribly wrong.
Niall
On Fri, Dec 5, 2008 at 8:44 PM, Bellows, Bambi (Comsys)
<bbel5@xxxxxxxxxxxx>wrote:
> John --
>
> Thanks for the email back. Duplicate database seemed to me to be the way
> to go… but, evidently, there's a nifty new feature called flashback
> database, which, when combined with RMAN and DataGuard, clones a database.
> The folks here seem pretty excited about the prospects… and if it just
> applies changes since the last clone, it would speed things up (for
> subsequent clones, of course), but I wanted to make sure that it would be as
> fast as it sounds, so I came to the List, home of all the experts one could
> ever wish for… ;)
>
>
>
> Thanks again for your response…
>
> Bambi.
>
>
>
>
>
> ------------------------------
>
> *From:* John Hallas [mailto:John.Hallas@xxxxxxxxxxxxxxxxxx]
> *Sent:* Friday, December 05, 2008 2:25 PM
> *To:* Bellows, Bambi (Comsys); oracle-l@xxxxxxxxxxxxx
> *Subject:* RE: Timing for Cloning with Flashback Database vs other methods
>
>
>
> I wish I felt like a young whippersnapper. Niall did a presentation at
> UKPUG this week that made me feel very old and my younger colleague was
> nudging me constantly with a smirk on his face.
>
>
>
> What do you mean by cloning a database by flashback Bambi? I am not sure
> that option exists, even in 11g. You can flashback a database to a point in
> time using recover points but actually cloning a database is new to me.
>
>
>
> We are currently experimenting with doing an EM database clone (which uses
> RMAN behind the scenes anyway). Some success but if a few iffies with a
> Peoplesoft database still to resolve. Duplicate database is the way to go
> though. As Niall says, it can be speeded up and is pretty simple, especially
> if you can get it all scripted (and maybe use OMF files).
>
>
>
> John
>
>
> ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Bellows, Bambi (Comsys)
> *Sent:* 05 December 2008 17:43
> *To:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Timing for Cloning with Flashback Database vs other methods
>
>
> ______________________________________________________________________
> Wm Morrison Supermarkets Plc is registered in England with number 358949.
> The registered office of the company is situated at Gain Lane, Bradford,
> West Yorkshire BD3 7DL. This email and any attachments are intended for the
> addressee(s) only and may be confidential.
>
> If you are not the intended recipient, please inform the sender by replying
> to the email that you have received in error and then destroy the email.
> If you are not the intended recipient, you must not use, disclose, copy or
> rely on the email or its attachments in any way.
>
> Wm Morrison Supermarkets PLC accepts no liability or responsibility for
> anything said in the email or its attachments and gives no warranty as to
> accuracy. It is the policy of Wm Morrison Supermarkets PLC not to enter into
> any contractual or other obligations by email.
>
> Although we have taken steps to ensure the email and its attachments are
> virus-free, we cannot guarantee this or accept any responsibility,
> and it is the responsibility of recipients to carry out their own virus
> checks.
> ______________________________________________________________________
>
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
