This discussion is archived
2 Replies Latest reply: Feb 28, 2013 11:16 PM by Jos van den Oord RSS

error message

993456 Newbie
Currently Being Moderated
hello all I have would like to know how to solve problem please

ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/U01/edw2p/system01.dbf
  • 1. Re: error message
    ShishirTekadeR Explorer
    Currently Being Moderated
    shut immediate;

    startup mount

    recover database;

    alter database open;

    Best Regards,
    Shishir Tekade.
    My Blog:
  • 2. Re: error message
    Jos van den Oord Newbie
    Currently Being Moderated

    startup mount
    recover database until cancel;
    or recover database until time 'YYYY-MM-DD:HH24:MI:SS'
    or recover database until change <scn>

    alter database open [no]resetlogs;


    Jos van den Oord
    Blog : [Joords Oracle DBA blog|]
    Company : [|]


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