Good script for getting missing backup information using SQL and RMAN repository

Here is another script that I have created to get "good" information about backups. It will look at each individual file and flag them if they have not been backed up at all for the past 2 days or hasn't had a level 0 backup in the past 8 days (at the file level). Because of this, you get the "full" picture of your backups, at the "file" level, not at the backupset level, which can be misleading.

Since the RMAN base tables changed slightly from 10g to 11g (to get to work with 10g, change all occurrences of "reset_time" to "cf_create_time"), this particular script works with the 11g repository (no subrepositories). You should be able to run this as is.