2 Replies Latest reply: Feb 21, 2013 11:26 PM by Hemant K Chitale RSS

    ORA-16145: archival for thread# 1 sequence# 1424 in progress

    844001
      Dear All,

      I am configuring data guard between primary and DR databases. After giving "recover standby database" command it is display following error.


      SQL> recover standby database;
      ORA-00279: change 93766011 generated at 02/22/2013 00:30:05 needed for thread 1
      ORA-00289: suggestion :
      /u01/app/oracle/oradata/EGXTDR/archives/1_1424_805147492.arc
      ORA-00280: change 93766011 for thread 1 is in sequence #1424


      Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
      auto
      ORA-16145: archival for thread# 1 sequence# 1424 in progress


      This is the already applied log file sequence:

      SQL> select max(sequence#) from v$archived_log where applied='YES';

      MAX(SEQUENCE#)
      --------------
      1423

      I have checked archive log path and found frequently copying archive logs from sequence# 1424 and later to the physical path.
      I think this is the reason for "ORA-16145: archival for thread# 1 sequence# 1424 in progress" error.

      Please anyone advice why this continuous copying same archive logs from primary to DR.

      Thank you in advance.