RE: rman allocate channel suddenly taking forever
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Sep 2007 12:03:51 -0400
What version of Oracle was the rman catalog running on and what versions
of Oracle were being backed up to it where this problem exists?
-- Mark D Powell --
Phone (313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of John Hallas
Sent: Wednesday, September 19, 2007 6:47 AM
To: robertgfreeman@xxxxxxxxx;
gcunningham@xxxxxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: rman allocate channel suddenly taking forever
At one site I worked at they had several concurrent catalogs but
generated new ones and switched the backups to use the new catalog and
then removed the old one after a few weeks when the backups past their
retention times.
If the catalog was not switched then had massive enqueue
problems when querying the catalog
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Robert Freeman
Sent: 19 September 2007 03:34
To: gcunningham@xxxxxxxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: rman allocate channel suddenly taking forever
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
________________________________
BJSS Limited, 1st Floor Coronet House, Queen Street, Leeds LS1
2TW.
Registered in England with company number 2777575.
http://www.bjss.co.uk
Other related posts:
