Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query RMAN catalog

user2593665Mar 11 2009 — edited Mar 22 2009

We have databases ranging from 8i to 10g using catalog db (10g) for backups. RMAN backup jobs are run from each database server and we get the output as an email notification. I want to write a query/view that should be run from catalog database and provide information like DB Name, Start Time, End Time and Elapsed Time, most importantly backup status. The existing RMAN catalog views (ex: RC_RMAN_BACKUP_JOB_DETAILS) provide information on 10g databases only. Is there a way to put together all the backup information including 8i,9i database as well?

Thanks in advance..

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 19 2009

Added on Mar 11 2009

#performance-availability, #recovery-manager-rman

1 comment

1,364 views