RE: Timing for Cloning with Flashback Database vs other methods
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxx>
- To: "jerry59grp@xxxxxxxxx" <jerry59grp@xxxxxxxxx>, "bbel5@xxxxxxxxxxxx" <bbel5@xxxxxxxxxxxx>
- Date: Wed, 10 Dec 2008 17:00:35 -0500
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] On
Behalf Of Jerry Cunningham
Sent: Wednesday, December 10, 2008 4:08 PM
To: bbel5@xxxxxxxxxxxx
Cc: 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.
Other related posts:
