今天客戶(hù)的GoldenGate出問(wèn)題了，打電話過(guò)來(lái)咨詢(xún)，根據(jù)客戶(hù)描述的問(wèn)題現(xiàn)象和日志的分析，初步判斷是數(shù)據(jù)庫(kù)索引異常引起的故障，以下是問(wèn)題的分析和處理描述。

????問(wèn)題描述：

??2010-02-01 17:19:28??GGS ERROR????103??Discard file (./dirrpt/repsz.dsc) exceeded max bytes (10000000).

2010-02-01 17:19:28??GGS ERROR????190??PROCESS ABENDING.

???Discard文件摘錄：

????ORA-01502: index a.IDX_SB_SBXX_SSSQ_QZ' or partition of such index is in unusable state, SQL <UPDATE "a"."DJ_YZCWSBQC_CWBB" SET "NSRDZDAH" = :a21,"ND" = :a22,"YF" = :a23,"SSSQ_Q" = :a24,"SSSQ_Z" = :a25,"CWBBZL_DM" = :a26,"SBQX" = :a27,"YQSBQX" = :a28,"SBRQ" = :a29,"SBFS_DM" = :a30,"HY_DM">
Operation failed at seqno 1816 rba 153098124
Discarding record on action DISCARD on error 1502
Problem replicating CTAIS2.SB_SBXX to CTAIS2.SB_SBXX
Error (1502) occurred with insert record (target format)...
*

????問(wèn)題分析：

????看到錯(cuò)誤描述，又是一個(gè)discard文件寫(xiě)滿進(jìn)程abend的問(wèn)題，這回是什么原因引起大量的寫(xiě)discard的操作的呢？通過(guò)分析discard文件發(fā)現(xiàn)大量的如下錯(cuò)誤信息：or partition of such index is in unusable state。

看來(lái)是數(shù)據(jù)庫(kù)的索引出現(xiàn)故障了，拿我們就先從處理數(shù)據(jù)庫(kù)故障開(kāi)始。

?

????問(wèn)題處理：

????1、參考Oracle官方給出的處理這個(gè)ora類(lèi)型錯(cuò)誤的建議：

ORA-01502: index 'string.string' or partition of such index is in unusable state
Cause: An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation
Action: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition

????2、我們重建了這個(gè)有問(wèn)題的索引

????3、清空已經(jīng)寫(xiě)滿信息的discard文件

????4、重新啟動(dòng)rep進(jìn)程，故障排除。

總結(jié)

以上是生活随笔為你收集整理的Oracle数据库索引失效，引起GoldenGate异常的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。