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

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


      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:



      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@  >> /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



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

      ORA-00289: suggestion :



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

      ORA-00278: log file


      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





      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