Oracle定期逻辑备份脚本

利用crontab定期逻辑备份、上传备份集、删除过期备份等

[oracle@ray ~]$  crontab -l
01 22 * * * /backup/logicbak/logicbak.sh > /tmp/logicbak.out

[oracle@ray ~]$ cat /backup/logicbak/logicbak.sh

#!/bin/bash
. $HOME/.bash_profile
LOGICBAK_LOG_FILE=/backup/logicbak/logicbak.out
echo ==== started on `date` ==== >> $LOGICBAK_LOG_FILE
echo >> LOGICBAK_LOG_FILE
REMOTE_IP=192.168.0.11
RUSER=ceshi
RPASS=Ceshi123
BACKUP_HOME=/expdp/logicbak
cd /backup/
curr_date=`date +%Y%m%d%H%M%S`
curr_date_for_del=`date -d "30 day ago" +%Y%m%d`
find . -name "*.dmp" -mtime +1 -exec rm {} \;
find . -name "*.log" -mtime +1 -exec rm {} \;
#expdp \'/ as sysdba\' directory=DATA_PUMP_DIR dumpfile=BACKFULL_BAK_${curr_date}.dmp logfile=BACKFULL_BAK_${curr_date}.log full=y COMPRESSION=ALL CLUSTER=N 
expdp \'/ as sysdba\' directory=DATA_PUMP_DIR dumpfile=BACKFULL_BAK_${curr_date}_%U.dmp logfile=BACKFULL_BAK_${curr_date}.log full=y COMPRESSION=ALL CLUSTER=N PARALLEL=4 exclude=statistics
echo >> LOGICBAK_LOG_FILE
ftp -n $REMOTE_IP <<!
user $RUSER $RPASS
lcd /backup
prompt
binary
mput *${curr_date}*
mdelete *${curr_date_for_del}*
bye
!
echo >> $LOGICBAK_LOG_FILE
echo ==== ended on `date` ==== >> $LOGICBAK_LOG_FILE