醫(yī)藥分銷(xiāo)控股oracle goldengate用戶手冊(cè)驗(yàn)收版

1、項(xiàng)目介項(xiàng)目背系統(tǒng)架OGG 項(xiàng)目介項(xiàng)目背系統(tǒng)架OGG 查看OGG進(jìn)程狀配置OGG需修改表結(jié)升加附鏈1. 1.1. 化，全力推進(jìn)分銷(xiāo)、零售、物流“三網(wǎng)”建設(shè)，主數(shù)據(jù)管理和 1.2. BI Oracle GoldenGate到1. 1.1. 化，全力推進(jìn)分銷(xiāo)、零售、物流“三網(wǎng)”建設(shè)，主數(shù)據(jù)管理和 1.2. BI Oracle GoldenGate到BI Oracle GoldenGate 使用的數(shù)據(jù)庫(kù)都為Oracle9i/10g 數(shù)據(jù)庫(kù)，操作系統(tǒng)包 BIOracle 10gSolaris 5.10（下以SourceDBIP D Oracle GoldenGate 使用的數(shù)據(jù)庫(kù)都為Oracle9i/1

2、0g 數(shù)據(jù)庫(kù)，操作系統(tǒng)包 BIOracle 10gSolaris 5.10（下以SourceDBIP D Oracle9/win2003 Oracle10/SolarisDBOracle10/Solaris BIBI repbj 到BIbjzsk中。Repbj_dBIDelete_bjzskOGG Trailfile IP BIBI repbj 到BIbjzsk中。Repbj_dBIDelete_bjzskOGG Trailfile IP 2. OGG 2.1. 啟動(dòng)Oracle各分子公 OracleGoldenGateggscimgr查看進(jìn)程狀態(tài)是否為Running（表示已經(jīng)啟動(dòng)dreter

3、forOracle2Buildreter2. OGG 2.1. 啟動(dòng)Oracle各分子公 OracleGoldenGateggscimgr查看進(jìn)程狀態(tài)是否為Running（表示已經(jīng)啟動(dòng)dreterforOracle2BuildreterforOracle2BuildGGSCIstarter/ reterforOracle2BuildGGSCIstart/ manager reter for Oracle Ver2Build001 Windows (optimized), Oracle 10 on Aug 21 2009 13:28:50Copyright(C)GoldenGateSoftwar

4、e,Inc.1995-TheGoldenGatesoftwaremayincludeothercodewrittenbythirdparties; details regarding such third party code, including applicable copyright,legalandlicensingareavailableBI中oracleBI數(shù)據(jù)倉(cāng)庫(kù)主機(jī)系統(tǒng) mgr查看進(jìn)程狀態(tài)是否為Running（表示已經(jīng)啟動(dòng)dreterforOracle2BuildGGSCIinfo/ BI中oracleBI數(shù)據(jù)倉(cāng)庫(kù)主機(jī)系統(tǒng) mgr查看進(jìn)程狀態(tài)是否為Running（表示已經(jīng)啟動(dòng)d

5、reterforOracle2BuildGGSCIinfo/ dreterforOracle2BuildGGSCIstarter/ dreterforOracle2BuildGGSCIstart/ manager reter for Oracle Ver2Build001 Windows (optimized), Oracle 10 on Aug 21 2009 13:28:50Copyright(C)GoldenGateSoftware,Inc.1995-TheGoldenGatesoftwaremayincludeothercodewrittenbythirdparties; detail

6、s regarding such third party code, including applicable copyright,legalandlicensingareavailableGGSCIinfo/ 2.2. 停止Oracle各分子公 2.2. 停止Oracle各分子公 GoldenGateextXX 96715287CopyrightGoldenGateSoftware,GGSCIinfo ReadRecovery Checkpoition of oldest unprosedtranhedatasource): Thread #: 1Sequence RBA:2008-05-2

7、0SCN:RedoFile:NotCurrent Checkpoition of last record readhedatasource): Thread #: 1Sequence#:RBA:2008-05-20SCN:RedoFile:Notextmanager 不需要；stoper *。例如extmanager 不需要；stoper *。例如進(jìn)dpegzstopBI中oracleBI數(shù)據(jù)倉(cāng)庫(kù)主機(jī)系統(tǒng) 在BIOGG stoper*manager 2.3. 查看OGG OracleGoldenGate3CopyrightGoldenGateSoftware,GGSCIstop/停止Manag

8、erCopyrightGoldenGateSoftware,GGSCIstoperCopyrightGoldenGateSoftware,GGSCIstopCopyrightGoldenGateSoftware,GGSCIstoperAbended：異常中斷dscAbended：異常中斷dsc 2.3.1 查詢所有進(jìn)程狀命令：GGSCIinfo2.3.2 查詢相關(guān)進(jìn)程狀命令：GGSCIinfo進(jìn)程名 CopyrightGoldenGateSoftware,GGSCIP595B_ctaisdb2info LastStarted2008-05-11us00:00:00(updated00:00:0

9、1CopyrightGoldenGateSoftware,GGSCIP595B_ctaisdb2infoTimeSinceChkpt 2.3.3 查看進(jìn)程檢查點(diǎn)信命令：GGSCIinfo進(jìn)程名 CopyrightGoldenGateSoftware,GGSCIinfo ReadRecovery(2.3.3 查看進(jìn)程檢查點(diǎn)信命令：GGSCIinfo進(jìn)程名 CopyrightGoldenGateSoftware,GGSCIinfo ReadRecovery(itionofoldestsedhedataThread#: Sequence#:RBA:2008-05-20SCN:RedoFile:Not

10、CurrentitionoflastrecordhedataThread#:Sequence#:RBA:2008-05-20SCN:RedoFile:Not LogReadFileNot Thread1,Seqno9671,RBALogReadFile Thread2,Seqno5287,RBA2.3.4查看進(jìn)命令：GGSCIviewreport進(jìn)程名2.3.4查看進(jìn)命令：GGSCIviewreport進(jìn)程名reps abended Copyright GoldenGate Software, Inc.GGSCI view report repgzGoldenGate Delivery for

11、 OraclevBuildAIX5L(optimized64-bit),Oracle9.2.0onNov30200711:47:10 Copyright GoldenGate Software, Inc.Startingat2008-04-24Operating System Ver5, Release 3 Node: zjzbnhdb03 Machine:00CE7A8F4C00soft limithard limit Address SpaHeap SizeFile SizeCPU Times id: 1335310Runningwiththefollowingreplicat repor

12、trolloverat-s-reperror -ddlerroranumfilesMAPreplicat reportrolloverat-s-reperror -ddlerroranumfilesMAPctais2.*Database:Oracle9iriseEditionRelease.0-64bitPL/SQLRelease.0-CORE .0 TNSforIBM/AIXRISCSystem/6000:.0- .0-DatabaseLanguageandCharacterNLS_LANG= = Forfurtherinformationoncharactersetsettings,ple

13、aserefertouserRunTime2.4. 配置OGG2.4.1 配置自動(dòng)刪除隊(duì)列文 editparammgrCopyrightGoldenGateSoftware,2.4. 配置OGG2.4.1 配置自動(dòng)刪除隊(duì)列文 editparammgrCopyrightGoldenGateSoftware,GGSCIeditparam/Manager 后面的數(shù)字為天數(shù)。例如，如果希望只保留隊(duì)列/ggs/dirdat/xm10 CopyrightGoldenGateSoftware,GGSCIstopsisrequiredbyotherGGSAreyousureyouwanttostopity/n

14、/ymgr SendingSTOPrequesttoMANAGEROpened trail file /oradata /goldengate/dirdat/xm000000 at 2008-04-24 23:10:19WildcardMAPresolved(entryMAPUsingfollowingcolumnsindefaultmapbyCZRY_DM,SWJG_DM,CZRY_MC,SWRY_DM,QX_SWJG_DM,XM_NSRSBH,XYBZ, mgr。2.4.2配置啟動(dòng)mgr時(shí)自動(dòng)啟動(dòng)extractreplicat進(jìn) editparammgrCopyrightmgr。2.4.2

15、配置啟動(dòng)mgr時(shí)自動(dòng)啟動(dòng)extractreplicat進(jìn) editparammgrCopyrightGoldenGateSoftware,GGSCIeditparam/Manager CopyrightGoldenGateSoftware,GGSCIstop/關(guān)閉進(jìn)程sisrequiredbyotherGGSAreyousureyouwanttostopity/n/ymgr SendingSTOPrequesttoMANAGERRequestManagerGGSCIstart/啟動(dòng)ManagerRequest proManager stopped.Copyright GoldenGate So

16、ftware, Inc.GGSCI start mgrManager3配置mgr定時(shí)自動(dòng)重啟extractreplicat進(jìn)3配置mgr定時(shí)自動(dòng)重啟extractreplicat進(jìn) editparammgr 2.5. GGSCIstop/停止進(jìn)程sisrequiredbyotherGGSAreyousureyouwanttostopity/n/ymgr SendingSTOPrequesttoMANAGER. Request proManagerGGSCI start mgr/Manager Manager started.Copyright GoldenGate Software, Inc.

17、GGSCIedit param mgr/Manager 參數(shù) , 命令格式：ggsciinfo 進(jìn)程名命令格式：ggsciinfo 進(jìn)程名CopyrightGoldenGateSoftware,ggsciinfo ReadRecovery Checkpoition of oldest unprosedtranhedatasource): Thread #: 1Sequence#:RBA:2008-05-20SCN:RedoFile:NotCurrent Checkpoition of last record readhedatasource): Thread #: 1Sequence#:RBA

18、:2008-05-20SCN:RedoFile:NotReadRecovery Checkpoition of oldest unprosedtranhedatasource): Thread #: 2Sequence#:2.5.1長(zhǎng)交sendextract進(jìn)程名showtransthreadncount 可選的，表示只查2.5.1長(zhǎng)交sendextract進(jìn)程名showtransthreadncount 可選的，表示只查看其中一個(gè)節(jié)點(diǎn)上的未提交交易；Count n 也是可選的，表示只顯示n CopyrightGoldenGateSoftware,Ggscisendextractextszsh

19、owtransthreadcount/查詢extsz點(diǎn)110 SendingshowtransrequesttoEXTRACTNoionsOldestredologfilesarytorestartExtractRedoLogSequenceNumber2,RBA GoldenGate2.5.2OGG理長(zhǎng)交RBA:2008-05-20SCN:RedoFile:GgsciSENDEXTRACTSKIPTRANSTHREADGgsciSENDEXTRACTFORCETRANSTHREADGgsciSENDEXTRACTSKIPTRANSTHREADGgsciSENDEXTRACTFORCETRAN

20、STHREAD2.5.3 配置長(zhǎng)交易告 長(zhǎng)交易，GoldenGate 會(huì)在根目錄下的 ggserr.log 2.6. 表在 Copyright GoldenGate Software, Inc.ggsci edit param extsz/extsz參數(shù)warnlongtrans12hervals2.6.1無(wú)需刪除操作業(yè)務(wù)表(包含 PK、在源端和目標(biāo)端分別建立新的業(yè)務(wù)數(shù)據(jù)表（OGG書(shū)2.6.1無(wú)需刪除操作業(yè)務(wù)表(包含 PK、在源端和目標(biāo)端分別建立新的業(yè)務(wù)數(shù)據(jù)表（OGG書(shū) OracleGoldenGateggsci CopyrightGoldenGateSoftware,ggscieditpar

21、am/rephz#Scp CopyrightGoldenGateSoftware,GGSCIdbloginuseridgoldengate,GGSCIinfotrandataschema.CopyrightGoldenGateSoftware,ggscieditparam/rephzmap map sour.sy_test, colmap (usedefaults, last_update_time = datenow(),create_record_time=datenow(),filter(oninsert,1=1),FILTER(ONUPDATE,on delete, 1 1 );map

22、 sour.sy_test, colmap (usedefaults, last_update_time = DATENOW(),FILTER(ondelete,ONUPDATE,1=1),filter(oninsert,11),keycols(pin, financecode, generaltype, type);/-CopyrightGoldenGateSoftware,ggscieditparam/rephz_d-MAP hzzsk.sy_test,delete_hzzsk_d.sy_test, INSERTALLRECORDS, colmap (USEDEFAULTS,DELETE_

23、OP_TIME=DATENOW(),DB_OP_NAME=token(TDB_OP_NAME),=getval(lookup1.output),SQLEXEC(IDlookup1,QUERYCopyrightGoldenGateSoftware,GGSCIstopGGSCIstartCopyrightGoldenGateSoftware,ggscieditparam/rephz10. CopyrightGoldenGateSoftware,GGSCIstopGGSCIstoprepxxGGSCIstart10. CopyrightGoldenGateSoftware,GGSCIstopGGSCIstoprepxxGGSCIstartGGSCIstartrepxx2.7. 確認(rèn)需要修改的表無(wú)數(shù)據(jù)變化（ extdpe rep ect from ftp#exp delete,1=1),filter(oninsert,onupdate,1/lookup11lookup imp Infoallimp Infoallggsci 2.8. 當(dāng)mgrreterforOracle v Build 012Win