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'.
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.
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community.
More than 150,000 members are here to solve problems, share technology and best practices, and directly
contribute to our product development process.