-
Título
Incremental level 0 backup triggers the following alarm, DBO - Days Since Full Backup (alarm group: Storage) -
Descripción
While using the Cartridge for Oracle, an instance is backed up once a day using RMAN. The backups are incremental backups
This server is using 2 types of incremental:
Incremental level 1 which is a regular incremental backup
Incremental level 0 which is in fact a full backupThe 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> -
Causa
Incremental backups are not detected as "Full" type backups. -
Resolución
WORKAROUND
If you are not interested to receive "Days Since Full Backup" alerts you can disable this alarm, but you will still be alerted on any failed backup jobs.
As we can see from sample RMAN command output below, the Type is 'Incr' and not 'Full', but the Level, 'LV' column is 0, so we can assume a Full backup has taken place even though a 'Full' backup was not scheduled.
LIST BACKUP;BS Key Type LV Size Device Type Elapsed Time Completion Time------- ---- -- ---------- ----------- ------------ -----------------989 Incr 0 300.14G SBT_TAPE 09:05:55 20120311 17:08:26<truncated>List of Datafiles in backup set 989File LV Type Ckp SCN Ckp Time Name---- -- ---- ---------- ----------------- ----9 0 Incr 138593388704 20120311 05:02:32 /<path>/file_01.dbf14 0 Incr 138593388704 20120311 05:02:32 /<path>/file_02.dbf20 0 Incr 138593388704 20120311 05:02:32 /<path>/file_06.dbf24 0 Incr 138593388704 20120311 05:02:32 /<path>/file_04.dbf31 0 Incr 138593388704 20120311 05:02:32 /<path>/file_07.dbfSTATUSA new "DBO - Days Since Incremental Level 0 Backup alarm has been included as Enhancement ORAFOG-309 beginning with the 5.7.5.50 and higher releases of the Oracle cartridge.