重庆思庄Oracle、Redhat认证学习论坛

标题: Bug 17323222 - ORA-1555 / ORA-3170: deadlocked on readable physical standby (... [打印本页]
作者: 郑全    时间: 2018-3-3 17:21
标题: 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 affectedVersions BELOW 12.1
Versions confirmed as being affected
  • 11.2.0.4
  • 11.2.0.3
Platforms affectedGeneric (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




欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2