This discussion is archived
3 Replies Latest reply: Nov 4, 2012 6:29 PM by Srini Chavali-Oracle RSS

How to fix ORA-01113: file 1 needs media recovery.

689067 Newbie
Currently Being Moderated
Hi

I am not dba. On my Laptop (Windows Home Premium Edition) I have installed Oracle 11g XE express edition. The db was running fine. Last week I accidently reboot the laptop while the db was running. I do not have back up.

SQL> startup
ORACLE instance started.

Total System Global Area 1071333376 bytes
Fixed Size 1388352 bytes
Variable Size 801112256 bytes
Database Buffers 264241152 bytes
Redo Buffers 4591616 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'


Please help me.

Thanks
  • 1. Re: How to fix ORA-01113: file 1 needs media recovery.
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    First, Oracle software is not certified/supported on any Home versions of Windows - http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm#BABHICJH

    Since you are using an unsupported version of the software, things may or may not work as advertised.

    Second, if all you did was to reboot the laptop with the database up and running (and nothing else), then when you restart the laptop and restart the database, the database will recover automatically without you even knowing about it. The fact that you are running into this error indicates you are not telling us the whole story ;-)

    HTH
    Srini
  • 2. Re: How to fix ORA-01113: file 1 needs media recovery.
    689067 Newbie
    Currently Being Moderated
    Hi Srini

    Thanks for your input. This is the true story. See log from screen. Please let me know how to fix this.

    SQL> startup;
    ORACLE instance started.

    Total System Global Area 1071333376 bytes
    Fixed Size 1388352 bytes
    Variable Size 801112256 bytes
    Database Buffers 264241152 bytes
    Redo Buffers 4591616 bytes
    Database mounted.
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


    SQL> ALTER DATABASE OPEN RESETLOGS;
    ALTER DATABASE OPEN RESETLOGS
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF'
  • 3. Re: How to fix ORA-01113: file 1 needs media recovery.
    Srini Chavali-Oracle Oracle ACE Director
    Currently Being Moderated
    What you have described is not normal - pl post the last 300 lines from the database alert log file. Is the database in archivelog mode ? Do you have any backups ?

    Re: Flash Recovery ->SYSTEM.DBF

    location of alert log in 11g
    http://docs.oracle.com/cd/E17781_01/server.112/e18804/backrest.htm#ADMQS283
    http://docs.oracle.com/cd/E17781_01/server.112/e18804/backrest.htm#ADMQS285

    HTH
    Srini

Legend

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