The target database and catalog database are on Oracle Enteprise Edition 22.214.171.124. We use HP DataProtector 6.11 as the thrid party media manager to manage the tapes. We have a backup retention of 28 days.
We impletemented RMAN for backup almost 3 months ago. We haven't ever run delete expired or delete obsolete.
We did the following today on a small database:
1) Crosscheck backup
2) delete expired;
3) delete obsolete;
We noticed that RMAN is trying to interact with Media Management Layer (HP Data protector) when we give delere expired. So we tried executing the following:
DELETE FORCE BACKUP COMPLETED BEFORE 'SYSDATE-28';
This command is taking time as well. Overall delete expired or delete obsolete is slow. Have anyone else faced similar issue? Could you please suggest any solution?