Venky,
One thought that comes to mind is :
create sid specific backup status file
and if that file exists, code your script
that it won't spawn a second instance
of backup for the same sid.
Of course, for any abnormally ending
/zombie backups, make sure the
script cleans up those kind of status
files.
Rajeev
On May 25, 2018, at 5:46 PM, V Raman <vraman4list@xxxxxxxxx> 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?
Thanks,
venky.