How to check every database within an Oracle Database have backup / or have backup scheme.

We are implementation backup verification as a part of the system compliance. A DB server would be declared non-compliance if the last backup time have exceed 1 week or not exist.

This is what we have done on MSSQL.

MSSQL check backup

SELECT     d.name,     bk.is_password_protected,     bk.is_damaged,     CAST (bk.backup_finish_date as smalldatetime) as last_backup,     DATEDIFF(MINUTE, bk.backup_start_date,bk.backup_finish_date) as TimeTaken_min,     CASE bk.[type]       WHEN 'D' THEN 'Full'       WHEN 'I' THEN 'Differential'       WHEN 'L' THEN 'Transaction Log'     END AS BackupType,     bk.recovery_model,     m.physical_device_name