sys/dba连接数据库
select * from dba_2pc_pending;
select 'rollback force '''|| local_tran_id||''';' from dba_2pc_pending;
在命令窗口,全部会滚了。
去除dba_2pc_pending和dba_2pc_ neighbors中的记录
(1) Disable分布式恢复
SQL> ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY;
System altered.
(2)Puege(清空)in-doubt transaction entry:
SQL> exec DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('7.30.7415');
PL/SQL procedure successfully completed.
(3)commit;
(4)然后enable 分布式恢复:
SQL> ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY;