2 Replies Latest reply on Mar 1, 2013 7:16 AM by Jos van den Oord

    error message

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

            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|Joordsblog.vandenoord.eu]
            Company : [ Transfer-solutions.com|http://www.transfer-solutions.com/]