Re: RMAN 'delete obsolete' command takes ages

From: Steve Howard <>
Date: Fri, 9 Jan 2009 09:25:37 -0800 (PST)
Message-ID: <>

On Jan 9, 10:25 am, Ian Chard <> wrote:
> Hi,
> 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:
> Systems and Electronic Resources Service   | T:  80587 / (01865) 280587
> Oxford University Library Services         | F:          (01865) 242287

select inst_id,event,seconds_in_wait from gv$session where program like 'rman%';

What does that return?

If it is control file sequential read, then I have seen this in the past (more than once), and the answer from Oracle is always "recreate the controlfile". Yeah, that's a real option in a 24x7x365 shop. Received on Fri Jan 09 2009 - 11:25:37 CST

Original text of this message