Re: Hello list, script scheduling question.

From: Mladen Gogala <>
Date: Fri, 25 May 2018 19:08:50 -0400
Message-ID: <>


if [ -f /tmp/backup_running_$ORACLE_SID ];


   echo "Backup crawling for $ORACLE_SID";



   touch /tmp/backup_running_$ORACLE_SID;


Crontab emails the standard output of the script to the issuer, so you should be fine. BTW, this is a standard shell programming solution, nothing to do with Oracle.  This is elementary, my dear Raman.

On 05/25/2018 05:46 PM, V Raman wrote:
> I am trying to set up a backup script to be called for various DBs in
> the DB server through crontab. If an instance of the script is running
> for the GIVEN oracle_sid I dont want another instance of the backup
> script to be started. However, if an instance of the script is running
> for a different oraclesid, I am ok with starting a new instance run of
> the script. Linux RHES7, bash.
> I tried using grep, grep -v $$, pgrep, etc inside the script and also
> tried pgrep in crontab, not lucky. Web searching has not led me
> anywhere so far.  Any short and sweet solution for this issue?

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

Received on Sat May 26 2018 - 01:08:50 CEST

Original text of this message