Check manual page of oracle_recovery_status
|Oracle: Checkpoint and User Managed Backup State of Datafiles|
|Distribution||official part of Check_MK|
|Supported Agents||Linux AIX Hp/Ux Solaris|
The 2nd function is the monitoring of datafiles in manual backup mode. This is important for database which are backed up with 'alter database begin/end backup;' - RMAN didn't use this function and it is not needed for that backup type. If an end backup is missing and you restart the database you'll unable to open the database.
To prevent such situations, the state of the backup mode could be monitored. The rule describes the maximum time for an active backup mode for a datafile until a WARN or CRIT is generated.
If the last checkpoint time is in the future the check generates a WARN and is displaying an information to check the time on the host system.
Important Information There is no checkpoint created if a database is in backup mode. It is expected, that the checkpoint time could also reach a configured limit when a backup is running! This is not the case for Backups with RMAN.
This check needs the Checkmk
mk_oracle-plugin installed in the agent. Please refer to the online documentation for how to install that plugin.
The SID of the database in uppercase (as appearing in the process name of the pmon_... process).
One service is created for each runnning database.