Re: RMAN 'delete obsolete' command takes ages
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Fri, 9 Jan 2009 07:31:05 -0800 (PST)
Message-ID: <2a27298d-decd-4a54-bc1b-b118fe817d3d_at_q36g2000vbn.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
Date: Fri, 9 Jan 2009 07:31:05 -0800 (PST)
Message-ID: <2a27298d-decd-4a54-bc1b-b118fe817d3d_at_q36g2000vbn.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
Not my area of expertise but are the files being deleted on tape by any chance?
- Mark D Powell --