Re: RMAN 'delete obsolete' command takes ages
Date: Fri, 9 Jan 2009 09:25:37 -0800 (PST)
On Jan 9, 10:25 am, Ian Chard <ian.ch..._at_sers.ox.ac.uk> wrote:
> 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