Retour
-
Titre
DBO Days Since Backup does not monitor Oracle INCR Level 0 incremental backup types -
Description
While using the Cartridge for Oracle, an instance is backed up once a day using RMAN. The backups are incremental backups (DB INCR)
The "DBO - Days Since Full Backup " rule incorrectly fires because the alarm is not validating the INCR LEVEL 0 as a FULL backup.The following alarm is fired for the instance:Foglight Cartridge for Oracle has generated a Warning alarm for Oracle instance <instanceName>on host <hostName>.
Alarm: DBO - Days Since Full Backup (alarm group: Storage)
Severity: Warning
Message: FOGLIGHT DEVELOPMENT, The last date that the full backup was completed successfully is <DATESTAMP>.
Created on: <DATE-TIME-STAMP> -
Cause
There are two types of incremental backups:
Incremental level 1 which is a regular incremental backup
Incremental level 0 which is in fact a full backupBackup RMAN FULL and backup RMAN INCREMENTAL Level 0 both register as FULL backups.The limitation is that in v$rman_status used by the collection, the output in both cases will be "DB INCR" (without the level: 0 or 1) so the Oracle agent cannot know whether it's level 0 (Full backup) or level 1 -
Résolution
The rule and alarm "DBO - Days Since Incremental Level 0 Backup" can be used to monitor Incremental Level 0 backups.