6 Replies Latest reply: Jun 27, 2013 2:20 AM by saratpvv RSS

    Oracle error ORA-00376 while trying to query applications

    tbharathi


      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