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;