This discussion is archived
2 Replies Latest reply: Feb 7, 2013 5:38 PM by Hemant K Chitale RSS

RMAN-Delete expired is running slow (performance issue)

Cherrish Explorer
Currently Being Moderated
The target database and catalog database are on Oracle Enteprise Edition 11.2.0.3. 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?

Thanks
Cherrish Vaidiyan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points