15 Metrics install automatically if you have Redgate Monitor installed.
If you are using Redgate’s SQL Server monitoring tool, Redgate Monitor, you can instantly install and run this metric on your servers.
RMAN is Oracle’s built-in backup and recovery utility, and most environments schedule full (or level-0 incremental) database backups on a recurring cycle. When a backup job’s STATUS is recorded as FAILED, the most recent full-backup attempt did not produce a usable backup, directly threatening your recovery point objective if it goes unnoticed.
Required permissions:
GRANT SELECT ON V_$RMAN_BACKUP_JOB_DETAILS TO redgate_monitor_user CONTAINER=ALL;
These are covered by Redgate Monitor’s standard Oracle monitoring user — if it was set up as described in the product documentation, no additional grants are needed.
Metric definition
Name
RMAN Full Backup Failures (24h)
Description
Counts failed full database backup jobs recorded in RMAN's job history within the last 24 hours. If your backup strategy uses incremental level-0/level-1 backups instead of traditional full backups, change input_type to 'DB INCR'; run SELECT DISTINCT input_type FROM v$rman_backup_job_details to see the values recorded in your environment. Confirm your scheduled backup window falls inside the period you are querying.
Supported database engine
- Oracle
The T-SQL query that will collect data
Instances to collect from
Select all monitored Oracle instances (on Amazon RDS the view is typically empty — the metric stays silently at 0)
Databases to collect from
Not applicable - Oracle custom metrics collect once per instance, and values are stored per container (PDB) via the con_id column
Collection frequency
1800
seconds (collected every 30 minutes)
Use collected or calculated values
Leave the Use a calculated rate of change between collections check box unchecked
Metric collection
Enabled
Alert definition
Alert name
RMAN full backup failed
Description
Raise an alert when the metric value goes
Above the defined threshholds
Default threshold values
| High: | 0 |
| Medium: | |
| Low: |
Raise an alert when the threshold is passed for
1 collection
Alert is
Enabled
