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 9.2.0.2 (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

                    

FILE#ONLINEONLINE_STATUSCHANGE#TIME
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

Legend

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