Oracle Dataguard

Dataguard Broker

DGMGRL> show database CAQ04601_S

Database - CAQ04601_S

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 1 second ago)
  Apply Lag:          3 days 4 hours 38 minutes 27 seconds (computed 1 second ago)
  Average Apply Rate: 27.00 KByte/s
  Real Time Query:    OFF
  Instance(s):
    CAQ04601

  Database Error(s):
    ORA-16766: Redo Apply is stopped

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

Database Status:
ERROR

DGMGRL> edit database CAQ04601_S set state='apply-off';
Succeeded.
DGMGRL> edit database CAQ04601_S set state='apply-on';
Succeeded.
DGMGRL>