RE: Timing for Cloning with Flashback Database vs other methods
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Wed, 10 Dec 2008 17:16:07 -0500
It was a new, home-grown application. It's our first app to go to 11g, and
it's brand new from the ground up. So, One schema, a handful of tables,
procedures, functions, packages, etc. I used the development instance as the
source database to create a preprod database. I just wanted to try the new
feature. After a few bumps in the road, it actually does work as promised,
mostly...
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: Niall Litchfield [mailto:niall.litchfield@xxxxxxxxx]
Sent: Wednesday, December 10, 2008 5:13 PM
To: Bobak, Mark
Cc: bbel5@xxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Timing for Cloning with Flashback Database vs other methods
Mark
I'm guessing you'll know what I mean here. Was this a real database (say a
peoplesoft or ebus clone)? Or a sample db. If it works with a real (sold)
application that'd be fantastic. I'm errrr not convinced.
On Wed, Dec 10, 2008 at 10:00 PM, Bobak, Mark
<Mark.Bobak@xxxxxxxxxxxx<mailto:Mark.Bobak@xxxxxxxxxxxx>> wrote:
Well, I gots ta tell ya, this old timer tried out the really new fangled (11g
only) duplicate database from active database feature of dat dere RMAN!
Quick and easy! (Minimal setup needed. Need an spfile and password file, and
I think that's it.)
Don't know about clonin' from flashback database...never tried that one.....
-Mark
--
Mark J. Bobak
Senior Database Administrator, System & Product Technologies
ProQuest
789 E. Eisenhower, Parkway, P.O. Box 1346
Ann Arbor MI 48106-1346
+1.734.997.4059 or +1.800.521.0600 x 4059
mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx>
www.proquest.com<http://www.proquest.com>
www.csa.com<http://www.csa.com>
ProQuest...Start here.
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On
Behalf Of Jerry Cunningham
Sent: Wednesday, December 10, 2008 4:08 PM
To: bbel5@xxxxxxxxxxxx<mailto:bbel5@xxxxxxxxxxxx>
Cc: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
Subject: Re: Timing for Cloning with Flashback Database vs other methods
Ma'am,
Wha-der they need it so danged fast fer, anyway? Why back in my day, we'd pony
express the tapes and they'd be lucky to get their fancy schmancy duplicate
database before the next full moon. Don' wanna spoil 'em...
- A non-young non-whippersnapper
On Fri, Dec 5, 2008 at 12:42 PM, Bellows, Bambi (Comsys)
<bbel5@xxxxxxxxxxxx<mailto:bbel5@xxxxxxxxxxxx>> wrote:
Hey there Listers!
Cloning sure has more options nowadays than in the golden yesteryear, doesn't
it? There's the simple file copy with the controlfile you backed up from
trace... being the oldtimers' best friend; then there's the newfangled
"duplicate database" , which has the oldtimers smackin their gums talkin about
walkin to school in the snow, 5 miles each way, uphill, without boots. And, as
if that weren't enough, there's this snazzy glittery clone achieved through
flashback database, which has the oldtimers sittin in the dark waitin fer the
young dbas to change the lightbulbs. And fine. But. Which one's fastest? We
oldtimers could parallelize that copy and shove it to background faster than
you could say gollygeewillikers... can RMAN do that? And what of this
snazzydazzy flashback database for cloning? Can it start with a blank slate,
or does it need a database to be created and stuff before it lets tear? And,
really, seriously, what are the timings? One would assume that if the target
database exists and is pretty much kept up to date, anything which just applies
changes is going to be lickety-split faster, but what if it's not?
I'm off to soak my teeth for awhile, but I appreciate any insights you
whippersnappers might have... :)
Bambi.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
