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

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

You May Also Like

how to use DBMS_PRIVILEGE_CAPTURE to capture privs in oracle 12c
Find the active transactions in oracle database
ENABLE_PARALLEL_DML hint in oracle 12c
Ansible script to run script on remote server and fetch the output
How to install trace file analyzer( TFACTL)
How to enable flash recovery area in oracle database
REUSE_DUMPFILES parameter in EXPDP
SQLCL UTILITY IN ORACLE
Oracle database Security Assessment Tool
Change dbsnmp password for target db in oem 12c

From This Website

SQLCL UTILITY IN ORACLE
ORA-32774: more than one file was specified for bigfile tablespace
How to Downgrade oracle 19C Grid to 12C GRID
How to use expdp to export data from physical standby database
Alert log rotation script in oracle
resumable_timeout parameter in oracle database
How to add a tempfile in primary database in dataguard
how to send mail using utl_mail in oracle 11g
ORA-01536: space quota exceeded for tablespace
Useful TFACTL commands