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
Post a Comment