Hi,
You should monitor Goldengate everytime, because Goldengate gets error frequently.
Golden gate Lag Monitoring Script
If you want to learn more details about Goldengate architecture, read the following post.
Goldengate monitoring scripts
If you have many replication especially many databases and tables, then you may get error frequently.
You should constantly monitor Goldengate with following scripts.
Displays the status of all Goldengate processes like following query
GGSCI (deveci01) 21> info all
Monitoring Goldengate through SQL
You can monitor extract , pumper and replicat processes like following.
GGSCI (deveci01) 21> info extract EXDEV01 GGSCI (deveci01) 19> info extract EXDEV01 GGSCI (deveci01) 20> info replicat RXDEV01 GGSCI (deveci01) 20> info PROCESS_NAME
Displays the status of the Manager Process like following query
GGSCI (deveci01) 23> status manager Manager is running (IP port deveci01.7809).
Show Extraction status
GGSCI (deveci01) 24> status extract EXDEV01 EXTRACT EXDEV01: RUNNING
Shows details of a specific extract process.
GGSCI (deveci01) 6> info extract EXDEV01, detail EXTRACT EXDEV01 Last Started 2019-02-19 11:19 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:02 ago) Log Read Checkpoint Oracle Redo Logs 2019-02-26 10:45:18 Seqno 786, RBA 44710400 Target Extract Trails: Remote Trail Name Seqno RBA Max MB /u01/oracle/software/goldengate/dirdat/lt 2 55644 10 Extract Source Begin End /u02/oradata/apex/redo03.log 2019-02-19 11:13 2019-02-26 10:45 Current directory /u01/oracle/software/goldengate Report file /u01/oracle/software/goldengate/dirrpt/EXDEV01.rpt Parameter file /u01/oracle/software/goldengate/dirprm/EXDEV01.prm Checkpoint file /u01/oracle/software/goldengate/dirchk/EXDEV01.cpe Process file /u01/oracle/software/goldengate/dirpcs/EXDEV01.pce Stdout file /u01/oracle/software/goldengate/dirout/EXDEV01.out Error log /u01/oracle/software/goldengate/ggserr.log
Displays Extract status
GGSCI (deveci01) 35> send extract EXDEV01 status Sending STATUS request to EXTRACT EXDEV01 ... displays Extract Statistics GGSCI (deveci01) 33> stats extract EXDEV01 Sending STATS request to EXTRACT EXDEV01 ...
View process rate ( ‘hr’,’min’ or ‘sec’ as a parameter for time )
Display the processing rates in hours or seconds of Goldengate processes
GGSCI (deveci01) 37> stats extract EXDEV02 reportrate hr Sending STATS request to EXTRACT EXDEV02 ...
Display of latency between replicat and source
GGSCI (deveci01) 13> send extract EXDEV02, getlag Sending GETLAG request to EXTRACT EXDEV02 ... Last record lag: 3 seconds. At EOF, no more records to process.
Detailed report of processes can be displayed like following.
GGSCI (deveci01) 2> view report EXDEV01 GGSCI (deveci01) 2> view report rep1 GGSCI (deveci01) 2> view report mgr
Child processes status like following.
GGSCI (deveci01) 8> send manager childstatus Sending CHILDSTATUS request to MANAGER ... Child Process Status - 6 Entries ID Group Process Retry Retry Time Start Time ---- -------- ---------- ----- ------------------ ----------- 0 EXDEV01 1925238 0 None 2019/02/19 11:07:54 1 DPUMP 2195496 0 None 2019/02/19 11:08:02 2 MSSQL1 422034 0 None 2019/02/22 13:54:59 4 MYREP 1302702 0 None 2019/02/23 09:08:34 6 DEVLOAD 1200242 0 None 2019/02/23 11:05:01 7 EXDEV02 2076844 0 None 2019/02/26 08:29:22