【思庄oracle技术分享】- ORA-02062: distributed recovery处理方法

【思庄oracle技术分享】- ORA-02062: distributed recovery处理方法

查看数据库日志文件发现频繁出现分布式事务相关报错：ORA-02062: distributed recovery received DBID bf38e3da, expected 7b66439b
ORA-02062: distributed recovery received DBID bf38e3da, expected 7b66439b

处理方法为：
1.查询被锁的分布式事务
select local_tran_id,state from dba_2pc_pending;
local_tran_id state

---

29.35.745 collecting
26.46.775 collecting

2.sys用户执行语句
EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(‘29.35.745’);
commit;

EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(‘26.46.775’);
commit;

再次查看就无相关报错了