Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Methods to clone large production database

RE: Methods to clone large production database

From: Fadi Hasweh <>
Date: Tue, 27 Mar 2007 09:46:29 +0200
Message-ID: <5D3BF5596805DF448AE69C2D6277FE79071344@HQ-UM-EXCH.UMNIAH.COM>

Dear lara,

I have a production database the I clone every 3 months its around 380G

i do follow note 135651.1 number to do that and it works every time but in your case the copy will take more time and applying the archives will take time too.    


[] On Behalf Of Dennis Williams Sent: Tuesday, March 27, 2007 2:04 AM
Cc:; Subject: Re: Methods to clone large production database  


Perhaps you can give us a better idea of what you're trying to accomplish and your restrictions. You've stated that you can't have a production downtime. What are the other restrictions? Using your database backup is a method I always favor because if that doesn't work adequately, what is the point. I'm surprised RMAN duplicate doesn't offer the performance you need. It meets your criteria of no downtime. You might also try to determine where the bottleneck lies. Possibly your network? You could try a hot backup, but I doubt that would be any faster than RMAN. And yep, too bad BCV's aren't available.  

Dennis Williams

"This email is intended for the above named addressee (s) only and may contain confidential and/or privilege information and should not be used by anyone who is not the original intended recipient(s). Any review, print, copy, reliance or distribution by others or forwarding without express permission is strictly prohibited If you have received this email in error, kindly notify the sender immediately by reply email and delete this email and any attachments from your mailbox or any other storage mechanism. Thank you. Email transmission cannot be guaranteed to be secured or error free, as information could be intercepted, corrupted, lost, destroyed, received late or incomplete, or could contain viruses. The sender therefore does not accept liability for any error or omission in the contents of this message, which arises as a result of email transmission. Opinions, conclusions and other information in this message that do not relate to the official business of Umniah Mobile Company and is not its responsibility shall be understood as neither given nor endorsed by the organization."

Received on Tue Mar 27 2007 - 02:46:29 CDT

Original text of this message