This discussion is archived
4 Replies Latest reply: Apr 19, 2013 11:55 PM by Venkateshj RSS

ORA-01113: file 3 needs media recovery

Venkateshj Newbie
Currently Being Moderated
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...

Legend

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