把/opt/oraBakSH目录权限放开:chmod -R 777 /opt/oraBakSH
新建/opt/run.sh,内容:
#在/opt/oraBakSH下查找30天前的文件直接删除
find /opt/oraBakSH -ctime +30 -type f | xargs rm -rf
ORACLE_HOME=/opt/ora/product/10.2.0/db_1;
export ORACLE_HOME;
ORACLE_SID=lcsf;
export ORACLE_SID;
d=`date +%y-%m-%d-%H:%M`;
/opt/ora/product/10.2.0/db_1/bin/exp Userid=lcsfbak/666666 buffer=999999999 file=/opt/oraBakSH/lcsfbak$d.dmp log=/opt/oraBakSH/lcsfbak$d.log
oracle身份执行如下命令:
crontab -e(打开针对oracle的定时执行配置文件)
#每星期日的11 : 00 pm执行备份
0 23 * * 0 /opt/run.sh
crontab -l(查看修改的内容)
root身份重启crond命令:
pgrep crond:查看crond命令是否运行
pkill crond:关闭crond
/usr/
sbin/crond:启动crond