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

    error message

    993456
      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
          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
            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/]