Re: How many days of RMAN backup ?

I'm not aware of a "ready to shoot" command/query to get the information.

You can however do a "list backup"
Afaik this is in chronological order of the backups.

Before listing the backups you can "crosscheck backup" and "delete expired" Do not use "delete obsolete", since the backup pieces are apperantly there, en so thery are usable for restore and recovery.

Best Regards,
Martijn Bos

On Mon, Dec 05, 2011 at 11:22:10AM +0100, przemolicc_at_poczta.fm wrote:
>
> Hi folks,
>
> how can I check using RMAN the oldest completed but still stored RMAN backup
> which can be used to recovery the whole database ?
>
> Regards
> Przemyslaw Bak (przemol)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l