oracle - Linux Cronjob scheduling issue -


i have cron job scheduled below.what invoke rman in oracle , clear achivelogs in oracle database 1 day old. issue is not getting executed through cron job. if execute same script prompt nicely delete logs through rman. please me in sheduling script...

05 07 * * * /x01/rman_backup/mahesh/logde.sh 

contents of script follows

#!/bin/bash  /x01/oracle/app/oracle/product/11.2.0/db_1/bin/rman cmdfile=/x01/rman_backup/mahesh /logdelete.rcv 

the content of logdelete.rcv below

connect target /  run   {   delete archivelog completed before 'trunc(sysdate)';   crosscheck archivelog all;     }  exit; 

please me in scheduling this. i'm using in suse linux version 11

generally, use output redirection cronjob collect errors in file, e.g.

06 12 * * * /x01/rman_backup/mahesh/logde.sh > /x01/rman_backup/mahesh/output.txt 2>&1

specifically, problem logdelete.rcv not found cron, job execute in $home file need there. if it's not, specify full path it.


Comments