重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-02062: distributed recovery处理方法 [打印本页]

作者: 刘泽宇 时间: 2021-9-3 18:14
标题: 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;

再次查看就无相关报错了

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)