Select RMAN backup status from PDB

Hi All,

We use Opsview for our monitoring solution, and prior to a recent DB upgrade to 19c Opsview would run a check against V$RMAN_BACKUP_JOB_DETAILS to see if the backup was successful.

With 19c this no longer works as the PDB can't see information for the CDB in V$RMAN_BACKUP_JOB_DETAILS. Is there any other way to gain the status of RMAN backups from within a PDB.

I did consider creating the Opsview DB user in the CDB, but I'm aware that it's not recommended to create application users in the CDB.

The other way around this is to create a script on the DB server that gets the required info, then have Opsview run the script rather than log onto the DB directly.