Database Administration (MOSC)

MOSC Banner

ORA-03170: deadlocked on readable physical standby (undo segment 473) in Oracle 19c (19.13.0.0) - DG

We are getting the below error when trying to generate a report in our Oracle 19c (19.13.0.0 - Linux) DG Active Standby DB running as "READ ONLY WITH APPLY".

ORA-03170: deadlocked on readable physical standby (undo segment 473)

Any permanent Fix / workaround solutions?

Regards,

Laxminarayan

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center