Writing sql script to Find All Databases Without A Recent Backup oracle 19c
I would like to use the rman.rc_rman_backup_job_details table in order to report on all databases without a recent backup.
I am unable to develop the correct logic to list only databases without a backup in 24hrs in my report using the rman.rc_rman_backup_job_details table. I would like to include the database and start_time in my report used for confirmation.
Anyone have any suggestions on logic that will work using this table?