Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: RMAN hangs after 10.2 upgrade

RE: RMAN hangs after 10.2 upgrade

From: Orysia Husak <Orysia.Husak_at_apollogrp.edu>
Date: Fri, 2 Mar 2007 12:50:38 -0700
Message-ID: <9EE01EDE55E32A48BC559180056C9691013E400B@AMSGEV22.apollogrp.edu>


Yes, the control files were recreated in the same locations.  

Orysia Husak

Sr. Oracle DBA - Classroom Applications Hosting

University of Phoenix/ Apollo Group, Inc.

Office: 602-546-6934

Mobile: 602-377-8586

orysia.husak_at_apollogrp.edu


From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Friday, March 02, 2007 12:32 PM
To: Orysia Husak
Cc: oramail_at_guidancetech.com; oracle-l_at_freelists.org Subject: Re: RMAN hangs after 10.2 upgrade  

Were the control files recreated in the same locations?

A 10046 trace may have revealed some problems.

On 3/2/07, Orysia Husak < Orysia.Husak_at_apollogrp.edu <mailto:Orysia.Husak_at_apollogrp.edu> > wrote:

Our control files were 24M before and after recreating them.    

Orysia Husak

Sr. Oracle DBA - Classroom Applications Hosting

University of Phoenix/ Apollo Group, Inc.

Office: 602-546-6934

Mobile : 602-377-8586

orysia.husak_at_apollogrp.edu


From: Jared Still [mailto:jkstill_at_gmail.com] Sent: Friday, March 02, 2007 12:12 PM
To: Orysia Husak
Cc: oramail_at_guidancetech.com; oracle-l_at_freelists.org Subject: Re: RMAN hangs after 10.2 upgrade  

On 3/2/07, Orysia Husak <Orysia.Husak_at_apollogrp.edu> wrote:

        When we upgraded from 10.2.0.1 to 10.2.0.2 our rman backups started taking significantly longer. We were seeing control file sequential read waits. Once we recreated the control files, the rman backups speeded up again. On databases that we created at 10.2.0.2, we didn't see this bizarre behavior in the rman backups.

Do you know how large the control files were prior to recreating them?

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 02 2007 - 13:50:38 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US