為啥JOB不執行呢?

orablue

linux as 3+ oracle 9204



[root@dbserver02 cron]# pwd
/var/spool/cron
[root@dbserver02 cron]# ls -al
total 12
drwx------    2 root     root         4096 Aug 19 16:00 .
drwxr-xr-x   13 root     root         4096 Aug 16 14:19 ..
-rw-------    1 root     oinstall       55 Aug 19 16:00 oracle
[root@dbserver02 cron]# cat oracle
30 23 * * * /opt/backup.sh > /u02/oraclebak/backup.log
[root@dbserver02 cron]#


[oracle@dbserver02 opt]$ crontab -e
30 23 * * * /opt/backup.sh > /u02/oraclebak/backup.log

[oracle@dbserver02 opt]$ cat backup.sh
#!/bin/ksh

echo " Script Name : backupdatabase"
echo " Create Date : 2006-08-19"
echo " ************************************* backupdb.sh file run begin *******************************"
echo ""

export ORACLE_BASE=/opt/oracle ;
export ORACLE_HOME=/opt/oracle/product/9204 ;
export ORACLE_SID=db001;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data ;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:usr/libLD_LIBRARY_PATH ;
export PATH=$PATHORACLE_HOME/bin:/usr/sbin;
$ORACLE_HOME/bin/rman target / < run{
allocate channel c1 type disk ;
backup database format '/u02/oraclebak/full_%d_%t_%s_%p.bak' include current controlfile ;
sql 'alter system archive log current';
backup archivelog all format '/u02/oraclebak/arch_%d_%t_%s_%p.bak' delete input;
release channel c1;
}
exit ;
EOF

$ORACLE_HOME/bin/rman target / < crosscheck backup ;
crosscheck archivelog all ;
delete noprompt obsolete ;
delete expired backup;
exit ;
EOF
echo "************************************* backupdb.sh file run end **********************************"

[ 本帖最后由 orablue 于 2006-8-21 11:45 编辑 ]

orablue

是不是權限問題呢 /
[root@dbserver02 opt]# ls -al
total 40
drwxr-xr-x    4 oracle   501          4096 Aug 19 15:16 .
drwxr-xr-x   22 root     root         4096 Aug 17 14:29 ..
-rw-r--r--    1 root     root         1107 Aug 19 15:16 backup.sh

[ 本帖最后由 orablue 于 2006-8-21 12:18 编辑 ]

orablue

昨天晚上還是沒有執行，為啥呢