Re: RMAN hangs after 10.2 upgrade
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: "Orysia Husak" <Orysia.Husak@xxxxxxxxxxxxx>
- Date: Fri, 2 Mar 2007 13:22:45 -0800
On 3/2/07, Orysia Husak <Orysia.Husak@xxxxxxxxxxxxx> 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
Other related posts:
