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