Re: RMAN 'delete obsolete' command takes ages

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Fri, 9 Jan 2009 09:25:37 -0800 (PST)
Message-ID: <d4d18772-4169-4900-a47e-12b26ab0e31c_at_a12g2000pro.googlegroups.com>

On Jan 9, 10:25 am, Ian Chard <ian.ch..._at_sers.ox.ac.uk> 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: ian.ch..._at_sers.ox.ac.uk
> 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