0 Replies Latest reply on Apr 19, 2013 4:16 PM by 954857

    file 1 needs media recovery after restore from COLD backup

      Hi all,

      This in an Oracle 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.


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

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