Re: Best way to move data beween servers

"QT" <qtockar_at_hotmail.com> wrote in message news:<b4hp1g$ito$1_at_nnrp01.ops.uunet.co.za>...
> Hi All
>
> I need to move data from a Compaq Server to a Sun Server. The amount of data
> is 0.5 terrabytes. This will be on Oracle 817. What is a good place to start
> on how to do this and what would be the best way with the least downtime?
>
>
> TIA
>
> QT

QT, Group,

Couldn't resist :
There is another truly (w)hacky way to do it when storage and bandwith are limited
(have only done this once, way back in the nineties, both systems were hp-ux).

On source server and source db :
prepare an exp script to export into a pipe (pipe1), hang a compress-uitility behind the pipe, compress into another pipe (pipe2),
hang an ftp-session behind the 2nd pipe, and send the 2nd pipe straight to your target server.

On target system :
prepare a pipe (pipe3) to receive the result of the ftp-session, hang an uncompress utility behind pipe3, uncompress into another pipe : pipe4,
hang an imp session behind pipe4, and import into target db.

Advantages :

• storage : Data never gets written to disk outside of the datbase
• Speed : minimal disk-io, and amount of data transferred is limited by compress.

Disadvantages:

• over-engineered, takes a lot of carefull preparation.
• fragile, too many things can (and will) go wrong.
• no intermediate copies anywhere (I prefer to have at least 1 solid file somewhere).

Other remarks:

• Will only work well on unix to unix.
• you can devise dress-down versions where you only use the pipe-compress tricks to never have full-size dump-files.

Luck,

Pdv
Oracle DBA,
Oracle Dino. Received on Tue Mar 11 2003 - 04:40:28 CST