用shell写的数据迁移的例子

#!/usr/bin/ksh
workdir=`pwd`
refdir=`dirname $workdir`
datadir="$refdir/data"
mkdir -p $datadir
user1_par=$workdir/user1.par
user2_par=$workdir/user2.par
touch $user1_par
touch $user2_par
userscriber1_par=$workdir/userscriber1.par
userscriber2_par=$workdir/userscriber2.par
touch $userscriber1_par
touch $userscriber2_par
cfgfile=$refdir/config/config.cfg
logfile="$refdir/log/down.log"
touch $logfile


#sysdb数据下载
userid=`cat $cfgfile | grep USERID | awk -F"=" '{print $2}'`;
tables_01=`cat $cfgfile | grep TABLES_HOMECBP | awk -F"=" '{print $2}'`;
tables_02=`cat $cfgfile | grep TABLES_NO_HOMECBP | awk -F"=" '{print $2}'`;
tables_scribercbp=`cat $cfgfile | grep TABLES_SUBSCRIBERCBP | awk -F"=" '{print $2}'`;
username=`cat $cfgfile | grep USERID | awk -F"=" '{print $2}' |awk -F"/" '{print $1}'`;
query_01=`cat $cfgfile | grep USERCBP_ONE | awk -F"=" '{print $2}' | sed 's/,/ or HOMECBP=/'`;
query_02=`cat $cfgfile | grep USERCBP_TWO | awk -F"=" '{print $2}' | sed 's/,/ or HOMECBP=/'`;
query_scribercbp01=`cat $cfgfile | grep USERCBP_ONE | awk -F"=" '{print $2}' | sed 's/,/ or SUBSCRIBERCBP=/'`;
query_scribercbp02=`cat $cfgfile | grep USERCBP_TWO | awk -F"=" '{print $2}' | sed 's/,/ or SUBSCRIBERCBP=/'`;
rm -f ${datadir}/*


########下载user01的数据begin##########


sqlplus -S ${userid} <<EOF
drop directory dump_user;
create directory dump_user as '$datadir';
conn /as sysdba;
grant read, write on directory dump_user to $username;
EOF
logwrite ()
{
    curtime=`date '+%Y-%m-%d %H:%M:%S'`
    prin