Hi, I'm looking for some help.
We are experiencing an ORA-1116 error about once every week and do not
know
what is causing it. This error states that oracle cannot find one of
the
datafiles. When the operation is attempted a second time, it goes
through
OK. We are running Oracle version 7.2.2.3 on HP-UX 10.01 with
mirroring.
The installation is about 9 months old at this time. Oracle Support
recommends that we reinstall the entire database. The customer would
rather not reinstall. We have 6 other sites running the same
configuration
with the exception of the mirroring. These sites have not experienced
this
error. We have also seen this error one other time on an HP-UX 9.04
system
running 7.2.2.3 without mirroring on the operating system. As a
result, we
are not sure that it is related to mirroring. Has anyone come across a
correlation between this error and mirroring. Does anyone have
experience
with an occasional ORA-1116 error? Any suggestions would be helpful.
Thanks in advance.
Please respond to: dale_at_wyndgate.com