RE: Timing for Cloning with Flashback Database vs other methods

From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Date: Wed, 10 Dec 2008 17:16:07 -0500
Message-ID: <6AFC12B9BFCDEA45B7274C534738067F090474E8@AAPQMAILBX02V.proque.st>


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_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: Niall Litchfield [mailto:niall.litchfield_at_gmail.com] Sent: Wednesday, December 10, 2008 5:13 PM To: Bobak, Mark
Cc: bbel5_at_allstate.com; oracle-l_at_freelists.org 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_at_proquest.com<mailto:Mark.Bobak_at_proquest.com>> 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_at_proquest.com<mailto:mark.bobak_at_il.proquest.com> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com>

ProQuest...Start here.

From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>] On Behalf Of Jerry Cunningham Sent: Wednesday, December 10, 2008 4:08 PM To: bbel5_at_allstate.com<mailto:bbel5_at_allstate.com> Cc: oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>

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_at_allstate.com<mailto:bbel5_at_allstate.com>> 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

--

http://www.freelists.org/webpage/oracle-l Received on Wed Dec 10 2008 - 16:16:07 CST

Original text of this message