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;


再次查看就无相关报错了