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 to Note: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.
相关文章
- 11-17js放到head中失效的原因与解决方法
- 11-17div之间有间隙以及img和div之间有间隙的原因及解决方法
- 11-17与大家分享一下,在workerman开发中遇到的问题与解决方法
- 11-17Ansys采用后处理list Rusult输出位移时负号原因导致不能分列的python解决方法
- 11-17Httpservlet cannot be resolved to a type的原因与解决方法
- 11-17配置WebSite的IIS时遇到的问题与解决方法
- 11-17关于checkbox与文字混排无法对齐的解决方法
- 11-17esp8266烧录失败的原因与解决办法
- 11-17RPE隆起的几个原因(中渗、中浆、CNV、干湿性AMD)与相关饮食
- 11-17spring定时任务执行两次的原因与解决方法