OracleGoldenGate learning-Monitoring of GoldenGate

OracleGoldenGate learning-GoldenGate monitoring 1. Use GGSCI command monitoring (1) to enter the GoldenGate installation directory, run GGSCI, and then use infoall to view the overall running status GGSCI (aix212) 1inf

OracleGoldenGate learning-GoldenGate monitoring 1. Use GGSCI command monitoring (1) to enter the GoldenGate installation directory, run GGSCI, and then use infoall to view the overall running status GGSCI (aix212) 1inf

(1) enter the GoldenGate installation directory, run GGSCI, and then use info all to view the overall running status.

GGSCI (aix212) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER runningextract running EORA_1 00:00:00: 00: 03 extract running PORA_1 00:00:00: 00: 00 GGSCI (aix211) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER runningreplicat running RORA_1 00:00:00 00:00:09

Group indicates the name of the process (MGR process does not display the name );

Lag indicates the delay of the process; Status indicates the state of the process, which has four states.

STARTING indicates that the instance is being started.

RUNNING indicates that the process is RUNNING normally.

STOPPED indicates that the process is shut down normally.

ABENDED indicates that the process is shut down abnormally and further investigation is required.

Under normal circumstances, the status of all processes should be RUNNING, and the Lag should be within a reasonable range.

(2) Use view params <进程名> You can view the process parameter settings. This command supports wildcards *

Source end: GGSCI (aix212) 4> view param mgrdynamicportlist limit extract *, waitminutes 2, resetminutes 5 GGSCI (aix212) 7> view param limit (NLS_LANG = Limit) USERID ogg, PASSWORD oggRMTHOST 192.168.8.211, MGRPORT 7809 rmttask 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 7809 RMTTRAIL. /dirdat/paTABLE scott. emp_ogg; target end: GGSCI (aix211) 4> view param mgrport 7809 dynamicportlist limit extract *, waitminutes 2, resetminutes 5 GGSCI (aix211) 3> view param limit (NLS_LANG = Limit) ASSUMETARGETDEFSUSERID ogg, PASSWORD oggDISCARDFILE. /dirrpt/riniga. 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 required. /dirrpt/RORA_aa.DSC, PURGEMAP scott. oem_ogg, TARGET scott. emp_ogg;

(3) Use info <进程名称> Command to view process information, including process status, checkpoint information, latency, etc.

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