Re: cloning a terabyte database

Thanks to all. Finally I got good network setup between two location. Even I don't have 1 Tb space on Source, but will use Image backup and most of the files are not more 10G each and so created the script to compress the RMAN Image copy. This will save space as well as provide speed for the transfer. Most of the database files are in autoextend mode and so Image copy will not contain very high amount of free spaces.

Sanjay


----- Original Message ----
From: Mark W. Farnham <mwf@rsiz.com>
To: smishra_97@yahoo.com; oracle-l@freelists.org
Sent: Thursday, December 20, 2007 2:26:13 PM
Subject: 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Sanjay Mishra
Sent: Thursday, December 20, 2007 10:03 AM
To: oracle-l@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 them fast with Yahoo! Search.


      ____________________________________________________________________________________
Be a better friend, newshound, and 
know-it-all with Yahoo! Mobile.  Try it now.  http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

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