3 Replies Latest reply: Aug 15, 2013 5:56 AM by ZARdba RSS

    Standby database keeps falling behind.

    ZARdba

      11.2.0.3 (Primary and Standby)

       

      archive_lag_target                   integer 900

      log_archive_config                   string

      dg_config=(PROD,DR)

      log_archive_dest                     string

       

       

      log_archive_dest_1                   string

      LOCATION=/oracle/archive/PROD VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=PROD


      Hi there,


      I have one primary with one standby datagaurd setup. The standby got 24 hours behind, so we shutdown the standby and re-synced on a storage level, but almost immediately it started lagging behind and two days later it's 20 hours behind again. Please help,


      The archive logs are diffrent sizes as well :


      -rw-r-----    1 oracle   dba      9608466944 Aug  1 02:18 prod-768088995-1-137005.ARC - prod

      -rw-r-----    1 oracle   dba      9608854016 Aug  1 06:26 prod-768088995-1-137055.ARC - DR


      It first fails then succeed applying the logs :

       

         THREAD#  SEQUENCE# APPLIED   COMPLETIO NEXT_TIME

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

               1     136558 NO        30/JUL/13 30/JUL/13

               1     136558 YES       30/JUL/13 30/JUL/13

               1     136559 YES       30/JUL/13 30/JUL/13

               1     136559 NO        30/JUL/13 30/JUL/13

               1     136560 NO        30/JUL/13 30/JUL/13

               1     136560 YES       30/JUL/13 30/JUL/13

               1     136561 NO        30/JUL/13 30/JUL/13

               1     136561 YES       30/JUL/13 30/JUL/13

               1     136562 NO        30/JUL/13 30/JUL/13

               1     136562 YES       30/JUL/13 30/JUL/13

               1     136563 NO        30/JUL/13 30/JUL/13

       

      DR alert log :

       

      Thu Aug 01 05:54:23 2013

      FAL[server, ARC7]: FAL archive failed, see trace file.

      ARCH: FAL archive failed. Archiver continuing

      ORACLE Instance PROD - Archival Error. Archiver continuing.

      Thu Aug 01 05:54:25 2013

      Errors in file /oracle/diag/rdbms/rsaprod/PROD/trace/PROD_nsa2_13894020.trc:

      ORA-19502: write error on file "", block number  (block size=)

      LNS: Failed to archive log 3 thread 1 sequence 137134 (19502)

      Thu Aug 01 05:54:37 2013

      Archived Log entry 309536 added for thread 1 sequence 137134 ID 0xffffffff9138587b dest 1:

      Thu Aug 01 05:54:53 2013

      Thread 1 cannot allocate new log, sequence 137136

      ...

      ...

      Thread 1 advanced to log sequence 137143 (LGWR switch)

        Current log# 1 seq# 137143 mem# 0: +DATA/prod/onlinelog/group_1.530.768090283

        Current log# 1 seq# 137143 mem# 1: +ARC/prod/onlinelog/group_1.263.768090301

      Thu Aug 01 06:19:32 2013

      Archived Log entry 309547 added for thread 1 sequence 137142 ID 0xffffffff9138587b dest 1:

      Thu Aug 01 06:20:11 2013

      minact-scn: got error during useg scan e:1555 usn:143

      minact-scn: useg scan erroring out with error e:1555

      Thu Aug 01 06:20:18 2013

      LNS: Standby redo logfile selected for thread 1 sequence 137143 for destination LOG_ARCHIVE_DEST_2

      Thu Aug 01 06:23:11 2013

      minact-scn: got error during useg scan e:1555 usn:143