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!

OEM Backup report using v$RMAN_BACKUP_JOB_DETAILS

3258153Jun 20 2017 — edited Jun 21 2017

I want to create and schedule a backup report in OEM13c.

Oracle says the MGMT$HA_BACKUP view should not be used for backup reports. This view is used internally by Enterprise Manager for metric collections and to display backup information summary on the target's home page.If you need to generate backup reports, please use V$RMAN_BACKUP_JOB_DETAILS. The output from MGMT$HA_BACKUP is inconsistent and can't rely 100%

Has anyone got any insight into how to use V$RMAN_BACKUP_JOB_DETAILS via OEM and produce a single page report like below from all targets in OEM?

Database Backup Report

Server Name	Database Name	Backup Type	Backup Status	Backup Start Time	Backup End Time	Total Backup Time	Backup Device Type	Backup Size
xxx	yyy	zzz

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 18 2017

Added on Jun 20 2017

#performance-availability, #recovery-manager-rman

5 comments

2,215 views