RE: Timing for Cloning with Flashback Database vs other methods
- From: "Bellows, Bambi \(Comsys\)" <bbel5@xxxxxxxxxxxx>
- To: "John Hallas" <John.Hallas@xxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Dec 2008 14:44:54 -0600
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.
______________________________________________________________________
Other related posts:
