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