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.