Standby Database Got ORA-03170: Deadlocked; Pmon Not Able To Clean Up (Doc ID 2134423.1)

Last updated on AUGUST 23, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.
***Checked for relevance on 24-Aug-2017***

Symptoms

The following errors reported on Active Data Guard physical standby over and over:

  Errors in file /u01/oracle/diag/rdbms/<DB_NAME>/<INSTANCE_NAME>/trace/<INSTANCE_NAME>_pmon_41746880.trc:
  ORA-03170: deadlocked on readable physical standby (undo segment 65535)

And the pmon trace contains call stack: krdwtadv()<-ktuGetUsegDba()<-ktugin_cr()

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms