Data File Suffered Media Failure: Database In Noarchivelog Mode Ora-01242 (Doc ID 269329.1)

Last updated on OCTOBER 27, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 7.0.16.0 to 11.2.0.2 - Release: 7.0 to 11.2
Information in this document applies to any platform.
***Checked for relevance on 22-Jun-2011 ***

Symptoms


ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: 'D:\BODBF\USER02BO.DBF'
ORA-01208: data file is an old version - not accessing current version
error 1242 detected in background process


Errors in file d:\bodbf\trace\bdump\bodbLGWR.TRC:
ORA-01110: data file 3: 'D:\BODBF\USER02BO.DBF'
ORA-01114: IO error writing block to file 3 (block # 1)
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 32) The process cannot access the file because it is being used by another process.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms