expdp脚本执行没问题,放在crontab里却有些问题!

soso801119

此脚本的目的是使用expdp工具对数据库的admin用户的所有数据进行备份,该脚本以oracle身份每周三 ,六 凌晨2点执行
0 2 * * 3,6 /home/oracle/scripts/dbbackup.sh

cron日志:/var/spool/cron记录该脚本已经按时执行
Apr  4 02:00:01 ridb crond[5985]: (oracle) CMD (/home/oracle/scripts/dbbackup.sh)
但实际第二天并没有生成相应的备份文件


但以oracle 用户 手动执行该脚本可正常生成备份文件.有人遇到过类似问题吗?
oracle@ridb ora_backup]$ /home/oracle/scripts/dbbackup.sh

Export: Release 10.2.0.1.0 - Production on Wednesday, 04 April, 2007 10:19:51

Copyright (c) 2003, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Starting "ADMIN"."RIDB_DUMP_0404":  admin/******** dumpfile=ridb_dump_0404.dmp directory=dump logfile=ridb_dump_0404.dmp.log job_name=ridb_dump_0404.dmp
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 12.93 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
.
.
.
Job "ADMIN"."RIDB_DUMP_0404" successfully completed at 10:36:27

脚本内容如下
--------------------------------------------------------------
#!/bin/sh
EXP_FILE="ridb_dump_`date +%m%d`.dmp"
LOG_FILE="${EXP_FILE}.log"

cd /oracle_data/ora_backup
find . -ctime +8 -exec rm -rf {} \;

if [ -f $EXP_FILE ]; then
        rm -f $EXP_FILE*
fi

expdp ***/****** dumpfile=$EXP_FILE directory=dump logfile=$LOG_FILE job_name=$EXP_FILE

gzip -9 /oracle_data/ora_backup/$EXP_FILE
--------------------------------------------------------------

remen

Check the user env and path of the shell,you'd better use absoluteness path

blue_stone

crontab执行后，oracle用户会收到一个邮件，包含了crontab执行时屏幕的输出，
用mail命令可以查看

[ 本帖最后由 blue_stone 于 2007-4-4 11:11 编辑 ]

lmtok

crontab里面调用脚本程序，往往必需将各种环境变量重新设置一下，我估计LZ的问题也在于此

xmltiger

shell没有加载oracle环境变量