linux Oracle 自动备份并scp

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}/<span style="font-family: Arial, Helvetica, sans-serif;">test</span><span style="font-family: Arial, Helvetica, sans-serif;">$(date '+%Y%m%d').log file=${path}/</span><span style="font-family: Arial, Helvetica, sans-serif;">test</span><span style="font-family: Arial, Helvetica, sans-serif;">$(date '+%Y%m%d').dmp</span><span style="font-family: Arial, Helvetica, sans-serif;">
</span>#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 任务