RE: cloning a terabyte database

This is a network speed question. If your electronic network can keep up with shipping archived redo logs to the test box, then often sending tapes to the remote site (or portable disk packs, or DVDs, whatever you have and can reload at the remote site) is faster (and more acceptable to other users of the network) than trying to transmit a T over a shared network. Of course this all depends on your network bandwidth and available headroom thereon.  

Often sneakernet, taxi net, or DHL net are faster than the available electronic bandwidth, but it depends on what you've got and how far apart the locations are.  

Second, you wrote "damanged." Now if many of the files are okay, remember that Oracle supports heterochronous recovery just fine, so you can just send new copies of the damaged files as long as you have the redo logs available back through the oldest file from "test" that you want to recover.  

Regards,  

mwf  

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sanjay Mishra
Sent: Thursday, December 20, 2007 10:03 AM To: oracle-l_at_freelists.org
Subject: cloning a terabyte database  

Hi  

I had to copy a Terbayte Prod database and its test box is damanaged and has to recreate with Prod. What are the fastest method. Both Prod and Test server are at different location and so I cannot restore the Tape backup directly.  

TIA Sanjay  

Looking for last minute shopping deals? Find <http://us.rd.yahoo.com/evt=51734/*http:/tools.search.yahoo.com/newsearch/ca tegory.php?category=shopping> them fast with Yahoo! Search.

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