Wednesday, September 6, 2017


ORA-02062: distributed recovery received DBID


select * from DBA_2PC_PENDING;
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

 RMAN Recovery Catalog About Recovery Catalog RMAN recovery catalog Is another database which is out of your normal databases or which is o...