Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN FULL BACKUP LIST
On Sun, 26 Sep 2004 03:41:32 GMT, Ed Blondin <beach9z_at_yahoo.com>
wrote:
>Is there a way to tell when the last successful full database backup
>occurred. I list backups but I don't see any easy way to figure this
>out. Thanks in advance for your help.
It can be done by querying v$backup and v$backup_set. Don't have the SQL at home though.
-- Sybrand Bakker, Senior Oracle DBAReceived on Sun Sep 26 2004 - 00:09:16 CDT