RECO Process Not Clearing Indoubt Transactions After A Database Switchover
(Doc ID 2489287.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
The Recover(RECO) process for handling in-doubt distributed transactions does not work after a database switchover in a database(Involving Standby configuration) which acts as a XA resource and participates in distributed transactions.
The problem is that the entries in the table DBA_2PC_PENDING never get recovered or purged.
The column RETRY_TIME in the table DBA_2PC_PENDING will not be updated as well. It will remain the same as the timestamp in the FAIL_TIME column.
In normal cases the database will do a retry of the transactions ,when a distributed transactions fails into DBA_2PC_PENDING.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document