ORA-02062: distributed recovery received DBID
select * from DBA_2PC_NEIGHBORS;
select * from sys.pending_trans$;
select * from SYS.PENDING_SESSIONS$;
select * from SYS.PENDING_SUB_SESSIONS$;
SELECT KTUXEUSN, KTUXESLT, KTUXESQN, /* Transaction ID */
KTUXESTA Status,
KTUXECFL Flags
FROM x$ktuxe
WHERE ktuxesta!='INACTIVE'
1. Force committing the transactions in collecting state:
COMMIT FORCE 'transaction_id',commit#;
2. execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('transaction_id');
Transaction ID:
160.15.14218
17.25.695140
22.22.673214
Commit;
No comments:
Post a Comment