Database Administration (MOSC)

MOSC Banner

ORA-00376&ORA-01110 DATAFILES cannot be read at this time.

edited Aug 5, 2014 10:32AM in Database Administration (MOSC) 4 commentsAnswered ✓

hello all,

I need  a help.

I have Oracle database 10.2 runing on redhat enterprise linux and I have this error when  run INSERT querry on a table. the error is:

Error at line 1

ORA-00376: fichier 79 ne peut être lu à cette heure

ORA-01110: fichier de données 79 : '/data5/oradata/mapict_mois_encours/mapict_encours_05.dbf'

the database run on noarchivelog mode and has no valid backup.

physically i don't find mapict_encours_05.mdf.

I create another datafile mapict_encours_04.mdf but the error still be the same.

see the output of this querry:

select status, enabled from v$datafile where file#=79

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center