| Name: | RMAN backup status |
| Platform: | Oracle |
| Category: | Availability |
| Description: | Checks the status of RMAN full backup from V$RMAN_BACKUP_JOB_DETAILS performance view for input_type ‘DB FULL’. The procedure can also check incremental (input_type ‘DB INCR’) level 0 backup (equivalent to full backup) by checking V$BACKUP_DATAFILE performance view (column INCREMENTAL_LEVEL=0). |
| Long description: | Checks the status of RMAN full backup from V$RMAN_BACKUP_JOB_DETAILS performance view for input_type ‘DB FULL’. The procedure can also check incremental (input_type ‘DB INCR’) level 0 backup (equivalent to full backup) by checking V$BACKUP_DATAFILE performance view (column INCREMENTAL_LEVEL=0). |
| Version: | 2.64 |
| Default schedule: | 10 6 * * |
| Requires engine install: | Yes |
| Compatibility tag: | [CDATA[.[type=‘instance’ & databasetype=‘oracle’]/.[hasengine=‘YES’ & _cdb_v_rman_backup_job_details = ‘1’ & is_pluggdb = ‘0’ |
| Parameters | ||
| Name | Default value | Description |
| backup expire time | 168 | Backup expire time (in hours). If no valid backup exists within this time threshold a warning is returned. |
| 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. |
| check incremental level 0 | YES | If set to YES, the procedure checks for incremental level 0 backup if full backup (input_type = “DB FULL”) does not exists, or if the last full backup is running or failed. |
| container ID | 1 | The ID of the container to which the data pertains. |
| return status when OLD backup | 1 | Return status value (ALARM – 2, WARNING – 1, or OK – 0) when RMAN backup is older than “backup expire time” parameter value. |
| return status when backup NOT IMPLEMENTED | 1 | Return status value (ALARM – 2, WARNING – 1, or OK – 0) when RMAN backup is not implemented. |
| history threshold | 90 | The number of days the statistics are held in the dbwatch history table. |
| min output/input bytes ratio | 95 | The minimum output/input bytes ratio for incremental backup (input_type = “DB INCR”) which indicates if this is a level 0 or level 1 incremental backup. If no RMAN backup information is found (input_type “DB FULL” and “DB INCR” level 0) in V$RMAN_BACKUP_JOB_DETAILS, V$BACKUP_DATAFILE and dbWatch history table, the procedure check output/input bytes ratio in V$RMAN_BACKUP_JOB_DETAILS. |
← RMAN archivelog backup status / RMAN incremental backup status →
Post your comment on this topic.