Symptom
There is a gap in the Redo Sequence on the Standby database.
The error itself is visible in different places as seen below:
- 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
... - 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. - 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 databasesdg1_south - Physical standby database
Fast-Start Failover: DISABLED
Configuration Status:
...
ERROR (status updated 26 seconds ago) - 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.