Re: Timing for Cloning with Flashback Database vs other methods
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: Mark.Bobak@xxxxxxxxxxxx
- Date: Wed, 10 Dec 2008 22:13:13 +0000
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>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 <mark.bobak@xxxxxxxxxxxxxxx>
> www.proquest.com
> 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> 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
Other related posts:
