用crontab实现oracle自动备份,crontab里的任务老是无法执行

brucebo

我直接执行脚本的时候没有问题.
bash-3.00$ crontab -l
30 14 * * * /export/home/oracle/bakDB.sh

日志文件如下:
bash-3.00# tail -f /var/cron/log
could not obtain latest contract from popen(3C): 无此进程 六  3月  3 11:00:00 2007
bash-3.00$ tail -f /usr/mail/oracle
/bakDB.sh: line 9: exp: command not found
/bakDB.sh: line 10: exp: command not found
        zip warning: name not matched: *

zip error: Nothing to do! (bak0703031430.zip)
*.zip: No such file or directory
Hash mark printing on (8192 bytes/hash mark).
mv: cannot access *

希望斑竹帮帮忙

[ 本帖最后由 brucebo 于 2007-3-3 15:09 编辑 ]

linuxkumao

30  14  * * *  /bin/sh  /export/home/oracle/bakDB.sh

Syrita

I think you'd better declare some vital env variables in your script.

briangao

could not obtain latest contract from popen(3C): 无此进程 六  3月  3 11:00:00 2007

Is your Solaris version 10 u1? (cat /etc/release will tell you). If so, this is a bug and it is fixed in s10u3.

/bakDB.sh: line 9: exp: command not found
/bakDB.sh: line 10: exp: command not found

cron job doesn't run through a terminal. The environment variables in your profile will not be read. So you should explicitly source your profile in your backDB.sh file and/or use absolute path for the exp command

[ 本帖最后由 briangao 于 2007-7-13 09:34 编辑 ]

nbrr

我在几架测试机都是每天跑exp备份的
你的ORACLE_HOME ORACLE_SID PATH LD_LIBRARY_PATH都要设好
可能也需要设NLS_LANG