ORA-02062 错误

错误：

ORA-02062: distributed recovery received DBID 238844f6, expected 8176bd16

解释：

ORA-02062 distributed recovery received DBID string, expected string

Cause: A database link at a coordinator no longer points to the expected database. Link may have been redefined, or a different database mounted.

Action: Restore the link definition or the remote database.

数据库链接所对应的数据库发生了变化（重建等原因），不是原来的那个数据库

解决：

SQL> select local_tran_id from dba_2pc_pending;

LOCAL_TRAN_ID

----------------------

15.32.1802588

2.29.1108241

SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('15.32.1802588');

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL> EXECUTE DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('2.29.1108241');

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/15191593/viewspace-715050/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15191593/viewspace-715050/