ORA-02062: distributed recovery received DBID %s, expected %s

Error log:

2017-06-21 11:56:07.973000 +05:30
Errors in file /oracle/app/oracle/diag/rdbms/vcbcbs/vcbcbs/trace/vcbcbs_reco_5696.trc:
ORA-02062: distributed recovery received DBID f2fc225a, expected f509547a

SQL> SELECT COMMIT# ,LOCAL_TRAN_ID, STATE, MIXED, HOST, GLOBAL_TRAN_ID FROM DBA_2PC_PENDING;
COMMIT#     LOCAL_TRAN_ID     STATE         MIX HOST          GLOBAL_TRAN_ID 
----------- ----------------- ------------- --- --------      ----------------
7072124803  10.22.2551715     collecting    no  DC-EDPSTAFF1  VBPROD.f3c3de87.10.22.2551715

 

SQL> SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, INTERFACE FROM DBA_2PC_NEIGHBORS;
LOCAL_TRAN_ID          IN_ DATABASE                I
---------------------- --------------------------  -
10.22.2551715          in                          N
10.22.2551715          out CBL1                    N

 

As a part of the solution, issued following command in order to purge pending distributed transaction:

Execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('10.22.2551715');

Execute DBMS_TRANSACTION.PURGE_MIXED ('10.22.2551715');

Thanks,

Stay tune. 🙂

Leave a Reply