RMAN backup status

Job details

Name:	RMAN backup status
Platform:	Oracle
Category:	Availability
Description:	Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
Long description:	Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
Version:	2.4
Default schedule:	10 6 * *
Requires engine install:	Yes
Compatibility tag:	.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & (version like ‘10.1%’)]

Parameters

Name	Default value	Description
backup expire time	24	Backup expire time.
return status when backup RUNNING	1	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when RMAN backup status value is RUNNING.
return status when backup FAILED	2	Return status value (ALARM – 2, WARNING – 1, or OK – 0) when RMAN backup status value is FAILED.

Job Summary

Purpose: The purpose of this job is to monitor the status of Oracle Recovery Manager (RMAN) backups for Oracle database instances, specifically version 10.1.
Why: This job is crucial for ensuring that RMAN backups are executed as expected and any issues are promptly identified:
- Detects and alerts if backups are not implemented or have failed, which is critical for data recovery and compliance with data protection policies.
- Monitors the age of the last successful backup to alert if it might be too old, preventing potential data loss due to outdated backups.
- Tracks the status of ongoing backups to provide real-time updates and intervention if needed.
Manual checking: You can check the status of RMAN backups manually by issuing the following SQL command:

SELECT start_time, end_time, status, round(MBYTES_PROCESSED) as backup_MB FROM V$RMAN_STATUS WHERE MBYTES_PROCESSED > (SELECT sum(bytes/1024/1024) FROM dba_segments) ORDER BY start_time DESC;

Implementation Details

The monitoring job is implemented using a custom PL/SQL procedure named “rman_backup_status”.
The procedure queries V$RMAN_STATUS and V$RMAN_BACKUP_JOB_DETAILS views to fetch and compute detailed backup status.

Dependency Information

This task depends on rman_backup_status, which refers back to itself indicating a recursive dependency structured for robust monitoring.

Reporting

This job also includes a reporting template, which contains:

Data visualization for backup status over time, size of the backups, and detailed backup history records.
Configurable presentations in the form of tables and charts to aid in the visualization of RMAN backup operations.

Presentation Section	Description
Backup Statistics	Summarizes the history and statistics of RMAN backups, including start and end times, status, and MB processed.
Backup Size History	Displays a chart showing the pattern and change in backup sizes over time.
RMAN Configuration	Shows the current configuration settings for RMAN, aiding in verification and adjustments if necessary.

Additional Functionalities

The job is scheduled to run every day at 6:10 AM.
There are options for alarming and warning based on the age of the last backup and whether backups are running or have failed.

This combination of real-time monitoring with detailed periodic reports provides comprehensive coverage of Oracle RMAN backup health, ensuring timely interventions and maintaining operational recovery objectives.