1、编写脚本
oracle 用户下的脚本必须添加环境变量
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/db
export ORACLE_SID=orcl1
export ORACLE_UNQNAME=orcl
export ORACLE_TERM=xterm
export NLS_DATE_FORMAT="yyyy-mm-dd hh24:mi:ss"
export NLS_LANG="AMERICAN_AMERICA.AL32UTF8"
export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/oui/bin:/usr/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/sdbms/jlib
export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
path=/home/oracle/backup
#date5=$(date +%Y%m%d -d '3 days ago')
#touch ${path}/test_in_$(date '+%Y%m%d').log
#echo begin > ${path}/test_in_$(date '+%Y%m%d').log
exp test/test123 OWNER=test log=${path}/test$(date '+%Y%m%d').log file=${path}/test$(date '+%Y%m%d').dmp
#echo endExp >> ${path}/drvtraining_in_$(date '+%Y%m%d').log
scp ${path}/test$(date '+%Y%m%d').dmp root@172.17.0.136:/pic/db_backup
scp ${path}/test$(date '+%Y%m%d').log root@172.17.0.136:/pic/db_backup
rm -f ${path}/test$(date '+%Y%m%d').dmp
#echo end >> ${path}/test_in_$(date '+%Y%m%d').log
2、配置完密码scp至136服务器
3、添加crontab 任务