Oracle GoldenGate学习之–GoldenGate的监控

OracleGoldenGate学习之–GoldenGate的监控1、使用GGSCI命令监控（1）进入GoldenGate安装目录，运行GGSCI，然后使用infoall查看整体的运行状况GGSCI(aix212)1inf

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

GGSCI (aix21本文来源gaodai$ma#com搞$$代**码)网@2) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGEXTRACT RUNNING EORA_1 00:00:00 00:00:03EXTRACT RUNNING PORA_1 00:00:00 00:00:00GGSCI (aix211) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNINGREPLICAT RUNNING RORA_1 00:00:00 00:00:09

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

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

STARTING 表示正在启动过程中。

RUNNING 表示进程正常运行。

STOPPED 表示进程被正常关闭。

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

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

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

源端：GGSCI (aix212) 4> view param mgrdynamicportlist 7800-8000autorestart extract *,waitminutes 2,resetminutes 5GGSCI (aix212) 7> view param eini_1EXTRACT EINI_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg,PASSWORD oggRMTHOST 192.168.8.211,MGRPORT 7809RMTTASK REPLICAT, GROUP RINI_1TABLE scott.EMP_OGG;GGSCI (aix212) 5> view param eora_1EXTRACT EORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg,PASSWORD oggEXTTRAIL ./dirdat/aaTABLE scott.emp_ogg;GGSCI (aix212) 6> view param pora_1EXTRACT PORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)PASSTHRURMTHOST 192.168.8.211,MGRPORT 7809RMTTRAIL ./dirdat/paTABLE scott.emp_ogg;目标端：GGSCI (aix211) 4> view param mgrport 7809dynamicportlist 7800-8000autorestart extract *,waitminutes 2,resetminutes 5GGSCI (aix211) 3> view param rini_1REPLICAT RINI_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)ASSUMETARGETDEFSUSERID ogg,PASSWORD oggDISCARDFILE ./dirrpt/RINIaa.dsc,PURGEMAP scott.emp_ogg, TARGET scott.emp_ogg;GGSCI (aix211) 2> view param rora_1REPLICAT RORA_1SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)USERID ogg,PASSWORD oggHANDLECOLLISIONSASSUMETARGETDEFSDISCARDFILE ./dirrpt/RORA_aa.DSC,PURGEMAP scott.oem_ogg, TARGET scott.emp_ogg;

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

GGSCI (aix212) 8> info eora_1EXTRACT EORA_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:04 ago)Log Read Checkpoint Oracle Redo Logs 2014-09-25 17:00:16 Seqno 5, RBA 21645824 SCN 0.658565 (658565) GGSCI (aix212) 9> info pora_1EXTRACT PORA_1 Last Started 2014-09-25 16:09 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:05 ago)Log Read Checkpoint File ./dirdat/pa000000 First Record RBA 0 GGSCI (aix211) 5> info rora_1REPLICAT RORA_1 Last Started 2014-09-25 16:25 Status RUNNINGCheckpoint Lag 00:00:00 (updated 00:00:04 ago)Log Read Checkpoint File ./dirdat/pa000000 First Record RBA 0

喜欢 (0)赏

[搞代码]

分享 (0)