Re: How best to move oracle9 db and binaries between similiar unix servers?

First of all verify with Unix admin about ssh . if you have ssh or similar then use following sql to generate the command. Edit the spooled file and add wait after xx number of lines to run the jobs at a time in background ( depends on server) . This is much much faster due to block size of 256 K. The default block size is 8k . We tested with blocks of 8k-1028 but the best result was with 256K . This scripts starts tar file , transfer the files on another server and extract the file on another server . Every things happens in parallel . We use this command on regular basis on Unix to copy the files from production to development , test , stage etc. and have no issues

set pages 0
set lines 200
spool ssh.ksh

select 'tar cbf 256 - '||file_name||' | ssh oracle_at_usscora1000 '||' "(cd '||' /; tar xvbpf 256 - )'||'" &' from dba_data_files
/

spool off

• output looks like

  ---

  #/bin/ksh set -v tar cbf 256 - /u20/arjdvdata/XKBD01.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u17/arjdvdata/XKBX01.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u07/arjdvdata/TEMP07.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u07/arjdvdata/TEMP06.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u07/arjdvdata/TEMP05.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  wait tar cbf 256 - /u07/arjdvdata/TEMP04.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u07/arjdvdata/TEMP03.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u07/arjdvdata/TEMP02.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  tar cbf 256 - /u07/arjdvdata/TEMP01.dbf | ssh oracle_at_newserver
  "(cd /; tar xvbpf 256 - )" &
  wait