RE: Methods to clone large production database

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.    

Fadi

http://oracle-magic.blogspot.com  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dennis Williams Sent: Tuesday, March 27, 2007 2:04 AM
To: laranichols_at_hotmail.com
Cc: Brandon.Allen_at_oneneck.com; oracle-l_at_freelists.org Subject: Re: Methods to clone large production database  

Lara,  

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."

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