4 Replies Latest reply: Apr 20, 2013 1:55 AM by Venkateshj RSS

    ORA-01113: file 3 needs media recovery

    Venkateshj
      Hi all,

      My Os is MS Server 2003

      My Oracle Database is 10g

      SQL> alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-01113: file 3 needs media recovery
      ORA-01110: data file 3: 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF'


      SQL> recover datafile 3;
      ORA-00283: recovery session canceled due to errors
      ORA-00322: log 3 of thread 1 is not current copy
      ORA-00312: online log 3 thread 1:
      'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'



      SQL> recover database;
      ORA-00283: recovery session canceled due to errors
      ORA-00322: log 3 of thread 1 is not current copy
      ORA-00312: online log 3 thread 1:
      'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG'


      SQL> select status from v$instance;

      STATUS
      ------------
      MOUNTED

      SQL>


      I don't have cold backup, & my database is in no archivelog mode...

      Is there any possibility to recover my database...

      Thanks in advance...