Finding what have not been backed up in RMAN

We are using RMAN to backup our databases. We want to find databases/datafiles that have not been backed up for past ??? days. I know I can execute following in RMAN:
  report need backup days=???;

However, above works only when you are connected to a target database from RMAN. It does not report more than one database, so you have to connect to each and every target database and run above command multiple times. Also, when the target database instance is down, above report does not work.

Is there some way to get list of databases/datafiles that have not been backed up for ??? days, without having to connect to target databases? That is, it should work even if the target databases are down. And it would be good if it reports more than a single database in a single operation. In other words, we are looking for some thing similar to "report need backup days=???" that works without having to connect to target databases. Thank you in advance. Received on Wed Jul 23 2003 - 21:39:37 CDT