Re: RMAN hangs after 10.2 upgrade

On 3/2/07, Orysia Husak <Orysia.Husak_at_apollogrp.edu> wrote:
>
> Yes, the control files were recreated in the same locations.
>
>
>

What comes to mind is while the control files may have been recreated in the same logical location, it may not have been the same physical location as previous.

Were any database files moved?

Is the database on a SAN? Any changes to that at the same time?

Something was causing control file sequential read waits, and then the control files are recreated and the waits disappear.

It is impossible to say after the fact if this was directly attributable to the migration to 10.2.0.2.

For instance, the problem may have been mitigated by simply copying the old control files to new copies, deleting the originals and renaming the new ones.

Chalk it up to experience.
Next time you encounter something like that (and don't have a 5 minute deadline ) try experimenting a bit and you may come up with a reasonable cause.

Oracle isn't always to blame.

I realize you are the OP on this thread, but the situations are similar.

Now if there were a 10046 trace, that might go a long way towards pinpointing the problem.

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l