This discussion is archived
2 Replies Latest reply: Jan 16, 2013 1:13 AM by Christian Erlinger RSS

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

ChakravarthyDBA Newbie
Currently Being Moderated
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?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points