5 Replies Latest reply: May 17, 2013 3:54 AM by Hemant K Chitale RSS

    RMAN Active Cloning fails with RMAN-06054: missing log file

    Sivaprasad S
      Version Details:

      O.S Version     HP-UX B.11.31 U ia64
      Oracle DB Version     11.2.0.3.0
           Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
      Scenario :

      Using RMAN Active cloning to duplicate a RAC database from Production to Development environment.

      Problem:

      At the end of the cloning the below errors are reported;
      RMAN-00571: ===========================================================
      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
      RMAN-00571: ===========================================================
      RMAN-03002: failure of Duplicate Db command at 05/14/2013 07:03:43
      RMAN-05501: aborting duplication of target database
      RMAN-03015: error occurred in stored script Memory Script
      RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 24751 and starting SCN of 89285945274
       
      RMAN Script used for Active cloning:
      #!/bin/ksh
      #######################################################################
      #
      #######################################################################
      . setdb entDBu
      start_dt=`date +%Y%m%d_%H%M`
      job=`basename $0 ".sh"`
      rman  >> ${job}_${start_dt}.log  2>&1 <<eof
      set echo on;
      
      connect target sys/@DCC&(_O@entDBp1
      connect auxiliary sys/@DCC&(_O@entDBuu
      
      run {
      allocate channel prmy1 type disk;
      allocate auxiliary channel stby1 type disk;
      duplicate target database
       to entDBu
       from active database pfile=/app/oracle/product/11.2.0.3/db/dbs/initentDBu.ora;
        }
      
      show all;
      exit
      eof
      
      end_dt=`date +%Y%m%d_%H%M`
      
      mailx -s "DR RMAN Job: $job done" "dba@siva.com" <<eof2
      started: ${start_dt}
       finish: ${end_dt}
      eof2
      How to prevent the error of
       RMAN-06054: media recovery requesting unknown archived log for thread  with sequence   and starting SCN of  
      while performing the RMAN Active Cloning? I do NOT want to use UNTIL clause.
        • 1. Re: RMAN Active Cloning fails with RMAN-06054: missing log file
          Mahir M. Quluzade
          Hi,

          Did you using log_file_name_convert parameter?

          Can you paste here your /app/oracle/product/11.2.0.3/db/dbs/initentDBu.ora; file content?


          Mahir
          • 2. Re: RMAN Active Cloning fails with RMAN-06054: missing log file
            Sivaprasad S
            PFILE
             *._kghdsidx_count=2
            _ksxp_ping_enable=false
            *.audit_file_dest='/app/oracle/admin/entDB/adump'
            *.audit_trail='none'
            *.cluster_database_instances=2
            *.cluster_database=FALSE
            *.compatible='11.2.0.0.0'
            *.control_file_record_keep_time=35
            #*.control_files='+DG_UAT_DATA_01/entDB/controlfile/current.523.770923377','+DG_UAT_FLASH_02/entDB/controlfile/current.356.770923377'#Restore Controlfile
            *.db_block_size=8192
            *.db_create_file_dest='+DG_UAT_DATA_01'
            *.db_domain='siva'
            *.db_flashback_retention_target=1080
            *.db_name='entDB'
            *.db_recovery_file_dest='+DG_UAT_FLASH_02'
            *.db_recovery_file_dest_size=322122547200
            *.db_securefile='ALWAYS'
            *.deferred_segment_creation=FALSE
            *.diagnostic_dest='/app/oracle'
            *.disk_asynch_io=FALSE
            *.dispatchers='(PROTOCOL=TCP) (SERVICE=entDBuXDB)'
            #entDBu.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbsrvr1.siva.com)(PORT=60000))))'
            #entDBu2.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbsrvr2.siva.com)(PORT=60000))))'
            #entDBu1.local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=dbsrvr1.siva.com)(PORT=60000))))'
            local_listener='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=148.92.53.200)(PORT=60001))))'
            *.memory_target=2147483648
            *.open_cursors=300
            *.processes=1000
            *.recyclebin='OFF'
            #*.remote_listener='dbsrvr-scan..siva.com:60000'
            *.remote_login_passwordfile='exclusive'
            *.sessions=1105
            #entDBu2.instance_number=2
            #entDBu1.instance_number=1
            #entDBu2.thread=2
            #entDBu1.thread=1
            #entDBu2.undo_tablespace='UNDOTBS2'
            #entDBu1.undo_tablespace='UNDOTBS1'
            
             
            Edited by: Sivaprasad S on May 15, 2013 6:40 AM
            • 3. Re: RMAN Active Cloning fails with RMAN-06054: missing log file
              Sivaprasad S
              Referring : http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126

              " ** You cannot use the UNTIL clause when performing active database duplication.
              RMAN chooses a time based on when the online data files have been completely copied, so that the data files can be recovered to a consistent point in time. ** "

              Then such error of RMAN-06054 media recovery requesting unknown archived log for thread %s with sequence %s and starting SCN of %s" occurs.
              • 4. Re: RMAN Active Cloning fails with RMAN-06054: missing log file
                Mahir M. Quluzade
                Sivaprasad S wrote:
                Version Details:

                O.S Version     HP-UX B.11.31 U ia64
                Oracle DB Version     11.2.0.3.0
                     Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
                Scenario :

                Using RMAN Active cloning to duplicate a RAC database from Production to Development environment.

                Problem:

                At the end of the cloning the below errors are reported;
                RMAN-00571: ===========================================================
                RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
                RMAN-00571: ===========================================================
                RMAN-03002: failure of Duplicate Db command at 05/14/2013 07:03:43
                RMAN-05501: aborting duplication of target database
                RMAN-03015: error occurred in stored script Memory Script
                RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 24751 and starting SCN of 89285945274
                RMAN Script used for Active cloning:
                #!/bin/ksh
                #######################################################################
                #
                #######################################################################
                . setdb entDBu
                start_dt=`date +%Y%m%d_%H%M`
                job=`basename $0 ".sh"`
                rman  >> ${job}_${start_dt}.log  2>&1 <<eof
                set echo on;
                
                connect target sys/@DCC&(_O@entDBp1
                connect auxiliary sys/@DCC&(_O@entDBuu
                
                run {
                allocate channel prmy1 type disk;
                allocate auxiliary channel stby1 type disk;
                duplicate target database
                to entDBu
                from active database pfile=/app/oracle/product/11.2.0.3/db/dbs/initentDBu.ora;
                }
                
                show all;
                exit
                eof
                
                end_dt=`date +%Y%m%d_%H%M`
                
                mailx -s "DR RMAN Job: $job done" "dba@siva.com" <<eof2
                started: ${start_dt}
                finish: ${end_dt}
                eof2
                How to prevent the error of
                 RMAN-06054: media recovery requesting unknown archived log for thread  with sequence   and starting SCN of  
                while performing the RMAN Active Cloning? I do NOT want to use UNTIL clause.
                Where UNTIL clause in your script I didn't saw.

                Please try following RMAN script
                DUPLICATE TARGET DATABASE FOR STANDBY 
                  FROM ACTIVE DATABASE
                 SPFILE
                   SET "control_files"="/u01/app/oracle/oradata/stbdbcontrol01.ctl"
                   SET "db_name"="prmdb"
                   SET "db_unique_name"="stbdb"
                   SET "db_file_name_convert"="/u01/app/oracle/oradata/prmdb","/u01/app/oracle/oradata/stbdb"
                   SET "log_file_name_convert"="/u01/app/oracle/oradata/prmdb","/u01/app/oracle/oradata/stbdb"
                   SET "db_recovery_file_dest"="/u01/app/oracle/fra"
                   SET "diagnostic_dest"=/u01/app/oracle"
                   SET "audit_file_dest"="/u01/app/oracle/admin/stbdb/adump"
                PASSWORD FILE
                NOFILENAMECHECK;
                {code}
                
                Please change parameters for your environment. 
                
                
                Regards
                Mahir M. Quluzade                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
                • 5. Re: RMAN Active Cloning fails with RMAN-06054: missing log file
                  Hemant K Chitale
                  Oracle can use the datafiles copy time as the minimum UNTIL time that it needs for recovery. However, this requires the archivelog from the primary. I would expect Oracle to be intelligent enough to generate an archivelog and ship it over. If it is not doing so, have you tried forcing an archive log (switch logfile or archive log current) at the source ("target") database where redo has to be copied from ?

                  Hemant K Chitale