Re: rman backup slow

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Sun, 1 Feb 2009 16:33:33 -0800 (PST)
Message-ID: <816410.23775.qm_at_web38907.mail.mud.yahoo.com>


Tracing is a good idea. You could also do a 10046 trace. I like to use logon triggers to enable 10046 traces.

 Robert G. Freeman
Author:
OCP: Oracle Database 11g Administrator Certified Professional Study Guide (Sybex)
Oracle Database 11g New Features (Oracle Press)
Portable DBA: Oracle  (Oracle Press)
Oracle Database 10g New Features (Oracle Press)
Oracle9i RMAN Backup and Recovery (Oracle Press)
Oracle9i New Features (Oracle Press)
Other various titles out of print now...
Blog: http://robertgfreeman.blogspot.com 
The LDS Church is looking for DBA's. You do have to be a Church member in
good standing. A lot of kind people write me, concerned I may be breaking
the law by saying you have to be a Church member. It's legal I promise! :-)




________________________________
From: Jared Still <jkstill_at_gmail.com>
To: p4cldba_at_gmail.com
Cc: Mark W. Farnham <mwf_at_rsiz.com>; robertgfreeman_at_yahoo.com; ORACLE-L <oracle-l@freelists.org>
Sent: Sunday, February 1, 2009 4:09:07 PM
Subject: Re: rman backup slow



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 - 18:33:33 CST

Original text of this message