手动执行,没有任何错误,也有正常结果。但是用crontab时,在既定的时间却没有执行。请问这有何解?
脚本如下:
export ORACLE_HOME=/opt/oracle/product/11.2.0/dbhome_1
$ORACLE_HOME/bin/rman target sys/easysystem@xxxxxx catalog rman/rman@xxx append<> /home/oracle/tt.tmp
run
{
Crosscheck backup;
Crosscheck archivelog all;
delete NOPROMPT expired backup;
delete NOPROMPT OBSOLETE;
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
backup as compressed backupset database tag 'FullBackup' format '/racbackup/bak/db_full_%T_%d_%t_%s_%p_bak0' ;
sql 'alter system archive log current';
backup as compressed backupset format '/racbackup/bak/arch_%T_%d_%t_%s_%p_bak0' archivelog all delete input;
backup spfile format '/racbackup/bak/spfile_%T_%d_%t_%s_%p_bak0';
release channel c1;
release channel c2;
release channel c3;
}
EOF
var=`date +%Y/%m/%d`
echo "Full backup completed at $var" >> /home/oracle/rman.log