14 Replies Latest reply: Jul 15, 2014 9:43 AM by BPeaslandDBA RSS

    Archive log format change while copying from production to standby database.

    2713139

      Hi everyone,

       

      i am facing a issue recently, while copying archives from production to standby , i observed that archive log format is changes, while recovery was stopped because archive format has been changed,

       

      both production and standby has same version

      db version: 11.2.0.3.0

       

       

      SQL> show parameter archive_format;

       

       

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- ------------------------------

      log_archive_format                   string     %t_%s_%r.dbf

       

       

      my archive log format in production & standby  is o1_mf_1_8207_9w7w3k9f_.arc 

       

      we copy the archives from production to standby every half an hour  by using shell script

       

      command is rsync -e ssh -Pazv /u01/app/oracle/fast_recovery_area/CDMSP1/archivelog/ oracle@145.12.2.51:/u01/app/oracle/fast_recovery_area/CDMSP1/archivelog/  >> /home/oracle/archivecopy_log/archivecopy_`date '+%Y-%m-%d'`.log

       

      i have checked in standby archivelog location it is showing the same format as there in production

      everything working fine, but while performing recovery in standby it throws error

       

      recover standby database

      (auto)

       

      ORA-00279: change 63336236 generated at 07/14/2014 20:00:01 needed for thread 1

      ORA-00289: suggestion :

      /u01/app/oracle/fast_recovery_area/OCPROD/archivelog/2014_07_14/.o1_mf_1_8207_9w

      7w3k9f_.arc.BKCpHU

      ORA-00280: change 63336236 for thread 1 is in sequence #8207

      ORA-00278: log file

      '/u01/app/oracle/fast_recovery_area/OCPROD/archivelog/2014_07_14/o1_mf_1_8206_9w

      7tc9s4_.arc' no longer needed for this recovery

       

       

      ORA-00283: recovery session canceled due to errors

      ORA-00333: redo log read error block 2048 count 2048

      ORA-01112: media recovery not started

       

       

      as you can see that .arc after it is getting extension of BKCpHU and also a dot before

      .o1_mf_1_8207_9w7w3k9f_.arc.BKCpHU

       

       

       

      because of that extension recovery stopped it, then i applied the archive manually, it works fine. but how to stop this error

       

       

      can you please reply as soon as possible,

       

      thanks in advance

       

       

      Regards,

      sanjay