Re: rman backup slow

From: Fuad Arshad <fuadar_at_yahoo.com>
Date: Fri, 30 Jan 2009 08:00:24 -0800 (PST)
Message-ID: <184656.35359.qm_at_web82102.mail.mud.yahoo.com>

Can you provide more info
Is your backup going to tape or to disk how are the filesets setup and are you using a 3rd party mml

Fuad

On Jan 30, 2009, at 1:10, Prasad <p4cldba_at_gmail.com> wrote:

All,

we have a 170G db on 9.2.0.7(solaris 9) . and I see that it currently is taking nearly 10 hour+ to do a rman backup . when I see this in grid control I see the rman session keeps waiting on this sql .

SELECT TO_CHAR(SYSDATE,:"SYS_B_0",:"SYS_B_1"),TO_CHAR(SYSDATE,:"SYS_B_2",:"SYS_B_3"), TO_CHAR(SYSDATE,:"SYS_B_4",:"SYS_B_5") FROM X$DUAL anyone has any similar situation . appreciate any suggestion.

Thanks in advance

thanks
Prasad

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jan 30 2009 - 10:00:24 CST