配置linux自动进行rman备份并打包结果集进行FTP上传

export SYSDATE=`date +%Y%m%d`
echo $SYSDATE
source /home/oracle/.bash_profile
export ORACLE_SID=OKAIRDB
#RMAN备份部分
rman target sys/oracle  1>/dbbak/scripts/logs/rmanbak_full_$SYSDATE.log 2>&1 < crosscheck archivelog all;
backup as compressed backupset full database include current controlfile plus archivelog delete all input;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
exit;
EOF
#zip打包过程
cd /dbbak/backup
rm -rf *.zip
zip -r db_3_120_bak_$SYSDATE.zip *
#FTP自动上传部分
ftp -n 1>/dbbak/scripts/logs/ftp_$SYSDATE.log 2>&1 < open 172.16.3.180
user ORA003120 ORA003120
put /dbbak/backup/db_3_120_bak_$SYSDATE.zip db_3_120_bak_$SYSDATE.zip 
close
bye
EOF

#cat /dbbak/scripts/logs/rmanbak_full_$SYSDATE.log
exit

---

剩下的便是使用crontab定时调用此脚本。

---

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28538954/viewspace-1204821/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28538954/viewspace-1204821/