RE: rman allocate channel suddenly taking forever
- From: "Robert Freeman" <robertgfreeman@xxxxxxxxx>
- To: <gcunningham@xxxxxxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 18 Sep 2007 20:34:05 -0600
We are having some major performance problems with our recovery catalogs
these days!!
Contact Oracle and open an SR, there are several bugs open with catalog
performance and degrading performance.
RF
Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints
Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!
BLOG: http://robertgfreeman.blogspot.com/
Sig V1.2
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Gerald Cunningham
Sent: Tuesday, September 18, 2007 12:50 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: rman allocate channel suddenly taking forever
Hi all,
We run an rman level 0 backup of a Dataguard physical target database,
twice a week, to disk. The first thing the job does is allocate 10 disk
channels. This part of the job (the allocate commands) usually takes 40
minutes to a little over an hour. For the last 3 runs of this backup job,
however, the allocate is taking over 9 hours.
I should note that this is a very large database with 10's of thousands of
data files. This is Oracle 9.2.0.7 64-bit on Solaris.
Any suggestions as to what we might look at? What exactly happens
internally during the allocate channel command? My rman catalog db is
generating 3.1 Gb or archive logs during the 9 hours that the allocate
channel commands are running.
Thanks for any help or pointers... we've searched Metalink but came up
with nothing.
Jerry
Other related posts:
