oracle备份以及定时上传备份服务器

我把备份oracle以及上传备份服务器的脚本贴出来给你们做一下参考。

[root@master ~]-cat expDB_DailyBackup.sh #---------------------------Set Parameter----------------------------------------ENVFILE="/etc/profile"EXITCODE=0uDate=`date +'%Y%m%d'`Week=`date +'%a'`dbBackup=/home/app/backup/db_DailytarName=app_${uDate}_DB_DailyBk.tar.gz#---------------------------Exit Program----------------------------------------exit_handler(){    exit $EXITCODE}#---------------------------Load the environment file----------------------------------------if [ -r "$ENVFILE" ]then    source $ENVFILEelse    EXITCODE=-1    exit_handlerfi#---------------------------Backup Application To Directory----------------------------------------cd $dbBackup# Export Database To Fileexp app_admin/app_admin file=app_${uDate}_DB_DailyBk.dmp #---------------------------Send The File To Remote Host----------------------------------------cd $dbBackuptar -zcvf $tarName app_${uDate}_DB_DailyBk.dmp# Rename Backup For Remote Hostcp $tarName app_${Week}_DB_DailyBk.tar.gz lftp << EOF open sftp://10.0.0.18:1022 user backup backup!@# cd db_Daily put app_${Week}_DB_DailyBk.tar.gz exitEOF# Delete Rename Backuprm -f app_${Week}_DB_DailyBk.tar.gz rm -f app_${uDate}_DB_DailyBk.dmp# Exit Shell Scriptexit_handler

crontab设置定时任务，每天23:55分开始备份。

# app Daily Backup 55 23 * * * sh /home/app/bin/expDB_DailyBackup.sh