Bug 17323222 - ORA-1555 / ORA-3170: deadlocked on readable physical standby (...

郑全

Bug 17323222  ORA-1555 / ORA-3170: deadlocked on readable physical standby (undo segment x) on ADG   This note gives a brief overview of bug 17323222.
  The content was last updated on: 16-JAN-2018
  Click here for details of each of the sections below.

Affects:

Product (Component)	Oracle Server  (Rdbms)
Range of versions believed to be affected	Versions BELOW 12.1
Versions confirmed as being affected	11.2.0.4 11.2.0.3
Platforms affected	Generic (all / most platforms affected)

Fixed:

The fix for 17323222 is first included in

12.1.0.2 (Server Patch Set) 12.1.0.1 Release 11.2.0.4.2 Database Patch Set Update 11.2.0.4 Bundle Patch 5 for Exadata Database 11.2.0.4 Patch 4 on Windows Platforms

Interim patches may be available for earlier versions - click here to check.

Symptoms:	Related To:
Error May Occur ORA-3170 / ORA-1555	Active Data Guard (ADG) Transportable Tablespaces Physical Standby Database / Dataguard

Description

ORA-1555 or ORA-3170 on Active Data Guard instance (ADG) while MRP is running, for a sql statement against objects of a Transported Tablespace (TTS) . The errors are due to usage of uncleaned ITL fields from foreign datafile blocks. Rediscovery Information: Check if the (undo segment x) from ORA-3170 does not exist on the database. If not, if it is likely that this bug is the cause. Example : ORA-3170: deadlocked on readable physical standby (undo segment x)select SEGMENT_NAME, STATUS from DBA_ROLLBACK_SEGS where SEGMENT_ID = x;  

HOOKS ERROR:ORA-3170 ERROR:ORA-1555 ERROR:ORA-3170 ERROR:ORA-1555 LIKELYAFFECTS XAFFECTS_11.2.0.1 XAFFECTS_V11020001 AFFECTS=11.2.0.1 XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XAFFECTS_11.2.0.3 XAFFECTS_V11020003 AFFECTS=11.2.0.3 XAFFECTS_11.2.0.4 XAFFECTS_V11020004 AFFECTS=11.2.0.4 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_ADG TAG_ERROR TAG_STANDBY TAG_TRANSPORT ADG ERROR STANDBY TRANSPORT FIXED_11.2.0.4.2 FIXED_11.2.0.4.BP05 FIXED_12.1.0.0 FIXED_12.1.0.2 FIXED_WIN:B204P04 SOLVED_SR=25 SOLVED_SR_BAND_3

Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.

References

Bug:17323222  (This link will only work for PUBLISHED bugs)
Note:245840.1  Information on the sections in this article