SAP Knowledge Base Article - Preview

2898813 - ORA-16724: cannot resolve gap for one or more standby databases

Symptom

There is a gap in the Redo Sequence on the Standby database.

 
The error itself is visible in different places as seen below:

  1. Alert Log of the Primary Database

    ...

    2020-02-28 15:02:20.868000 +01:00
    Errors in file /oracle/DG1/diag/rdbms/dg1_north/DG1/trace/DG1_arc1_28323.trc:
    ORA-00308: cannot open archived log '/oracle/DG1/oraarch/DG1arch1_251_913812350.dbf'
    ORA-27037: unable to obtain file status
    Linux-x86_64 Error: 2: No such file or directory
    Additional information: 3
    <<NOTE, above error is present only if the file is physically not available anymore or there is a problem to access the file>>
    ...
    RFS[3]: Assigned to RFS process (PID:18406)
    RFS[3]: Opened log for thread 1 sequence 252 dbid 1895179966 branch 913812350
    Archived Log entry 255 added for thread 1 sequence 252 rlc 913812350 ID 0x71e14b21 dest 2:
    RFS[3]: Opened log for thread 1 sequence 253 dbid 1895179966 branch 913812350
    Archived Log entry 256 added for thread 1 sequence 253 rlc 913812350 ID 0x71e14b21 dest 2:
    Fetching gap sequence in thread 1, gap sequence 251-251
    ...

  2. Alert Log of the Standby Database

    ...

    FAL[client, ARC1]: Error 1034 connecting to dg1north.world for fetching gap sequence
    FAL[client, ARC1]: Error 12541 connecting to dg1north.world for fetching gap sequence
    FAL[client, ARC1]: Error 1034 connecting to dg1north.world for fetching gap sequence
    Fetching gap sequence in thread 1, gap sequence 251-251
    FAL[client]: Failed to request gap sequence 
    archivelog gaps.

    ...


  3. Data Guard Broker Command Line Tool (DGMGRL) (if Broker is configured)

    ...

    DGMGRL> show configuration

    Configuration - dg1

    Protection Mode: MaxPerformance
    Members:
    dg1_north - Primary database
    Error: ORA-16724: cannot resolve gap for one or more standby databases

    dg1_south - Physical standby database

    Fast-Start Failover: DISABLED

    Configuration Status:
    ERROR (status updated 26 seconds ago)

    ...

  4. Data Guard Broker Log / drc<DBSID>.log (if Broker is configured)

    ...

    Found unresolvable gap for database dg1_south.
    Data Guard Broker Status Summary:
    Type Name Severity Status
    Configuration dg1 Warning ORA-16607
    Primary Database dg1_north Error ORA-16724
    Physical Standby Database dg1_south Success ORA-00000


    ...


Read more...

Environment

  • SAP Netweaver
  • Oracle RDBMS 10g and upwards
  • Data Guard (Standby Database)

Keywords

data guard, broker, standby, primary, ORA-16724, ORA-16607, ORA-00308, ORA-27037, DGMGRL, FAL, ARCH, Fetching gap sequence, request gap sequence, gaps, archivelog
, KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.