首页 > 其他分享 >ora-2075

ora-2075

时间:2023-03-04 20:11:06浏览次数:33  
标签:TRANSACTION tran SQL delete local id 2075 ora

手工回滚2pc事务如下报错

ORA-02075: another instance changed state of transaction

导致ORA-02075的原因是另一个实例中的会话发出了提交强制或回滚强制,并且它正在执行挂起事务的恢复。

故障处理

SQL> alter system disable distributed recovery;
SQL> delete from sys.pending_trans$ where local_tran_id = 'LOCAL TRANSACTION ID';
SQL> delete from sys.pending_sessions$ where local_tran_id = 'LOCAL TRANSACTION ID';
SQL> delete from sys.pending_sub_sessions$ where local_tran_id = 'LOCAL TRANSACTION ID';
SQL> commit;
SQL> alter system enable distributed recovery;

 

标签:TRANSACTION,tran,SQL,delete,local,id,2075,ora
From: https://www.cnblogs.com/hanglinux/p/17179000.html

相关文章