The target database and catalog database are on Oracle Enteprise Edition 18.104.22.168. 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?
In general, running DELETEs through an MML is slow because the MML has to update it's catalog as well (i.e. besides Oracle updating it's catalog).
However, as pointed out, there may be product-specific (HP DataProtector) performance "bugs" as well.
Hemant K Chitale