ORA-01242: data file suffered media failure: database in
NOARCHIVELOG mode



ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode..

Answer / guest

Cause: The database is in NOARCHIVELOG mode and a database
file was detected as inaccessible due to media failure.

Action: Restore accessibility to the file mentioned in the
error stack and restart the instance.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

SQL*Loader-00277: Local file specification overrides global file specification.

1 Answers  


ORA-09351: Windows 32-bit Two-Task driver unable to allocate shared memory

1 Answers  


AMD-00100: not found: string "string"

1 Answers   Wipro,


ORA-10633: No space found in the segment

1 Answers  


PCC-02206: Host variables are not permitted within a DDL statement

1 Answers  


ORA-24271: translation type must be either T, S or M

1 Answers  


TNS-00257: Number of Successful Requests : number

1 Answers  


ORA-02239: there are objects which reference this sequence

1 Answers  


LFI-00140: Invalid option string were specified on input-output file.

1 Answers  


TNS-12537: TNS:connection closed

1 Answers   IBM,


NNL-00307: Server checkpointing its cache

1 Answers  


IMP-00072: Warning: The object table's object identifier is invalid.

1 Answers  


Categories