Re: cloning a terabyte database

  • From: Sanjay Mishra <smishra_97@xxxxxxxxx>
  • To: mwf@xxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 28 Dec 2007 15:11:59 -0800 (PST)

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.


----- Original Message ----
From: Mark W. Farnham <mwf@xxxxxxxx>
To: smishra_97@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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 
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.

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sanjay Mishra
Sent: Thursday, December 20, 2007 10:03 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: cloning a terabyte database
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.

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.;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

Other related posts: