Re: Listing successfull RMAN backups from RC
Date: Fri, 20 Jun 2008 04:33:48 -0700 (PDT)
On Jun 10, 4:37 am, wagen..._at_yahoo.com wrote:
> Oracle10g 10.2.0.1 (32 bit) - Recovery Catalog version
> Oracle10g 10.2.0.2 (64 bit) - target database version
> RHEL AS 4.4
> I have a requirement to query the RECOVERY CATALOG schema DIRECTLY and
> determine the LAST SUCCESSFUL FULL DB backup. I tried to query the
> views, but have been unsuccessful so far.
> select DB_ID,BACKUP_TYPE,INCREMENTAL_LEVEL,PIECES,COMPLETION_TIME from
> rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by
> The problem with the above query is that it lists only the successful
> backsets. I need to find out if all the backupsets for the entire full
> db backup was successful.
> Appreciate any pointers on how to do this.
Try using our application Sifobo Enterprise Manager for Oracle. Check http://www.sifobo.com. Received on Fri Jun 20 2008 - 06:33:48 CDT