ora-00600[4400]错误的解决

上一篇 / 下一篇 2008-02-06 03:16:33 / 个人分类：Troubleshoot

4400错误通常在分布式事务中出现，如到这个错误不会对数据库产生重大的影响，

以下是一个生产库的实际解决的例子。

故障描述：ITPUB个人空间5?8Aw/["|
Errors in file .../udump/ora_15899_$ORACLESID.trc:
jW zT{V+@t0ORA-00600: 内部错误代码，自变量: [4400], [48], [], [], [], [], [], []ITPUB个人空间 ~x&U r'G/PO
Tue Feb 5 17:07:18 2008
r`o%Ng*MPB-A0Errors in file .../bdump/reco_1297_$ORACLESIDl.trc:ITPUB个人空间4Z,\y5IW#J
ORA-02062: distributed recovery received DBID e23ac21, expected 232acd6ITPUB个人空间!a7l'^AI1X
ARC1: media recovery disabled

原因及解决方法：
/M|Sqde2e$zYQ0由于db_link断开，两阶段事务不能正常处理，查询dba_2pc_pendingITPUB个人空间&tg"gY/V3g4c
LOCAL_TRAN_ID          GLOBAL_TRAN_ID                 STATE            MIX A TRAN_COMMENT         FAIL_TIME FORCE_TIM RETRY_TIM OS_USER
ODH8UEi'fKg5t0---------------------- ------------------------------ ---------------- --- - -------------------- --------- --------- --------- ----------------------------------------------------------------
Pr1n1O,}b.l0OS_TERMINAL
c;r U9S:Mg BG0--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ITPUB个人空间DM5](Tn&L!i^
HOST                                                                                                                             DB_USERCOMMIT#
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------------ITPUB个人空间D`q nX9Myr!T Q
192.168.1.1              jpb.6c5f8f5f.192.168.1.1     collecting       no                         05-FEB-08           05-FEB-08 AdministratorITPUB个人空间Y(SJ:A?T7z
DGDX-WRITPUB个人空间 y0e ?U4? Y,qBL
WORKGROUP\DGDX-WR                                                                                                                IBSS7740378455873

192.168.1.2             jpb.6c5f8f5f.192.168.1.2    collecting       no                         05-FEB-08           05-FEB-08 Administrator
C&\N.P}"g} fnJ0DGDX-WR
r7DA2pve Wx Y0WORKGROUP\DGDX-WR                                                                                                                IBSS7740389820541ITPUB个人空间.}:^"f Klk
192.168.1.112             jpb.6c5f8f5f.192.168.1.112    collecting       no                         05-FEB-08           05-FEB-08 Administrator
L0\&IB_ J0DGDX-WR
VA2W Q-X0WORKGROUP\DGDX-WR                                                                                                                IBSS7740970651708

ITPUB个人空间7?{2Hv5O1wnU_
通过以下方法来清除这些事务：

SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('192.168.1.2');
aB)k3MO0PL/SQL procedure successfully completed.
SQL> commit;ITPUB个人空间s@'E;Hh4a(si+^x
Commit complete.ITPUB个人空间 Q(Ne+c8Dp'a-i
SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('192.168.1.1');
{a,cAzW#h{0PL/SQL procedure successfully completed.ITPUB个人空间WRuix,[f5D
SQL> commit;ITPUB个人空间DD0H![!?6Y[R
Commit complete.ITPUB个人空间\5La8rDNz+z
SQL> execute DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY('192.168.1.112');
boXh-E0PL/SQL procedure successfully completed.
r.[\%EN Jj0SQL> commit;