14 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.
In addition to full database backups, most recovery strategies also back up archived redo logs so that point-in-time recovery is possible between full backups. A failed archived-log backup job breaks that chain and can leave a recovery gap even when the most recent full backup succeeded.
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 Archived-Log Backup Failures (24h)
Description
Counts failed archived-log backup jobs recorded in RMAN's job history within the last 24 hours. Archived-log backups typically run far more often than full backups, so a single missed run is usually low-impact on its own, but repeated failures point to a problem with the backup destination, such as a full Fast Recovery Area, that will eventually block redo generation and hang the instance. Consider pairing this metric with a Fast Recovery Area space-usage metric so the two alerts corroborate each other.
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 — reported at instance level (con_id 0); RMAN operates at whole-CDB level
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 archived-log 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
