My Oracle Support Banner

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

Last updated on DECEMBER 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 7.0.16.0 to 11.2.0.2 [Release 7.0 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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: '<path>\USERS01.DBF'
ORA-01208: data file is an old version - not accessing current version
error 1242 detected in background process

 

Errors in file <path>\trace\bdump\<SID>LGWR.TRC:
ORA-01110: data file 3: '<path>\USER0S01.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

To view full details, 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 a vibrant support community of peers and Oracle experts.