28 Jul 2025 08:16 PM
Can I use the above metric to build a dashboard and alert and if so what would the DQL look like.
Get all databases that are in full recovery mode, filter the transaction log backups only and exclude some database out of the query and send an alert on any database that hasn't had a log backup in the last hour
29 Jul 2025 08:28 AM
Hi,
You should be able to do it if that backup metric has recovery mode as dimension.
Best regards
29 Jul 2025 11:04 AM
Thanks for getting back to me is there a way to filter and alert on any database that hasn't had a backup for say 2 hours. Also I don't see a option for differential backups - only full - transactional - full copy-only
29 Jul 2025 12:59 PM
Hi,
I would say checking metric "com.dynatrace.extension.sql-oracle.backup.time_since", different dimensions are there to apply filters:
Best regards