2 Replies Latest reply: Jan 16, 2013 3:13 AM by Christian Erlinger RSS

    current archive log got deleted, how to recover using previous archive log?

    ChakravarthyDBA
      Hi

      My current log sequence #819 and it is got deleted and no choice to get it back and I have previous archived logs with sequences #814 to 818.

      When I starting my database it is showing that use 'MUST USE RESETLOGS OR NORESETLOGS option for database open then I used the command

      SQL> ALTER DATABASE OPEN RESETLOGS;
      ALTER DATABASE OPEN RESETLOGS
      *
      ERROR at line 1:
      ORA-01113: file 1 needs media recovery
      ORA-01110: data file 1: 'E:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSTEM01.DBF'

      SQL> alter database recover;
      alter database recover
      *
      ERROR at line 1:
      ORA-00283: recovery session canceled due to errors
      ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

      SQL> alter database recover using backup controlfile;
      alter database recover using backup controlfile
      *
      ERROR at line 1:
      ORA-00279: change 8433746 generated at 01/15/2013 19:51:59 needed for thread 1
      ORA-00289: suggestion :
      E:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2013_01_16\O1_MF_1_819_

      %U_.ARC
      ORA-00280: change 8433746 for thread 1 is in sequence #819

      now I don't have the archive log with sequence 819, I have recover from 818. please tell me how to do it?