ORA-1242, ORA-1122, ORA-1110 & ORA-1208 Errors Occurring Intermittently

(Doc ID 471280.1)

APPLIES TO:

Oracle Server - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 23-Jul-2012***

SYMPTOMS

You encounter the following errors being signaled in the alert log periodically:

ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode 
ORA-01122: database file %d failed verification check 
ORA-01110: data file %d: '%s' 
ORA-01208: data file is an old version - not accessing current version 

The data file specified however stays on-line and available so no apparent corruption exists, and no I/O errors are encountered on the underlying disk.

CAUSE

This problem can occur when running a database in NOARCHIVELOG mode due to heavy disk I/O usage such that I/O performance is impacted, for example when redo log switches are occurring too frequently, such that the control file gets updated with the latest checkpoint scn, but the data file is then accessed prior to its header being updated with the same checkpoint scn information, and so Oracle reports the ORA-1208 error as the data file is older than listed in the control file.  Subsequently the data file header is updated and so can be accessed normally with no corruption having occurred.

SOLUTION

The solution here is to resolve the underlying disk I/O performance issue.  If this is occurring due to redo log switches occurring too quickly, i.e. a few seconds apart, then refer toNote:147468.1 on how to tune checkpoint operations and in particular section 4 relating to correct redo log file sizing (see Note:1038851.6) to resolve the problem.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15747463/viewspace-767429/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15747463/viewspace-767429/