1. 建立一个脚本,假定是/home/oracle/backup/backup_wcm_tk.sh:
ORACLE_HOME=/opt/ora10g/product/10g;
export ORACLE_HOME;
ORACLE_SID=oracle;
export ORACLE_SID;
/opt/ora10g/product/10g/bin/exp tk/pmph@224tk file=/home/oracle/backup/tk$(date +%Y%m%d).dmp owner=tk log=/home/oracle/backup/tk$(date +%Y%m%d).log
find /home/oracle/backup/ -name "tk*" -type f -mtime +2 -exec rm {} \;
2. 保证/home/oracle/backup/ 可以写入,脚本可执行:chmod 777 /home/oracle/backup/ , 切换进入ORACLE用户:su -l oracle
3. 添加定时任务:crontab -e
加入一条语句,是每天的凌晨1点15分执行:
15 1 * * * "/home/oracle/backup/backup_wcm_tk.sh"
如果是其它备份,步骤类似,但不用执行第二步: