Oracle active standby ORA-01555
1,249 total views, 4 views today
公司的一台Oracle备库ADG（11.2.0.4）alert.log中出现大量ORA-01555错误。
查看系统视图都会出现ORA-01555
|
1 2 3 4 5 6 |
SQL> select * from v$archive_gap; select * from v$archive_gap * ERROR at line 1: ORA-00604: error occurred at recursive SQL level 3 ORA-01555: snapshot too old: rollback segment number 347 with name "_SYSSMU347_4236294198$" too small |
在网上找到了这篇mos。这个bug 影响版本是11.2.0.2到12.1（不含）。不过这个bug在11.2.0.4没有修复。只能升级解决。
问题发生原因：
当获取一个 library cache lock时导致更广泛的hang情况，其他会话需要等待这个锁，因此产生了自身hang（self-hang）或者spin。
问题重现：
A process spins in kglLock(),
other processes waiting for the spinning session
ORA-1555 on Active data Guard
Bug 10018789 Spin in kgllock / DB hang with high library cache lock waits on ADG
Bug 10018789 Spin in kgllock / DB hang with high library cache lock waits on ADG
This note gives a brief overview of bug 10018789.
The content was last updated on: 03-SEP-2013
Click here for details of each of the sections below.Affects:
Product (Component) Oracle Server (Rdbms) Range of versions believed to be affected Versions >= 11.2.0.2 but BELOW 12.1 Versions confirmed as being affected Platforms affected Generic (all / most platforms affected) It is believed to be a regression in default behaviour thus:
Regression introduced in 11.2.0.2Fixed:
This issue is fixed in Symptoms: Related To:
- Hang (Process Spins)
- ORA-1555
- Waits for “library cache lock”
Description
This problem is introduced in 11.2.0.2 by the fix for bug 9214531
A self-hang / spin can occur when getting a library cache lock
leading to a wider hang scenario with other sessions waiting
for the blocked lock.
Rediscovery Notes:
A process spins in kglLock(),
other processes waiting for the spinning session
ORA-1555 on Active data Guard
HOOKS ERROR:ORA-1555 SPIN:kglLock “WAITEVENT:library cache lock” CAUSE:9214531 SUPERCEDES:9214531 LIKELYAFFECTS XAFFECTS_11.2.0.2 XAFFECTS_V11020002 AFFECTS=11.2.0.2 XPRODID_5 PRODUCT_ID=5 PRODID-5 RDBMS XCOMP_RDBMS COMPONENT=RDBMS TAG_ADG TAG_HANG/SPIN TAG_RB202 TAG_REGRESSION ADG HANG/SPIN RB202 REGRESSION FIXED_11.2.0.1.BP07 FIXED_11.2.0.2.2 FIXED_11.2.0.2.BP01 FIXED_11.2.0.3 FIXED_12.1.0.1 FIXED_WIN:B202P03 FIXED_WIN:B202P25
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:10018789 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article