配置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 <
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 <
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定时调用此脚本。
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 <
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 <
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博客 ” ，链接：https://blog.itpub.net/28538954/viewspace-1204821/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
