脚本编写
#!/bin/sh
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH:$HOME/bin
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
DATE=$(date +%Y%m%d)
DATE_RM=$(date -d "7 days ago" +%Y%m%d)
backup_user="user"
backup_pass="pass"
export DIR=/home/oracle/dbback
mkdir ${DIR}/${DATE}
echo 'Oracle backup...'
exp ${backup_user}/${backup_pass}@${ORACLE_SID} file=${DIR}/${DATE}'/oracle_backup_'${DATE}'.dmp' log=${DIR}/${DATE}'/oracle_backup_'$DATE'.log'
echo 'Oracle backup successfully.'
echo 'remove...'
rm -rf ${DIR}/${DATE_RM}
echo 'remove successsfully.'
脚本增加执行权限
chmod +x backup_oracle.sh
计划任务增加
crontab -l
00 17 * * * /home/oracle/dbback/shell/backup_oracle.sh
参考