ora-2075

手工回滚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;