RMAN 'delete obsolete' command takes ages

From: Ian Chard <ian.chard_at_sers.ox.ac.uk>
Date: Fri, 09 Jan 2009 15:25:35 +0000
Message-ID: <gk7q9f$kn7$1_at_frank-exchange-of-views.oucs.ox.ac.uk>


I'm running Oracle 10g on RHEL 5.2, backing up with RMAN to Tivoli Storage Manager. When I run 'delete obsolete', it quickly lists what it wants to delete but then just sits there for many tens of minutes, occasionally deleting one.

strace tells me that the rman process is blocked reading from an oracle process, which seems to be doing nothing much. What can I do to find out why this takes so long?

Many thanks for any advice
- Ian (not a DBA, and please don't tell me to hire one!)

Ian Chard, Senior Unix and Network Gorilla | E: ian.chard_at_sers.ox.ac.uk
Systems and Electronic Resources Service   | T:  80587 / (01865) 280587
Oxford University Library Services         | F:          (01865) 242287
Received on Fri Jan 09 2009 - 09:25:35 CST

Original text of this message