SELECT 'Database Backup' "Backup Type", TRUNC(SYSDATE-MIN(last_backup_time),1) "Last Backup (days)" FROM (SELECT fileno, MAX(backup_time) last_backup_time FROM (SELECT bd.FILE# fileno, MAX(bd.completion_time) backup_time FROM v$backup_datafile bd, v$datafile d WHERE bd.FILE# = d.FILE# GROUP BY bd.FILE# UNION ALL SELECT FILE# fileno, creation_time FROM v$datafile UNION ALL SELECT 0 fileno, MAX(completion_time) FROM v$backup_datafile WHERE FILE# = 0) GROUP BY fileno) UNION ALL SELECT 'Archivelog Backup', TRUNC(sysdate-MAX(next_time),1) FROM v$backup_redolog;