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.
Sanjay
----- 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
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@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
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
Other related posts:
