 | |
Listing successfull RMAN backups from RC
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Listing successfull RMAN backups from RC -
06-09-2008
, 01:37 PM
#2
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
#3
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
#4
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
#5
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
#6
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
#7
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
#8
| |||
| |||
|
|
Hi, 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,COMPLET ION_TIME from rc_backup_set where STATUS='A' and BACKUP_TYPE='D' order by COMPLETION_TIME; 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. Thanks wagen |
Try using our application Sifobo Enterprise Manager for Oracle. Check
http://www.sifobo.com.
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.