資源描述：
《goldengate維護(hù)手冊》由會員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、一、Goldengate監(jiān)控1、監(jiān)控進(jìn)程狀態(tài)a)Manage進(jìn)程:[ggs@GZCRMDB1]$./ggsciOracleGoldenGateCommandInterpreterforOracleVersion10.4.0.19Build002AIX5L,ppc,64bit(optimized),Oracle10onSep23200916:08:43Copyright(C)1995,2009,Oracleand/oritsaffiliates.Allrightsreserved.GGSCI(GZCRMDB1)1>infomgrMa
2、nagerisrunning(IPportGZCRMDB1.7810)b)Capture、dump、replicat進(jìn)程：GGSCI(GZCRMDB1)2>infoallProgramStatusGroupLagTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEDEPCRMA00:00:0000:00:05EXTRACTABENDEDEGZCRMA13:58:2221:36:36EXTRACTRUNNINGEGZCRMB00:00:0000:00:02EXTRACTRUNNINGEGZCRMHX
3、00:00:0000:00:02EXTRACTRUNNINGPDEPCRMA00:00:0000:00:02EXTRACTRUNNINGPGZCRMA00:00:0000:00:03EXTRACTRUNNINGPGZZYA00:00:0000:00:08EXTRACTRUNNINGPGZZYHX00:00:0000:00:01EXTRACTABENDEDPODSASCA00:00:0021:36:37EXTRACTABENDEDPODSDSCA00:00:0021:36:30EXTRACTABENDEDPODSDSCD240:39
4、:1633:50:40EXTRACTRUNNINGPSZCRMA00:00:0000:00:06REPLICATRUNNINGRDEPCRMA00:00:0000:00:06REPLICATRUNNINGRGZCRMA00:00:0000:00:06說明：如果進(jìn)程狀態(tài)是RUNNING表示進(jìn)程正常如果進(jìn)程狀態(tài)是STOPPED或者ABENDED表示進(jìn)程異常1、監(jiān)控延遲情況命令：lag進(jìn)程名例如：GGSCI(GZCRMDB1)18>lagEGZCRMASendingGETLAGrequesttoEXTRACTEGZCRMA...Last
5、recordlag:5seconds.AtEOF,nomorerecordstoprocess.說明目前延遲5秒2、監(jiān)控進(jìn)程同步情況命令：stats進(jìn)程名例如;GGSCI(GZCRMDB1)19>statsEGZCRMAExtractingfromCRM_GZ_INST.TB_CS_PLANtoCRM_GZ_INST.TB_CS_PLAN:***Totalstatisticssince2010-04-1910:09:05***Totalinserts77881.00Totalupdates462.00Totaldeletes43.
6、00Totaldiscards0.00Totaloperations78386.00說明：如果discards出現(xiàn)數(shù)據(jù)表示同步的數(shù)據(jù)有問題，需要查看discard文件。Discard文件路徑，在參數(shù)文件中的discardfile參數(shù)設(shè)置,例如：ViewparamsEGZCRMAdiscardfile/oracle/gzcrmggs01/ggdata/dep/rdepcrma/da.dsc3、監(jiān)控errorlog命令：在goldengate安裝目錄下:1、moreggserr.log
7、grepERROR2、moreggserr.lo
8、g
9、grepWARNING1、監(jiān)控進(jìn)程report命令：viewreport進(jìn)程名GGSCI(GZCRMDB1)2>viewreportEGZCRMA***********************************************************************查看report里面出現(xiàn)的ERROR報(bào)錯(cuò)。一、Goldengate常見故障1、源端和目標(biāo)端表結(jié)構(gòu)不一致，會出現(xiàn)以下類似錯(cuò)誤：GGSERROR160Badcolumnindex(75)specifiedfortableCRM_SZ_INST.TB
10、_BA_BATCHLIST,maxcolumns=75.解決:修改兩端表CRM_SZ_INST.TB_BA_BATCHLIST結(jié)構(gòu)為一致，然后再startup2、源端追不上歸檔日志，會出現(xiàn)以下類似錯(cuò)誤：GGSERROR500Couldnotfind
