Once a day, we issue the following query through cron to see if
RMAN is still running.
select operation,OBJECT_TYPE,ROW_TYPE from $RMAN_STATUS where status='RUNNING' and OPERATION='BACKUP' and OBJECT_TYPE !='ARCHIVELOG';
On some systems, when a full backup is in progress this query sees that a previous instance of RMAN is still running and reports it as
an error when in fact its not because the DB is so big and take a long time to backup.
Is there some table I can query where if I provide a tag for my full backup (ie tag=full_backup) or some other information I can look
to see if that tag is still being backed up. This would be very equivelant to providing a job name to expdp and seeing if that job_name is active
I was considering doing a select count... but that would not work as
we often clone DB's and I beleive this will bring out the same error.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.