ORA-16857: standby disconnected from redo source for longer than specified threshold

[oracle@prod ~]$ dgmgrl sys/oracle@PROD
DGMGRL for Linux: Version 12.1.0.2.0 – 64bit Production


Copyright (c) 2000, 2013, Oracle. All rights reserved.


Welcome to DGMGRL, type “help” for information.
Connected as SYSDBA.


DGMGRL> SHOW DATABASE PROD


Database – prod


  Role:               PRIMARY
  Intended State:     TRANSPORT-ON
  Instance(s):
    PROD


Database Status:
SUCCESS


DGMGRL> SHOW DATABASE STD


Database – std


  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      27 minutes 49 seconds (computed 43 seconds ago)
  Apply Lag:          27 minutes 49 seconds (computed 43 seconds ago)
  Average Apply Rate: 1.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    STD


  Database Warning(s):
    ORA-16857: standby disconnected from redo source for longer than specified threshold


Database Status:
WARNING


DGMGRL> disable database STD;
Disabled.
DGMGRL> enable database STD;
Enabled.

DGMGRL> SHOW DATABASE STD


Database – std


  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          0 seconds (computed 1 second ago)
  Average Apply Rate: 1.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    STD


Database Status:
SUCCESS

  • June 22, 2017 | 17 views
  • Comments