Oracle RMAN Backup Age Alert


Use the RMAN Backup Age alert in Mini DBA to monitor Oracle instances and make this condition visible before it becomes a wider database incident.

Screenshot pending: Mini DBA Oracle RMAN Backup Age alert screenshot placeholder

Alert Summary

  • Platform: Oracle
  • Alert category: Availability
  • Default enabled: true
  • Default evaluation frequency: Minute
  • Threshold label: Hours since backup
  • Unit: hours

What Mini DBA Checks

Mini DBA describes this alert as: Hours since last successful RMAN backup Default warning is 168 hours (7 days), matching the no-backup-found message. System-container-only Oracle installs are ignored until a user database/PDB exists, and alerts identify the affected database/PDB. Critical for disaster recovery, compliance requirements, and data protection Remediation: Run RMAN backup immediately, check backup schedule, and investigate failures The default evaluation frequency is Minute, so the alert is intended to be close enough to operational reality for live triage.

Why This Alert Is Helpful

This alert protects storage and recovery capacity. It helps you find growth, retention, and backup conditions that can stop writes, break recovery objectives, or leave the server without enough working space for normal database activity.

When To Enable It

Enable it on systems with recovery objectives and on any database where a missed backup or archive problem would require business escalation. Test and lab systems can use looser settings if they are recreated from source control or seed data.

Threshold Guidance

Threshold meaning: Hours since backup. Minor threshold: 168 hours. Comparison direction: "over". Use higher thresholds on batch-heavy, development, or intentionally bursty systems where brief pressure is expected. Use lower thresholds on latency-sensitive production systems, small instances with little headroom, and services with strict recovery or availability commitments.

Remediation For An Active Alert

Run or restart the missing backup after checking storage and job history. Confirm that restore requirements are met, clear failed schedules, and make sure backup monitoring reports the next successful run.

Investigation Workflow

  1. Confirm the alert is still active and note the first seen time, affected instance, and severity.
  2. Review the affected disk, tablespace, log stream, backup job, retention setting, and recent growth pattern in Mini DBA before changing configuration or ending sessions.
  3. Compare the current value with the normal baseline for the same time of day or maintenance window.
  4. Record the cause, corrective action, and whether thresholds or routing should be adjusted after the incident.

Avoiding Alert Noise

For recovery and replication alerts, route notifications to the people who own recovery objectives. Higher thresholds can be reasonable for reporting replicas, but production failover paths normally need tighter settings and explicit escalation.

Related Pages