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>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 <mark.bobak_at_il.proquest.com>
> www.proquest.com
> www.csa.com
>
> *ProQuest...*Start here.
>
>
>
> *From:* 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
> *Cc:* 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> 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… J
>
> Bambi.
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l