oracle goldengate学习笔记,Oracle GoldenGate学习之--GoldenGate的监控

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

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

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EORA_1 00:00:00 00:00:03

EXTRACT RUNNING PORA_1 00:00:00 00:00:00

GGSCI (aix211) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT 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 mgr

dynamicportlist 7800-8000

autorestart extract *,waitminutes 2,resetminutes 5

GGSCI (aix212) 7> view param eini_1

EXTRACT EINI_1

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

USERID ogg,PASSWORD ogg

RMTHOST 192.168.8.211,MGRPORT 7809

RMTTASK REPLICAT, GROUP RINI_1

TABLE scott.EMP_OGG;

GGSCI (aix212) 5> view param eora_1

EXTRACT EORA_1

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

USERID ogg,PASSWORD ogg

EXTTRAIL ./dirdat/aa

TABLE scott.emp_ogg;

GGSCI (aix212) 6> view param pora_1

EXTRACT PORA_1

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

PASSTHRU

RMTHOST 192.168.8.211,MGRPORT 7809

RMTTRAIL ./dirdat/pa

TABLE scott.emp_ogg;

目标端：

GGSCI (aix211) 4> view param mgr

port 7809

dynamicportlist 7800-8000

autorestart extract *,waitminutes 2,resetminutes 5

GGSCI (aix211) 3> view param rini_1

REPLICAT RINI_1

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

ASSUMETARGETDEFS

USERID ogg,PASSWORD ogg

DISCARDFILE ./dirrpt/RINIaa.dsc,PURGE

MAP scott.emp_ogg, TARGET scott.emp_ogg;

GGSCI (aix211) 2> view param rora_1

REPLICAT RORA_1

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

USERID ogg,PASSWORD ogg

HANDLECOLLISIONS

ASSUMETARGETDEFS

DISCARDFILE ./dirrpt/RORA_aa.DSC,PURGE

MAP scott.oem_ogg, TARGET scott.emp_ogg;

(3)使用info 命令可以查看进程信息，可以查看到的信息包括进程状态、checkpoint信息、延时等GGSCI (aix212) 8> info eora_1

EXTRACT EORA_1 Last Started 2014-09-25 16:09 Status RUNNING

Checkpoint 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_1

EXTRACT PORA_1 Last Started 2014-09-25 16:09 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:05 ago)

Log Read Checkpoint File ./dirdat/pa000000

First Record RBA 0

GGSCI (aix211) 5> info rora_1

REPLICAT RORA_1 Last Started 2014-09-25 16:25 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:04 ago)

Log Read Checkpoint File ./dirdat/pa000000

First Record RBA 0

本文原创发布php中文网，转载请注明出处，感谢您的尊重！