0 Replies Latest reply: Apr 19, 2013 11:16 AM by 954857 RSS

    file 1 needs media recovery after restore from COLD backup

    954857
      Hi all,

      This in an Oracle 11.2.0.3.0 64 bits

      After a restore from cold backup I get this when trying to start DB:

      SQL> alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-01113: file 1 needs media recovery
      ORA-01110: data file 1: '/oracle1/oradata/ardlpdev/system_01.dbf'

      Autobackup of controlfile is off, and DB is in NOARCHIVELOG (that's why I have a cold backup).
      What´s the problem?

      I started the process by doing this:

      restore database from tag 'TAGXXXXXXXXX';

      Should I bring an old control file before starting the restore?
      I don't have it and it seems it was not included in cold backup.

      Thanks

      ********
      Solved, just restore control file from rman backup and DB opened.
      ********

      Edited by: 951854 on 19-abr-2013 9:15