Oracle GoldenGate学习之--GoldenGate的监控

1、使用GGSCI命令监控

（1）进入GoldenGate安装目录，运行GGSCI，然后使用info all查看整体的运行状况

GGSCI(aix212)1>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGEXTRACTRUNNINGEORA_100:00:0000:00:03EXTRACTRUNNINGPORA_100:00:0000:00:00GGSCI(aix211)1>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGRORA_100:00:0000:00:09

Group表示进程的名称（MGR进程不显示名字）；

Lag表示进程的延时；Status表示进程的状态，有4种状态。

STARTING 表示正在启动过程中。

RUNNING 表示进程正常运行。

STOPPED 表示进程被正常关闭。

ABENDED 表示进程非正常关闭，需要进一步调查原因。

正常情况下，所有进程的状态应该为RUNNING，且Lag应该在一个合理的范围内。

（2）使用view params <进程名> 可以查看进程的参数设置，该命令支持通配符*

源端：GGSCI(aix212)4>viewparammgrdynamicportlist7800-8000autorestartextract*,waitminutes2,resetminutes5GGSCI(aix212)7>viewparameini_1EXTRACTEINI_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERIDogg,PASSWORDoggRMTHOST192.168.8.211,MGRPORT7809RMTTASKREPLICAT,GROUPRINI_1TABLEscott.EMP_OGG;GGSCI(aix212)5>viewparameora_1EXTRACTEORA_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERIDogg,PASSWORDoggEXTTRAIL./dirdat/aaTABLEscott.emp_ogg;GGSCI(aix212)6>viewparampora_1EXTRACTPORA_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)PASSTHRURMTHOST192.168.8.211,MGRPORT7809RMTTRAIL./dirdat/paTABLEscott.emp_ogg;目标端：GGSCI(aix211)4>viewparammgrport7809dynamicportlist7800-8000autorestartextract*,waitminutes2,resetminutes5GGSCI(aix211)3>viewparamrini_1REPLICATRINI_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)ASSUMETARGETDEFSUSERIDogg,PASSWORDoggDISCARDFILE./dirrpt/RINIaa.dsc,PURGEMAPscott.emp_ogg,TARGETscott.emp_ogg;GGSCI(aix211)2>viewparamrora_1REPLICATRORA_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERIDogg,PASSWORDoggHANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE./dirrpt/RORA_aa.DSC,PURGEMAPscott.oem_ogg,TARGETscott.emp_ogg;

（3）使用info <进程名称> 命令可以查看进程信息，可以查看到的信息包括进程状态、checkpoint信息、延时等

GGSCI(aix212)8>infoeora_1EXTRACTEORA_1LastStarted2014-09-2516:09StatusRUNNINGCheckpointLag00:00:00(updated00:00:04ago)LogReadCheckpointOracleRedoLogs2014-09-2517:00:16Seqno5,RBA21645824SCN0.658565(658565)GGSCI(aix212)9>infopora_1EXTRACTPORA_1LastStarted2014-09-2516:09StatusRUNNINGCheckpointLag00:00:00(updated00:00:05ago)LogReadCheckpointFile./dirdat/pa000000FirstRecordRBA0GGSCI(aix211)5>inforora_1REPLICATRORA_1LastStarted2014-09-2516:25StatusRUNNINGCheckpointLag00:00:00(updated00:00:04ago)LogReadCheckpointFile./dirdat/pa000000FirstRecordRBA0

（4）还可以使用info <进程名称> detail 命令查看更详细的信息，包括所使用的trail文件、参数文件、报告文件、警告日志的位置等

GGSCI(aix212)10>infoeora_1detailEXTRACTEORA_1LastStarted2014-09-2516:09StatusRUNNINGCheckpointLag00:00:00(updated00:00:02ago)LogReadCheckpointOracleRedoLogs2014-09-2517:01:58Seqno5,RBA21770240SCN0.658666(658666)TargetExtractTrails:RemoteTrailNameSeqnoRBAMaxMB./dirdat/aa223545ExtractSourceBeginEnd/u01/app/oracle/oradata/orcl/redo01.log2014-09-2516:072014-09-2517:01/u01/app/oracle/oradata/orcl/redo01.log2014-09-2320:342014-09-2516:08/u01/app/oracle/oradata/orcl/redo03.log2014-09-2315:172014-09-2320:35NotAvailable*Initialized*2014-09-2315:17Currentdirectory/oggReportfile/ogg/dirrpt/EORA_1.rptParameterfile/ogg/dirprm/eora_1.prmCheckpointfile/ogg/dirchk/EORA_1.cpeProcessfile/ogg/dirpcs/EORA_1.pceStdoutfile/ogg/dirout/EORA_1.outErrorlog/ogg/ggserr.logGGSCI(aix211)6>inforora_1detailREPLICATRORA_1LastStarted2014-09-2516:25StatusRUNNINGCheckpointLag00:00:00(updated00:00:04ago)LogReadCheckpointFile./dirdat/pa000000FirstRecordRBA0ExtractSourceBeginEnd./dirdat/pa000000*Initialized*FirstRecord./dirdat/pa000000*Initialized*FirstRecordCurrentdirectory/oggReportfile/ogg/dirrpt/RORA_1.rptParameterfile/ogg/dirprm/rora_1.prmCheckpointfile/ogg/dirchk/RORA_1.cprCheckpointtableogg.checkpointProcessfile/ogg/dirpcs/RORA_1.pcrStdoutfile/ogg/dirout/RORA_1.outErrorlog/ogg/ggserr.log

（5）使用info <进程名称> showch 命令可以查看到详细的关于checkpoint的信息，用于查看GoldenGate进程处理过的事务记录

GGSCI(aix212)11>infoeora_1showchEXTRACTEORA_1LastStarted2014-09-2516:09StatusRUNNINGCheckpointLag00:00:00(updated00:00:03ago)LogReadCheckpointOracleRedoLogs2014-09-2517:04:50Seqno5,RBA21797888SCN0.658739(658739)CurrentCheckpointDetail:ReadCheckpoint#1OracleRedoLogStartupCheckpoint(startingpositioninthedatasource):Thread#:1Sequence#:5RBA:19244560Timestamp:2014-09-2516:07:15.000000SCN:0.656759(656759)RedoFile:/u01/app/oracle/oradata/orcl/redo01.logRecoveryCheckpoint(positionofoldestunprocessedtransactioninthedatasource):Thread#:1Sequence#:5RBA:21795856Timestamp:2014-09-2517:04:43.000000SCN:0.658736(658736)RedoFile:/u01/app/oracle/oradata/orcl/redo01.logCurrentCheckpoint(positionoflastrecordreadinthedatasource):Thread#:1Sequence#:5RBA:21797888Timestamp:2014-09-2517:04:50.000000SCN:0.658739(658739)RedoFile:/u01/app/oracle/oradata/orcl/redo01.logBRPreviousRecoveryCheckpoint:Thread#:0Sequence#:0RBA:0Timestamp:2014-09-2315:22:40.485502SCN:NotavailableRedoFile:BRBeginRecoveryCheckpoint:Thread#:1Sequence#:4RBA:10054144Timestamp:2014-09-2319:22:47.000000SCN:0.629912(629912)RedoFile:BREndRecoveryCheckpoint:Thread#:1Sequence#:4RBA:10054144Timestamp:2014-09-2319:22:47.000000SCN:0.629912(629912)RedoFile:WriteCheckpoint#1GGSLogTrailCurrentCheckpoint(currentwriteposition):Sequence#:2RBA:2354Timestamp:2014-09-2517:04:54.617925ExtractTrail:./dirdat/aaCSNstateinformation:CRC:B9-8B-16-BDLatestCSN:658581LatestTXN:3.47.317LatestCSNoffinishedTXNs:658581CompletedTXNs:3.47.317Header:Version=2RecordSource=AType=10#InputCheckpoints=1#OutputCheckpoints=1FileInformation:BlockSize=2048MaxBlocks=100RecordLength=2048CurrentOffset=0Configuration:DataSource=3TransactionIntegrity=1TaskType=0Status:StartTime=2014-09-2516:09:02LastUpdateTime=2014-09-2517:04:54StopStatus=ALastResult=400

其中比较重要的是Extract进程的recovery checkpoint，它表示源数据中最早的未被处理的事务；通过recovery checkpoint可以查看到该事务的redo log位于哪个日志文件以及该日志文件的序列号。

所有序列号比它大的日志文件，均需要保留。

（6）lag <进程名称> 可以查看详细的延时信息

GGSCI(aix212)12>lageora_1SendingGETLAGrequesttoEXTRACTEORA_1...Lastrecordlag:2seconds.AtEOF,nomorerecordstoprocess.

（7）stats可以查看进程处理的记录数：

该报告会详细地列出处理的类型和记录数，例如：

stats <进程名称>,<时间频度>,table <owner name>.<table name>

GGSCI(aix212)13>statseora_1,totalSendingSTATSrequesttoEXTRACTEORA_1...StartofStatisticsat2014-09-2517:08:54.Outputto./dirdat/aa:ExtractingfromSCOTT.EMP_OGGtoSCOTT.EMP_OGG:***Totalstatisticssince2014-09-2516:11:23***Totalinserts3.00Totalupdates0.00Totaldeletes6.00Totaldiscards0.00Totaloperations9.00EndofStatistics.

列出自进程启动以来处理的所有记录数，如图11-8所示。

GGSCI(aix212)15>statseora_1,daily,tablescott.emp_oggSendingSTATSrequesttoEXTRACTEORA_1...StartofStatisticsat2014-09-2517:11:16.Outputto./dirdat/aa:ExtractingfromSCOTT.EMP_OGGtoSCOTT.EMP_OGG:***Dailystatisticssince2014-09-2516:11:23***Totalinserts3.00Totalupdates0.00Totaldeletes6.00Totaldiscards0.00Totaloperations9.00EndofStatistics.

列出当天以来处理的有关scott.emp_ogg表的所有记录数。

（8）view report <进程名称> 可以查看运行报告

GGSCI(aix212)16>viewreporteora_1***********************************************************************OracleGoldenGateCaptureforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230AIX5L,ppc,64bit(optimized),Oracle10.2onApr23201207:57:02Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.Startingat2014-09-2516:09:01***********************************************************************OperatingSystemVersion:AIXVersion5,Release3Node:aix212Machine:0009746A4C00softlimithardlimitAddressSpaceSize:unlimitedunlimitedHeapSize:unlimitedunlimitedFileSize:unlimitedunlimitedCPUTime:unlimitedunlimitedProcessid:229538Description:*************************************************************************Runningwiththefollowingparameters*************************************************************************2014-09-2516:09:01INFOOGG-03035OperatingsystemcharactersetidentifiedasISO-8859-1.Locale:en_US_POSIX,LC_ALL:.EXTRACTEORA_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)Setenvironmentvariable(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERIDogg,PASSWORD***EXTTRAIL./dirdat/aaTABLEscott.emp_ogg;2014-09-2516:09:01INFOOGG-01815VirtualMemoryFacilitiesfor:BRanonalloc:mmap(MAP_ANON)anonfree:munmapfilealloc:mmap(MAP_SHARED)filefree:munmaptargetdirectories:/ogg/BR/EORA_1.BoundedRecoveryParameter:BRINTERVAL=4HOURSBRDIR=/ogg2014-09-2516:09:02INFOOGG-01815VirtualMemoryFacilitiesfor:COManonalloc:mmap(MAP_ANON)anonfree:munmapfilealloc:mmap(MAP_SHARED)filefree:munmaptargetdirectories:/ogg/dirtmp.CACHEMGRvirtualmemoryvalues(mayhavebeenadjusted)CACHESIZE:64GCACHEPAGEOUTSIZE(normal):8MPROCESSVMAVAILFROMOS(min):128GCACHESIZEMAX(strictforcetodisk):96G2014-09-2516:09:02INFOOGG-01639BOUNDEDRECOVERY:ACTIVE:forobjectpool1:p536622_extr.2014-09-2516:09:02INFOOGG-01640BOUNDEDRECOVERY:recoverystartXID:0.0.0.2014-09-2516:09:02INFOOGG-01641BOUNDEDRECOVERY:recoverystartposition:SeqNo:4,RBA:10053648,SCN:0.629912(629912),Timestamp:2014-09-2319:22:47.000000,Thread:1.2014-09-2516:09:02INFOOGG-01642BOUNDEDRECOVERY:recoveryendposition:SeqNo:4,RBA:10054144,SCN:0.629912(629912),Timestamp:2014-09-2319:22:47.000000,Thread:1.2014-09-2516:09:02INFOOGG-01643BOUNDEDRECOVERY:CANCELED:forobjectpool1:p536622_extr.2014-09-2516:09:02INFOOGG-01579BOUNDEDRECOVERY:VALIDBCP:CP.EORA_1.000000001.2014-09-2516:09:02INFOOGG-01629BOUNDEDRECOVERY:PERSISTEDOBJECTSRECOVERED:<<NONETORECOVER>>.DatabaseVersion:OracleDatabase10gEnterpriseEditionRelease10.2.0.1.0-64biPL/SQLRelease10.2.0.1.0-ProductionCORE10.2.0.1.0ProductionTNSforIBM/AIXRISCSystem/6000:Version10.2.0.1.0-ProductioNLSRTLVersion10.2.0.1.0-ProductionDatabaseLanguageandCharacterSet:NLS_LANG="AMERICAN_AMERICA.ZHS16GBK"NLS_LANGUAGE="AMERICAN"NLS_TERRITORY="AMERICA"NLS_CHARACTERSET="ZHS16GBK"2014-09-2516:09:02INFOOGG-01513PositioningtoSequence5,RBA19244560,SCN0.656759.2014-09-2516:09:02INFOOGG-01516PositionedtoSequence5,RBA19244560,SCN0.656759,Sep25,20143:07:15PM.2014-09-2516:09:02INFOOGG-01055Recoveryinitializationcompletedfortargetfile./dirdat/aa000001,atRBA1007.2014-09-2516:09:02INFOOGG-01478Outputfile./dirdat/aaisusingformatRELEASE11.2.2014-09-2516:09:02INFOOGG-01026Rollingoverremotefile./dirdat/aa000001.2014-09-2516:09:02INFOOGG-01053Recoverycompletedfortargetfile./dirdat/aa000002,atRBA1007.2014-09-2516:09:02INFOOGG-01057Recoverycompletedforalltargets.*************************************************************************RunTimeMessages*************************************************************************2014-09-2516:09:02INFOOGG-01517PositionoffirstrecordprocessedSequence5,RBA19244560,SCN0.656759,Sep25,20143:07:15PM.TABLEresolved(entryscott.emp_ogg):TABLE"SCOTT"."EMP_OGG";UsingthefollowingkeycolumnsforsourcetableSCOTT.EMP_OGG:EMPNO.2014-09-2517:07:03INFOOGG-01021CommandreceivedfromGGSCI:GETLAG.2014-09-2517:08:54INFOOGG-01021CommandreceivedfromGGSCI:STATStotal.2014-09-2517:10:43INFOOGG-01021CommandreceivedfromGGSCI:STATSdaily,scott.emp_ogg.2014-09-2517:11:16INFOOGG-01021CommandreceivedfromGGSCI:STATSdaily,tablescott.emp_ogg.

（9）也可以进入到 <GoldenGate安装目录>/dirrpt/目录下，查看对应的报告文件。

最新的报告总是以<进程名称>.rpt命名的。加后缀数字的报告是历史报告，数字越大对应的时间越久

[oracle@aix212@ogg]$cddirrpt[oracle@aix212@dirrpt]$ls-lttotal248-rw-rw-rw-1oracleoinstall4962Sep2517:11EORA_1.rpt-rw-rw-rw-1oracleoinstall3124Sep2516:32EINI_1.rpt-rw-rw-rw-1oracleoinstall2252Sep2516:32MGR.rpt-rw-rw-rw-1oracleoinstall3124Sep2516:27EINI_10.rpt-rw-rw-rw-1oracleoinstall3124Sep2516:09EINI_11.rpt-rw-rw-rw-1oracleoinstall2377Sep2516:09PORA_1.rpt-rw-rw-rw-1oracleoinstall3124Sep2516:08EINI_12.rpt-rw-rw-rw-1oracleoinstall1897Sep2516:08MGR0.rpt-rw-rw-rw-1oracleoinstall20631Sep2516:08EORA_10.rpt-rw-rw-rw-1oracleoinstall11416Sep2516:07PORA_10.rpt-rw-rw-rw-1oracleoinstall3124Sep2515:35EINI_13.rpt-rw-rw-rw-1oracleoinstall3899Sep2319:22EORA_11.rpt-rw-rw-rw-1oracleoinstall3124Sep2316:27EINI_14.rpt-rw-rw-rw-1oracleoinstall3078Sep2316:27MGR1.rpt-rw-rw-rw-1oracleoinstall3124Sep2316:24EINI_15.rpt-rw-rw-rw-1oracleoinstall3124Sep2316:23EINI_16.rpt-rw-rw-rw-1oracleoinstall3031Sep2316:20EINI_17.rpt-rw-rw-rw-1oracleoinstall3031Sep2316:18EINI_18.rpt-rw-rw-rw-1oracleoinstall3031Sep2316:13EINI_19.rpt-rw-rw-rw-1oracleoinstall1897Sep2315:49MGR2.rpt-rw-rw-rw-1oracleoinstall2377Sep2315:25PORA_11.rpt-rw-rw-rw-1oracleoinstall1372Sep2315:15MGR3.rpt-rw-rw-rw-1oracleoinstall1547Sep2315:09MGR4.rpt

[oracle@aix212@ dirrpt]$cat EORA_1.rpt

***********************************************************************OracleGoldenGateCaptureforOracleVersion11.2.1.0.1OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230AIX5L,ppc,64bit(optimized),Oracle10.2onApr23201207:57:02Copyright(C)1995,2012,Oracleand/oritsaffiliates.Allrightsreserved.Startingat2014-09-2516:09:01***********************************************************************OperatingSystemVersion:AIXVersion5,Release3Node:aix212Machine:0009746A4C00softlimithardlimitAddressSpaceSize:unlimitedunlimitedHeapSize:unlimitedunlimitedFileSize:unlimitedunlimitedCPUTime:unlimitedunlimitedProcessid:229538Description:*************************************************************************Runningwiththefollowingparameters*************************************************************************2014-09-2516:09:01INFOOGG-03035OperatingsystemcharactersetidentifiedasISO-8859-1.Locale:en_US_POSIX,LC_ALL:.EXTRACTEORA_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)Setenvironmentvariable(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERIDogg,PASSWORD***EXTTRAIL./dirdat/aaTABLEscott.emp_ogg;2014-09-2516:09:01INFOOGG-01815VirtualMemoryFacilitiesfor:BRanonalloc:mmap(MAP_ANON)anonfree:munmapfilealloc:mmap(MAP_SHARED)filefree:munmaptargetdirectories:/ogg/BR/EORA_1.......

如果进程运行时有错误，则报告文件中会包括错误代码和详细的错误诊断信息。通过查找错误代码，可以帮助定位错误原因，解决问题。

2、ggserr.log日志监控

（1）可以用以下方法查看日志文件。

可以通过操作系统命令直接查看ggserr.log文件。

使用GoldenGate Director。

在GGSCI中运行命令view ggsevt。

（2）在日志文件中可以查看到的内容如下。

GGSCI命令的历史记录。

GoldenGate进程的启动与停止。

已执行的处理。

发生的错误。

信息和警告消息。

（3）日志文件的部分内容

GGSCI(aix212)1>viewggsevt2014-09-2315:02:08INFOOGG-00987OracleGoldenGateCommandInterpreterforOracle:GGSCIcommand(oracle):editparammg.2014-09-2315:02:16INFOOGG-00987OracleGoldenGateCommandInterpreterforOracle:GGSCIcommand(oracle):editparammgr.2014-09-2315:04:37INFOOGG-00987OracleGoldenGateCommandInterpreterforOracle:GGSCIcommand(oracle):editparammgr.2014-09-2315:04:57INFOOGG-00987OracleGoldenGateCommandInterpreterforOracle:GGSCIcommand(oracle):startmgr.2014-09-2315:04:58INFOOGG-00983OracleGoldenGateManagerforOracle,mgr.prm:Managerstarted(port7809).2014-09-2315:06:09INFOOGG-00987OracleGoldenGateCommandInterpreterforOracle:GGSCIcommand(oracle):addextracteini_1sourceistable......

案例分析1：

目标端replicat进程启动异常

GGSCI(aix211)16>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATABENDEDRORA_100:00:0043:38:02

查看日志：

日志1：

2014-09-2516:03:42INFOOGG-01815OracleGoldenGateDeliveryforOracle,rora_1.prm:VirtualMemoryFacilitiesfor:COManonalloc:mmap(MAP_ANON)anonfree:munmapfilealloc:mmap(MAP_SHARED)filefree:munmaptargetdirectories:/ogg/dirtmp.2014-09-2516:03:42ERROROGG-00446OracleGoldenGateDeliveryforOracle,rora_1.prm:Checkpointtableogg.checkpointdoesnotexist.PleasecreatethetableorrecreatetheRORA_1groupusingthecorrecttable.2014-09-2516:03:42ERROROGG-01668OracleGoldenGateDeliveryforOracle,rora_1.prm:PROCESSABENDING.

无法找到checkpint table ！

GGSCI(aix211)2>deletecheckpointtableGGSCI(aix211)3>editparam./GLOBALSCHECKPOINTTABLEogg.checkpointGGSCI(aix211)3>exit必须退出ggsci，checkpointtable才会生效[oracle@rh7ogg]$./ggsciGGSCI(aix211)1>dbloginuseridogg,passwordoggSuccessfullyloggedintodatabase.GGSCI(aix211)2>addcheckpointtableNocheckpointtablespecified,usingGLOBALSspecification(ogg.checkpoint)...Successfullycreatedcheckpointtableogg.checkpoint.

重新启动replicat进程：

GGSCI(aix211)16>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATABENDEDRORA_100:00:0043:38:02

启动失败，查看日志！

日志2：

[oracle@aix211ogg]$tailggserr.log2014-09-2516:11:47INFOOGG-00975OracleGoldenGateManagerforOracle,mgr.prm:REPLICATRORA_1starting.2014-09-2516:11:48INFOOGG-00995OracleGoldenGateDeliveryforOracle,rora_1.prm:REPLICATRORA_1starting.2014-09-2516:11:48INFOOGG-03035OracleGoldenGateDeliveryforOracle,rora_1.prm:OperatingsystemcharactersetidentifiedasISO-8859-1.Locale:en_US_POSIX,LC_ALL:.2014-09-2516:11:48INFOOGG-01815OracleGoldenGateDeliveryforOracle,rora_1.prm:VirtualMemoryFacilitiesfor:COManonalloc:mmap(MAP_ANON)anonfree:munmapfilealloc:mmap(MAP_SHARED)filefree:munmaptargetdirectories:/ogg/dirtmp.2014-09-2516:11:48ERROROGG-00446OracleGoldenGateDeliveryforOracle,rora_1.prm:Nodataselectingpositionfromcheckpointtableogg.checkpointforgroup'RORA_1',key1056363220(0x3ef6d2d4),SQL<SELECTa.current_dir,a.seqno,a.rba,a.audit_ts,a.log_csn,a.log_xid,a.log_cmplt_csn,a.log_cmplt_xids,b.log_cmplt_xidsFROMogg.checkpointaLEFTJOINogg.checkpoint_loxbONa.group_name=b.group_nameANDa.group_key=b.group_keyANDa.log_cmplt_csn=b.log_cmplt_csnWHEREa.group_name='RORA_1'ANDa.group_key=1056363220>.2014-09-2516:11:48ERROROGG-01668OracleGoldenGateDeliveryforOracle,rora_1.prm:PROCESSABENDING.

checkpointtable 错误 ！

处理方法：

删除replicat进程：GGSCI(aix211)7>deletereplicatrora_1DeletedREPLICATRORA_1.添加新的replicat进程：GGSCI(aix211)8>addreplicatrora_1,exttrail./dirdat/pa,checkpointtableogg.checkpointREPLICATadded.GGSCI(aix211)9>editparamrora_1"/ogg/dirprm/rora_1.prm"7lines,198charactersREPLICATRORA_1SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERIDogg,PASSWORDoggHANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE./dirrpt/RORA_aa.DSC,PURGEMAPscott.oem_ogg,TARGETscott.emp_ogg;~重新启动replicat进程GGSCI(aix211)10>startreplicatrora_1SendingSTARTrequesttoMANAGER...REPLICATRORA_1startingGGSCI(aix211)11>infoallProgramStatusGroupLagatChkptTimeSinceChkptMANAGERRUNNINGREPLICATRUNNINGRORA_100:00:0000:00:03启动成功！

查看ogg日志：

GGSCI (aix211) 12> view ggsevt

2014-09-2516:25:13INFOOGG-00975OracleGoldenGateManagerforOracle,mgr.prm:REPLICATRORA_1starting.2014-09-2516:25:13INFOOGG-00995OracleGoldenGateDeliveryforOracle,rora_1.prm:REPLICATRORA_1starting.2014-09-2516:25:13INFOOGG-03035OracleGoldenGateDeliveryforOracle,rora_1.prm:OperatingsystemcharactersetidentifiedasISO-8859-1.Locale:en_US_POSIX,LC_ALL:.2014-09-2516:25:13INFOOGG-01815OracleGoldenGateDeliveryforOracle,rora_1.prm:VirtualMemoryFacilitiesfor:COManonalloc:mmap(MAP_ANON)anonfree:munmapfilealloc:mmap(MAP_SHARED)filefree:munmaptargetdirectories:/ogg/dirtmp.2014-09-2516:25:13INFOOGG-00996OracleGoldenGateDeliveryforOracle,rora_1.prm:REPLICATRORA_1started.

案例分析2：

源端初始化进程（eini_1)和目标端初始化进程（rini_1)

目标端初始化进程rini_1：

GGSCI(aix211)13>inforini_1REPLICATRINI_1Initialized2014-09-2315:40StatusSTOPPEDCheckpointLag00:00:00(updated48:46:37ago)LogReadCheckpointNotAvailableTaskSPECIALRUN

源端初始化进程eini_1：

GGSCI(aix212)21>infoeini_1EXTRACTEINI_1LastStarted2014-09-2516:09StatusSTOPPEDCheckpointLagNotAvailableLogReadCheckpointTableSCOTT.EMP_OGG2014-09-2516:09:35Record14TaskSOURCEISTABLE

启动源端初始化进程：

GGSCI(aix212)22>starteini_1SendingSTARTrequesttoMANAGER...EXTRACTEINI_1startingGGSCI(aix212)23>infoeini_1EXTRACTEINI_1LastStarted2014-09-2516:09StatusRUNNINGCheckpointLagNotAvailableLogReadCheckpointTableSCOTT.EMP_OGG2014-09-2516:09:35Record14TaskSOURCEISTAB

进程启动后，目标端初始化进程自动启动！

GGSCI(aix211)14>inforini_1REPLICATRINI_1Initialized2014-09-2315:40StatusRUNNINGCheckpointLag00:00:00(updated48:47:03ago)LogReadCheckpointNotAvailableTaskSPECIALRUN