Introduction
This alert will check the status of RMAN backups by looking at the V$RMAN_BACKUP_JOB_DETAILS tables and return any row from the last hour (based on frequency of the alert) where the status is 'COMPLETED WITH WARNINGS', 'COMPLETED WITH ERRORS', 'FAILED'.
ALERT DEFINITION
To create this alert, click on Alerts > Manage Alerts tab and create a Custom SQL Alert with Multiple Numeric Return type. Configure the alert similar to below:
Alert Name: RMAN Backups Failed
Execution Interval: 1 Hour
Notification Text: The following RMAN backup jobs failed within the last hour.
SQL Statement:
select 'Backup: ' || input_type || ' failed with status: ' || status, 1
from v$rman_backup_job_details
where end_time >= current_timestamp - #FREQUENCY#
and status in ('COMPLETED WITH WARNINGS', 'COMPLETED WITH ERRORS', 'FAILED')
Execute Against: Monitored Instance
Units: <blank>
High Threshold: MIN 1, MAX empty
Medium Threshold: <none>