ORA-02062: distributed recovery received

Wed Jan 13 14:31:55 2010

Errors in file /apps/app/oracle/admin/simsoft/bdump/simsoft_reco_27399.trc:

ORA-02062: distributed recovery received DBID 54bde88e, expected 31f5063d

SELECT COMMIT# ,LOCAL_TRAN_ID, STATE, MIXED, HOST, GLOBAL_TRAN_ID

FROM DBA_2PC_PENDING;

 

COMMIT#          LOCAL_TRAN_ID          STATE            MIX HOST                              

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

7810847402000    2.96.8884              collecting       no  WORKGROUP\ADMIN-PC                

7812984016243    25.41.2309             collecting       no                                    

7810847582209    10.13.9380             collecting       no  WORKGROUP\ADMIN-PC        

SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, INTERFACE

FROM DBA_2PC_NEIGHBORS;

LOCAL_TRAN_ID          IN_ DATABASE                                                            

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

2.96.8884              in                                                                      

25.41.2309             in                                                                      

10.13.9380             in                                                                       

2.96.8884              out CSRWEB                                                              

10.13.9380             out CSRWEB                                                              

2.96.8884              out INOFFL                                                              

10.13.9380             out INOFFL                                                              

25.41.2309             out CSRWEB                                                               

 

8 rows selected.

SQL> alter system set  "_smu_debug_mode" = 4;

 

System altered.

 

Execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('2.96.8884');

COMMIT;

Execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('25.41.2309');

COMMIT;

Execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY ('10.13.9380');

COMMIT;

 

Execute DBMS_TRANSACTION.PURGE_MIXED ('2.96.8884');

COMMIT;

Execute DBMS_TRANSACTION.PURGE_MIXED ('25.41.2309');

COMMIT;

Execute DBMS_TRANSACTION.PURGE_MIXED ('10.13.9380');

COMMIT;

SQL> RAJ> SELECT LOCAL_TRAN_ID, IN_OUT, DATABASE, INTERFACE

  2  FROM DBA_2PC_NEIGHBORS;

 

no rows selected

 

ALTER SYSTEM DISABLE DISTRIBUTED RECOVERY;

 

SQL> ALTER SYSTEM ENABLE DISTRIBUTED RECOVERY;