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

brucebo

我直接执行脚本的时候没有问题.\r\nbash-3.00$ crontab -l\r\n30 14 * * * /export/home/oracle/bakDB.sh\r\n\r\n日志文件如下:\r\nbash-3.00# tail -f /var/cron/log\r\ncould not obtain latest contract from popen(3C): 无此进程 六  3月  3 11:00:00 2007\r\nbash-3.00$ tail -f /usr/mail/oracle \r\n/bakDB.sh: line 9: exp: command not found\r\n/bakDB.sh: line 10: exp: command not found\r\n        zip warning: name not matched: *\r\n\r\nzip error: Nothing to do! (bak0703031430.zip)\r\n*.zip: No such file or directory\r\nHash mark printing on (8192 bytes/hash mark).\r\nmv: cannot access *\r\n\r\n 希望斑竹帮帮忙\n\n[ 本帖最后由 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\r\n

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

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

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\n\n[ 本帖最后由 briangao 于 2007-7-13 09:34 编辑 ]

nbrr

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