PROBLEM:

We have observed below error in dgmgrl :

DGMGRL> show database prdstby

Database - prdstby

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 9 minutes 24 seconds (computed 0 seconds ago)
Apply Lag: 9 minutes 24 seconds (computed 0 seconds ago)
Average Apply Rate: 488.00 KByte/s
Real Time Query: ON
Instance(s):
prdstby

Database Warning(s):
ORA-16853: apply lag has exceeded specified threshold
ORA-16855: transport lag has exceeded specified threshold

Database Status:
WARNING

DGMGRL> show configuration

Configuration - dg_config_PRD

Protection Mode: MaxPerformance
Members:
ne - Primary database
prdby - Physical standby database
prdstby - Physical standby database
Warning: ORA-16809: multiple warnings detected for the member

Fast-Start Failover: DISABLED

SOLUTION:

1.Check for the delaymin parametr:

DGMGRL> show database verbose prdstby DelayMins
DelayMins = -0-

2. Change the value to a higher value

DGMGRL> edit database prdstby set property DelayMins=15;
Property -delaymins" updated
DGMGRL>

3. Now check again:

DGMGRL> show database prdstby

Database - prdstby

Role: PHYSICAL STANDBY
Intended State: APPLY-ON
Transport Lag: 0 seconds (computed 0 seconds ago)
Apply Lag: 0 seconds (computed 0 seconds ago)
Average Apply Rate: 502.00 KByte/s
Real Time Query: ON
Instance(s):
prdstby

Database Status:
SUCCESS

 

 

 

dgmgrlORA- TROUBLESHOOTING


Related Topics

ORA-32771: cannot add file to bigfile tablespace
TNS-01106: Listener using listener name has already been started
ORA-16855: transport lag has exceeded specified threshold
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
ORA-32773: operation not supported for smallfile tablespace
TNS-12542: TNS:address already in use
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace
ORA-01536: space quota exceeded for tablespace
ORA-30034: Undo tablespace cannot be specified as temporary tablespace
ORA-32774: more than one file was specified for bigfile tablespace

You May Also Like

Useful DGMGRL commands in oracle dataguard
LREG Background Process in oracle
ORA-02304: invalid object identifier literal while import with CREATE TYPE OID
How to install trace file analyzer( TFACTL)
Script to get cpu usage and wait event information in oracle database
Unified audit trail in Oracle 12c
How to move AUD$ table to another tablespace using DBMS_AUDIT_MGMT
DEFERRED_SEGMENT_CREATION parameter in oracle
Add database as target oracle 12c cloud control
ORA-20101: TABLESPACE is not a ASSM (Automatic Segment Space Management) tablespace

From This Website

How to stop MySQL on Linux and Windows
Defgen utility in Oracle goldengate
Apply database proactive bundle patch in RAC using manual process
_optimizer_ignore_hint
What is colored sql_id in dba_hist_colored_sql
PDB Lockdown Profiles in Oracle 12.2
DEFERRED_SEGMENT_CREATION parameter in oracle
ORA-16855: transport lag has exceeded specified threshold
Exception in thread -main" java.lang.OutOfMemoryError: GC overhead limit exceeded with bsu.sh
How to flashback a RAC database