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: http://shishirtekade.blogspot.com
  • 2. Re: error message
    Jos van den Oord Newbie
    Currently Being Moderated
    Hi

    First
    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;


    Cheers,

    Jos van den Oord
    Blog : [Joords Oracle DBA blog|Joordsblog.vandenoord.eu]
    Company : [ Transfer-solutions.com|http://www.transfer-solutions.com/]

Legend

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