Howto check whether backups of noncdb are taken over to multitenant using dbms_pdb.exportrmanbackup

Jul 29, 2022 2:04PM

Hi,

we are running oracle databases in version 19.15.0.0 on oracle linux 8.6.

Few of them have a physical standby. So backups are taken on standby side.

Actually we are in transition to multitenant. So we tried to take over backups of noncdb to multitenant using procedure dbms_pdb.exportrmanbackup().

First we ran change + crosscheck to make backups known to primary. After that "list backup" shows all backups. So far so good.

Before migrating we checked whether the backups are really written to dictionary with the command "select * from RPP$X$KCCBP;"

But only these backups were shown taken before change + crosscheck.

Database Backup and Recovery (MOSC)