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>
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-lReceived on Sun Feb 01 2009 - 18:33:33 CST