My Oracle Support Banner

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 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.