Errors Ora-00202, Ora-27091 and Ora-27069 Appear in the alert log File-344764.1

最新推荐文章于 2021-11-15 15:28:52 发布

cuilian2013

最新推荐文章于 2021-11-15 15:28:52 发布

阅读量92

点赞数

Errors Ora-00202, Ora-27091 and Ora-27069 Appear in the alert log File [ID 344764.1]

In this Document
Symptoms
Cause
Solution
References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.3 and later [Release: 10.1 and later ]
Information in this document applies to any platform.
***Checked for relevance on 17-Nov-2010***

Symptoms

The following message appears in the alert log file :

Errors in file /oracle/admin/prod/bdump/prod1_mmon_527116.trc:
ORA-00202: controlfile: '/oracle/oradata/prod/control01.ctl'
ORA-27091: unable to queue I/O
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 3354
Additional information: 1
Additional information: 1993

Cause

This is explained in Bug 3408013 - ORA-27069 skgfdisp Attempt To Do I/O Beyond The Range Of The File.

Solution

These entries are harmless and fixing this will require extensive code changes and hence is not feasible to fix.

Theses messages can be ignored without no problem.

To improve I/O processing on controlfile please do the following :

1- Look for and solve any hardware issue by checking errors in "/var/log/messages" file.
2- Reduce the I/O on the controlfile by making sure we do not switch logs in less than 15 minutes.
3- Check that there is no RMAN activity during periods of peak processing.
4- Move the controlfile from a location where there is already heavy I/O to a less busy mount point.