3 Replies Latest reply: Sep 29, 2013 2:16 PM by Baris Yildirim RSS

    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

        • 1. Re: unable to find archived log
          Hemant K Chitale

          Check the alert.log file for the instance and find out when sequence=545  was generated.  Was any tablespace set to READ ONLY or any Datafile taken OFFLINE ?

           

          Hemant K Chitale

          • 2. Re: unable to find archived log
            Javier Francisco Ruiz

            They way you are trying to recover will try to recover up to the last know SCN. Try to do a point in time recover up to a few minutes before the database was shutdown or crashed.

             

            Try something like this

             

            run{

            set until time "to_date('2013-09-11:00:00:00', 'yyyy-mm-dd:hh24:mi:ss')";

            restore spfile from autobackup;

            restore controlfile from autobackup;

            shutdown immediate;

            startup mount;

            restore database;

            RECOVER DATABASE;

            ALTER DATABASE OPEN RESETLOGS;

            }

            • 3. Re: unable to find archived log
              Baris Yildirim

              Hi,

              There are many archived logs between 545 and 2461.

              Check your tablespaces' nologging and logging attributes.

              Check your backup, it includes all the latest version of the datafiles.

               

              Best Regards

              Baris