Re: Finding what have not been backed up in RMAN

One solution, but not the best solution is to query the Recovery Catalog directly. RC_DATABASE will list all databases in the Recovery Catalog. RC_DATAFILE will list all database datafiles. RC_BACKUP_DATAFILE can be used to determine when a datafile was backed up. In the end, you'll have to construct your own queries against the Recovery Catalog, which is essentially what the REPORT command does for you. There are shortcomings with this solution. As Tanel pointed out, what happens if the Recovery Catalog has not been synchronized and doesn't know about a datafile? What happens if the backup piece is no longer available (you haven't been crosschecking)?

HTH,
Brian

Forte Agent wrote:
>
> 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.

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"