Skip to Main Content

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

markdba123Feb 24 2026

Hello,

We are running on X8-2 ODA's, linux 7, multitenant, RAC, TDE and Oracle 19.17. Currently we have 100+ databases that we are migrating from 12c (all standalone DB's) to 19c.

Our configuration is a primary ODA and a secondary ODA, where we backup the PDBs.

We backup the root CDB separately and backup each PDB individually with incremental and full backups. In Oracle 12c, I have sql that will report all backups for each database over the last 24 hr. Works great but now I need a similar report for 19c.

Does anyone have suggestions/code that could help me report on the CDB and each PDB backup?

Thank you,
Mark

Comments
Post Details
Added on Feb 24 2026
4 comments
151 views