2 Replies Latest reply: May 14, 2012 10:10 AM by Talip Hakan Ozturk RSS

    unable to perform media recovery because of missing archive log

    venkat vankayala
      Hello ,

      I am restoring database using old rman backup , during the recovery point i am facing below errors , i do not have any archive log file the media recovery is looking . Is there any way that i can open the database using until scn or until sequence ( i tried both which did not go thru ) . Please suggest

      RMAN> recover database;

      Starting recover at 03-MAY-12
      using channel ORA_DISK_1
      using channel ORA_DISK_2
      using channel ORA_DISK_3
      using channel ORA_DISK_4
      using channel ORA_DISK_5
      using channel ORA_DISK_6
      using channel ORA_DISK_7
      using channel ORA_DISK_8

      starting media recovery

      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of recover command at 05/03/2012 16:30:08
      RMAN-06053: unable to perform media recovery because of missing log
      RMAN-06025: no backup of archived log for thread 1 with sequence 10 and starting SCN of 259735916381 found to restore

      Thanks
      Venkat
        • 1. Re: unable to perform media recovery because of missing archive log
          user503699
          venkat vankayala wrote:
          Hello ,

          I am restoring database using old rman backup , during the recovery point i am facing below errors , i do not have any archive log file the media recovery is looking . Is there any way that i can open the database using until scn or until sequence ( i tried both which did not go thru ) . Please suggest

          RMAN> recover database;

          Starting recover at 03-MAY-12
          using channel ORA_DISK_1
          using channel ORA_DISK_2
          using channel ORA_DISK_3
          using channel ORA_DISK_4
          using channel ORA_DISK_5
          using channel ORA_DISK_6
          using channel ORA_DISK_7
          using channel ORA_DISK_8

          starting media recovery

          RMAN-00571: ===========================================================
          RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
          RMAN-00571: ===========================================================
          RMAN-03002: failure of recover command at 05/03/2012 16:30:08
          RMAN-06053: unable to perform media recovery because of missing log
          RMAN-06025: no backup of archived log for thread 1 with sequence 10 and starting SCN of 259735916381 found to restore
          You may want to do it in a RMAN block as follows:
          RUN 
          {
            SET UNTIL SEQUENCE 10;
            RECOVER DATABASE ;
          }
          If above is successful, you will need to open database using RESETLOGS option.
          • 2. Re: unable to perform media recovery because of missing archive log
            Talip Hakan Ozturk
            You need to restore & recover database until archive log sequence 10


            $ sqlplus "/ as sysdba"
            SQL> shutdown abort;
            SQL> startup mount;
            $ rman target
            RMAN> restore database until sequence 10;
            RMAN> recover database until sequence 10;
            SQL> alter database open resetlogs;

            http://taliphakanozturken.wordpress.com/2011/05/26/rman-data-recovery-methods/


            Talip Hakan Ozturk
            http://taliphakanozturken.wordpress.com/