Re: Finding what have not been backed up in RMAN

On Wed, 23 Jul 2003 22:39:37 -0400, Forte Agent <1443131_at_usenetplanet.com> 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.
>
>

It doesn't exist

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jul 23 2003 - 22:47:39 CDT