3 Replies Latest reply on Sep 29, 2013 7:16 PM by Baris Yildirim

    unable to find archived log

    Habib

      Hi

       

      I am restoring a hot backup taken through RMAN using following commands:

       

       

      configure controlfile autobackup on;

      BACKUP DATABASE ;

      BACKUP ARCHIVELOG ALL DELETE INPUT;

       

       

       

       

      Now I am going to restore that using following commands:

       

      restore spfile from autobackup;

      restore controlfile from autobackup;

      shutdown immediate;

      startup mount;

      restore database;

      RECOVER DATABASE;

      ALTER DATABASE OPEN RESETLOGS;

       

       

      But it goes fine till restore database. At recover database I get following errors:

       

       

      archived log for thread 1 with sequence 2461 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_1_8fbs9bvt_.log

      archived log for thread 1 with sequence 2462 is already on disk as file /u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_2_8fbs9chb_.log

      unable to find archived log

      archived log thread=1 sequence=545

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of recover command at 09/11/2013 20:41:43

      RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 545 and starting SCN of 25891726

       

       

      I have checked the backup folder and there are only empty date wise folders under archivedlog folders.

       

       

      If I write RMAN> ALTER DATABASE OPEN RESETLOGS; I get:

       

       

       

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of alter db command at 09/11/2013 20:43:01

      ORA-01190: control file or data file 1 is from before the last RESETLOGS

      ORA-01110: data file 1: '/u01/app/oracle/oradata/XE/system.dbf'

       

       

      If I write RMAN> recover database until sequence 545; I get

       

      Starting recover at 11-SEP-13

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: SID=695 device type=DISK

       

      starting media recovery

      unable to find archived log

      archived log thread=1 sequence=545

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      RMAN-03002: failure of recover command at 09/11/2013 21:09:34

      RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 545 and starting SCN of 25891726

       

       

       

      I don't mind if some data is lost. Will be really thankful if someone can help me get my database open;

       

      Habib