当前数据库版本xstream停掉了
XStream Apply Reader AS01 for DBZXOUT22 with pid=154 OS id=36804 stopped XStream Apply Server AS02 for DBZXOUT22 with pid=155 OS id=36807 stopped 2022-10-27T16:03:26.075297+08:00 XStream APPLY AP01 for DBZXOUT22 with pid=8, OS id=36802 stopped 2022-10-27T16:03:26.075393+08:00 Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ap01_36802.trc: ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250], [], [], [], [], [], [], [], [], [], [], [] 2022-10-27T16:03:29.089498+08:00 XStream Outbound Server for DBZXOUT22 with pid=138 OS id=241066 stopped 2022-10-27T16:03:29.089881+08:00 Errors in file /oracle/app/diag/rdbms/test/test/trace/test_ora_241066.trc: ORA-26804: Apply "DBZXOUT22" is disabled. 2022-10-27T16:03:29.106080+08:00
trace 日志
oldest_pos_knamxld=0000000002c64a7a oldest_pos_knacctx=0000000002c6ef35 ------------------------------------------------------------------------------- Trace Bucket Dump Begin: Apply Coordinator work bucket DATA ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Trace Bucket Dump End: Apply Coordinator work bucket ------------------------------------------------------------------------------- Trace Bucket Dump Begin: Apply Coordinator history bucket DATA ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- Trace Bucket Dump End: Apply Coordinator history bucket ksvp2penabled: ep->flg = 0, rpr->slv_flg = 0 ksvp2penabled: ep = 0x7f27e0300970, rpr = 0x50de79490 *** 2022-10-27T16:02:02.388611+08:00 <error barrier> at 0x7ffe4bba08e0 placed ksv.c@7154 ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250], [], [], [], [], [], [], [], [], [], [], [] OPIRIP: Uncaught error 447. Error stack: ORA-00447: fatal error in background process ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250], [], [], [], [], [], [], [], [], [], [], []
Bug 32338220 xf21.3sec_ols2 - trc - knacpft_processfetchedtxns - ORA-600 [knacpft_processfetchedtxns250]
This note gives a brief overview of bug 32338220. The content was last updated on: 12-OCT-2022 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 21.3 Versions confirmed as being affected 19.16.0 19.15.0 Platforms affected Generic (all / most platforms affected)
Fixed:
Interim patches may be available for earlier versions - click here to check.
The fix for 32338220 is first included in 19.17.0.0.221018 (October 2022) DB Release Update (DB RU)
Symptoms: |
Related To: |
| Internal Error May Occur (ORA-600) ORA-600 [knacpft_processfetchedtxns250] Stack is likely to include knacpft_ProcessFetchedTxns | Streams / Logical Standby |
Description
XStream Out may encounter ORA-600 [knacpft_ProcessFetchedTxns250] because the oldest_scn is set incorrectly. REDISCOVERY INFORMATION: If XStream Out apply aborted due to ORA-600 [knacpft_ProcessFetchedTxns250] then it may be due to this bug. Workaround NONE
| 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:32338220 (This link will only work for PUBLISHED bugs) Note:245840.1 Information on the sections in this article
