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

You May Also Like

Display sql_id of the sql, using set feedback in oracle 18C - New feature
Blackout targets in OEM 12c cloud control
DEFERRED_SEGMENT_CREATION parameter in oracle
CONTENT parameter in datapump
How to move spfile from file system to ASM in RAC
Shared Pool Advisory in oracle
Find the active transactions in oracle database
How to monitor parallel queries in oracle db
ORA-32774: more than one file was specified for bigfile tablespace
How to change flash recovery area location

From This Website

Setting up Table replication in oracle goldengate
Flashback primary database in dataguard environment
How to start MySQL on Linux and Windows
Generate custom report from OEM cloud control
SETUP ORACLE 18C DATABASE - STEP BY STEP
How to change flash recovery area location
shell script for file system alert
Steps for upgrading weblogic 12.1.2 to 12.1.3
ERROR: permission denied for schema in postgres
Purge AUD$ table using DBMS_AUDIT_MGMT