This discussion is archived
6 Replies Latest reply: Jun 27, 2013 12:20 AM by saratpvv RSS

Oracle error ORA-00376 while trying to query applications

tbharathi Newbie
Currently Being Moderated

Details of the problem


User encountered form error . when asked for details found this error in details screenshot.


ORA-00376: file 36 cannot be read at this time
ORA-01110: data file 36 '.........................../APX01.dbf'


Database type : Production on windows

Archive log mode= Yes.

Version is (9i)


Did some checks like file existence. Physical file exists in the said path.  But data file status shows as "RECOVER".


queried the v$recover_file


36OFFLINEOFFLINE462596859106/23/2013 15:36:52


We are not using RMAN . what is the best way to recover this file ?


when system is operational, Can I use from SQL> Recover datafile 36;


Thanks in advance for help


  • Correct Answers - 10 points
  • Helpful Answers - 5 points