Re: rman backup slow

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 1 Feb 2009 15:09:07 -0800
Message-ID: <bf46380902011509n1902e23by1daca105cf0254e6_at_mail.gmail.com>

On Sun, Feb 1, 2009 at 2:10 PM, Prasad <p4cldba_at_gmail.com> wrote:

> I did a level 12 trace . and here is the last 5% backup . I see there are
> so many sleeping for 10 sec wait .not very sure how to proceed from here :)
>
>
>

You may find RMAN tracing helpful.

There are 2 kinds that I am aware of, command line and channel.

The output from each is different.

It may or may not be helpful.

I've only used it occasionally myself, and have seen little published about it.

Command line:

$OH/bin/rman … debug trace "trace file name"

Channel:

Trace and debug from levels 1-6, possibly higher.

configure channel

device type 'sbt'

parms="BLKSIZE=1048576,SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/mnt/rsysdevdb/bkup_2/ts03)"

maxopenfiles 4

trace 6 debug 6;

allocate channel

device type 'sbt'

parms="BLKSIZE=1048576,SBT_LIBRARY=oracle.disksbt,ENV=(BACKUP_DIR=/mnt/rsysdevdb/bkup_2/ts03)"

maxopenfiles 4

trace 6 debug 6;

Jared

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

Received on Sun Feb 01 2009 - 17:09:07 CST