Re: RMAN 'delete obsolete' command takes ages

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Mon, 12 Jan 2009 12:49:31 +0000 (UTC)
Message-ID: <gkfe8r$lk6$1_at_solani.org>

On Mon, 12 Jan 2009 09:16:35 +0000, Ian Chard wrote:

> On 09/01/09 17:25, Steve Howard wrote:

>> 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.
>> 
>> select inst_id,event,seconds_in_wait from gv$session where program like
>> 'rman%';
>> 
>> What does that return?

>
> After waiting for a few minutes, that query gives:
>
> 1 SQL*Net message from client 201
> 1 SQL*Net message from client 204
> 1 Backup: sbtinfo2 198
> 1 SQL*Net message from client 201
>
> After ten minutes the same four entries are returned, but with larger
> seconds_in_wait values.
>
> Does this tell us anything useful?
>
> Thanks for any help
> - Ian

Yes it does. RMAN is waiting for a reply from your backup software and is not getting it. The MML layer is not properly configured. What backup software are you using? NetBackup? NetWorker? Tivoli? Oracle Secure Backup?

-- 
Mladen Gogala
http://mgogala.freehostia.com

Received on Mon Jan 12 2009 - 06:49:31 CST