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

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

Dependency Information

Reporting

This job also includes a reporting template, which contains:

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

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.