Message-Id: <10578.113754@fatcity.com> From: David Barbour Date: Thu, 3 Aug 2000 11:40:59 -0500 Subject: ORA-02062...What next? Morning folks! Checking my alert logs this morning I dicovered the following entry: ORA-02062: distributed recovery received DBID d258e0a3, expected ae705c43 The trusty error messages book says: 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. Okay, I found the dbid links in sys.dba_2pc_neighbors. We moved a database to another machine night before last, and this transaction was part of a stored procedure. Tracked the error to a pending transaction in sys.dba_2pc_pending. Tried to do a: rollback force '10.82.172'; where 10.82.172 is the local_trans_id. Got another error: ORA-02058: no prepared transaction found with ID 10.82.172 There is a commit# assigned to the transaction in sys.dba_2pc_pending, the state is "collecting," and the mixed flag is set at "no". Since my rollback failed, can I manually delete the entries from theses tables, should I try a commit force, or will this somehow dissappear on it's own? Could I manually change the state to "prepared" and then try a rollback(this suggestion has to be the result of brain damage - I can visualize the corruption from here!)? ANY ideas? Other than the commit and rollback options, the book says after 200 seconds, DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME will cause the lock to disappear. We're way past that. David A. Barbour Oracle DBA - ConnectSouth 512-681-9438