RE: cloning a terabyte database

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <smishra_97@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 20 Dec 2007 14:26:13 -0500

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.







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






Looking for last minute shopping deals? Find
tegory.php?category=shopping>  them fast with Yahoo! Search.

Other related posts: