Oracle Database Discussions

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!

RMAN BACKUP REPORT

Raj AruApr 27 2018 — edited May 10 2018

I am Trying to create a Report for RMAN Backup Jobs Status and I need queries to fetch the below outputs.

1. Last successful status of FUll backup.

2. How many backups was not completed successfully from last 7 days with DB name (Full , Incr and Arch)

3. Backups runtime info

I Have Rman Catalog database register with 50 databases and easy way to fetch this details for all databases will be good.

This post has been answered by Byron Fonseca on May 2 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2018

Added on Apr 27 2018

#general-database-discussions

10 comments

2,417 views