错误：
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博客 ” ，链接：https://blog.itpub.net/15191593/viewspace-715050/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
开启oracle归档
请登录后发表评论
登录
全部评论
