mk_oracle version: 2.1.0p38
I am using mk_oracle to monitor 30+ Oracle databases. All have the same setup (Linux, x86_64, Oracle 19c).
On one of the databases I have an issue with the DB_INCR_0 RMAN Backup check.
It can only find a very old level 0 backup. However, I have verified with the following script (and of course from logs in the backup system) that the level 0 backups are running every week:
SELECT
BS.RECID,
BS.STAMP,
BS.SET_STAMP,
BS.SET_COUNT,
BS.BACKUP_TYPE,
MAX(BP.COMPLETION_TIME) AS COMPLETION_TIME
FROM
V$BACKUP_SET BS
JOIN
V$BACKUP_PIECE BP ON BS.SET_STAMP = BP.SET_STAMP AND BS.SET_COUNT = BP.SET_COUNT
WHERE
BS.BACKUP_TYPE = 'I' AND BS.INCREMENTAL_LEVEL = 0
GROUP BY
BS.RECID, BS.STAMP, BS.SET_STAMP, BS.SET_COUNT, BS.BACKUP_TYPE
ORDER BY
COMPLETION_TIME DESC
FETCH FIRST 1 ROW ONLY;
Output from the query:
RECID STAMP SET_STAMP SET_COUNT B COMPLETIO
---------- ---------- ---------- ---------- - ---------
3425638 1166803237 1166803235 3591488 I 20-APR-24
However – mk_oracle can only find this:
ORADBNAME|COMPLETED|2024-01-13_03:48:25|2024-01-13_03:48:25|DB_INCR|0|147406|0
I’ve ran the “check_mk rman1” SQL command and have verified that this is the only level 0 backup it selects, but it does show a lot of level 1 backups (and the monitoring of those is working as expected).
Has anyone seen a similar issue with mk_oracle?
Bgrds,
Finnur