Monitor goldengate Status

After configuring the goldengate, we need to monitor its transmission data volume, process delay, process status and other information, the following are some specific commands:

Ggsci (ZBDBA1) 36> info allprogram Status Group Lag at chkpt time Since Chkptmanager RUNNING EXTRACT RUNNING EXT1 00:00:00 00:00:00 EXTRACT RUNNING EX T2 00:00:00 00:00:09 Ggsci (zbdba1) 37> status Mgrmanager is running (IP port zbdba1.7839). Ggsci (ZBDBA1) 38> status extract ext1extract Ext1:runningggsci (ZBDBA1) 39> info extract ext1,detailextract EXT 1 last Started 2015-03-03 21:20 Status runningcheckpoint Lag 00:00:00 (updated 00:00:03 ago) Log Read Checkpoi NT Oracle Redo Logs 2015-03-03 21:41:55 seqno, RBA 22201344 SCN 0.1296423 (12 96423) Target Extract trails:remote Trail Name seqno RBA Max mb/ogg/dirdat/   SA 0 0./dirdat/sa 0  54236007 Extract Source                        Begin End/opt/oracle/oradata/orcl11g/redo03.log 2015-03-03 21:20 2015- 03-03 21:41 Not Available * Initialized * 2015-03-03 21:20current directory/oggreport fil E/ogg/dirrpt/ext1.rptparameter File/ogg/dirprm/ext1.prmcheckpoint file/ogg/dirchk/ext1.cpeprocess F Ile/ogg/dirpcs/ext1.pcestdout file/ogg/dirout/ext1.outerror Log/ogg/ggserr.logggsci (zbdba1 ) 40> Send extract ext1 statussending STATUS request to extract EXT1 ... EXTRACT EXT1 (PID 1839) Current Status:recovery complete:at EOF current Read Position:redo thread #: 1 Sequence #:  rba:22201344 timestamp:2015-03-03 21:41:55.000000 scn:0.1296423 Current Write Positions:sequence #: 0 rba:0  timestamp:2015-03-03 21:20:22.216536 Extract Trail:/ogg/dirdat/sa Sequence #: 0 rba:54236007 timestamp:2015-03-03 21:42:25.527048 Extract Trail:./dirdat/saggsci (ZBDBA1) 41> stats Extract ext1sending STATS request to extract EXT1 ... Start of Statistics at 2015-03-03 21:42:40.DDL replication Statistics (for all trails):* * * Total Statistics since extract                                  Started * * * Operations 1.00 Mapped Operations                                   1.00 Unmapped Operations 0.00 Other Operations 0.00 excluded Operations 0.00Output to./dirdat/sa:extracting fro M. OGG. Ggs_marker to OGG. ggs_marker:*** Total Statistics since 2015-03-03 21:24:31 * * No database operations have been performed.*** Daily Statistics since 2015-03-03 21:24:31 * * No database operations have been performed.*** Hourly statistics since 201         5-03-03 21:24:31 * * * NO database operations have been performed.*** Latest statistics since 2015-03-03 21:24:31 * * * No database operations has been performed. Extracting from ZBdba. TEST to ZBDBA.        test:*** Total Statistics since 2015-03-03 21:24:31 * * Total inserts 86589.00         Total Updates 0.00 Total Deletes 0.00 Total discards 0.00 Total Operations 8658        9.00*** Daily Statistics since 2015-03-03 21:24:31 * * Total inserts 86589.00        Total Updates 0.00 Total Deletes 0.00 Total discards 0.00 Total Operations 86589        .00*** Hourly Statistics since 2015-03-03 21:24:31 * * Total inserts 86589.00      Total Updates 0.00 Total Deletes 0.00  Total discards 0.00 Total Operations 86589.00** * Latest Statistics since 2015-03-03 21:24:31 * * Total inserts 86589.00 to        TAL updates 0.00 Total Deletes 0.00 Total discards 0.00 Total Operations 86589.00Ex Tracting from ZBDBA. TEST3 to ZBDBA.        test3:*** Total Statistics since 2015-03-03 21:24:31 * * Total inserts 86592.00 Total Updates 0.00 Total Deletes 0.0 0 Total discards 0.00 Total Operations 865 92.00*** Daily Statistics since 2015-03-03 21:24:31 * * Total inserts 86592.00 Total Updates 0.00 Total Deletes                               0.00 Total Discards 0.00 Total operations 86592.00*** Hourly Statistics since 2015-03-03 21:24:31 * * Total inserts 8                                      6592.00 Total Updates 0.00 Total Deletes                               0.00 Total Discards 0.00 Total operations 86592.00*** Latest Statistics since 2015-03-03 21:24:31 * * Total inserts 8                                      6592.00 Total Updates 0.00 Total Deletes                               0.00 Total Discards 0.00 Total operations 86592.00End of StAtistics. Ggsci (ZBDBA1) 42> stats extract ext1 reportrate hrsending stats request to extract EXT1 ... Start of Statistics at 2015-03-03 21:43:05.DDL replication Statistics (for all trails):* * * Total Statistics since extract                                  Started * * * Operations 1.00 Mapped Operations                                   1.00 Unmapped Operations 0.00 Other Operations 0.00 excluded Operations 0.00Output to./dirdat/sa:extracting fro M. OGG. Ggs_marker to OGG. ggs_marker:*** Total Statistics since 2015-03-03 21:24:31 * * No database operations have been performed.*** Daily Statistics since 2015-03-03 21:24:31 * * No database operations have been performed.*** Hourly statistics since 201         5-03-03 21:24:31 * * * NO database operations have been performed.*** Latest statistics since 2015-03-03 21:24:31 * * * No DatabasE operations has been performed. Extracting from ZBDBA. TEST to ZBDBA.        test:*** Total Statistics since 2015-03-03 21:24:31 * * Total inserts/hour:280006.18         Total updates/hour:0.00 Total deletes/hour:0.00 Total discards/hour:0.00 Total operations/hour:28000        6.18*** Daily Statistics since 2015-03-03 21:24:31 * * Total inserts/hour:280006.18        Total updates/hour:0.00 Total deletes/hour:0.00 Total discards/hour:0.00 Total operations/hour:280006        .18*** Hourly Statistics since 2015-03-03 21:24:31 * * Total inserts/hour:280006.18 Total updates/hour:0.00 Total Deletes/hour:0.00 Total discards/hour:0.00 Total O perations/hour:280006.18*** Latest Statistics since 2015-03-03 21:24:31 * * Total inserts/h our:280006.18 Total updates/hour:0.00 Total delet es/hour:0.00 Total discards/hour:0.00 Total O Perations/hour:280006.18extracting from ZBDBA. TEST3 to ZBDBA.        test3:*** Total Statistics since 2015-03-03 21:24:31 * * Total inserts/hour:280015.88 Total updates/hour:0.00 Total deletes/hour:0.0 0 Total discards/hour:0.00 Total operations/hour:2800      15.88*** Daily Statistics since 2015-03-03 21:24:31 * * *  Total inserts/hour:280015.88 Total updates/hour:0.00 Total deletes/hour:0.00 total discards/hour:0.        XX Total operations/hour:280015.88*** Hourly statistics since 2015-03-03 21:24:31 * * *        Total inserts/hour:280015.88 Total updates/hour:0.00 Total deletes/hour:0.00 total discards/hour:0.        XX Total operations/hour:280015.88*** Latest statistics since 2015-03-03 21:24:31 * * *        Total inserts/hour:280015.88 Total updates/hour:0.00 Total deletes/hour:0.00 total discards/hour:0. XX Total OperatioNs/hour:280015.88end of Statistics.ggsci (ZBDBA1) 44> send extract ext1,getlagsending Getlag re Quest to EXTRACT EXT1 ... Last record lag:2 seconds. At EOF, no more records to process. Ggsci (ZBDBA1) 45> lag extract ext*sending Getlag request to extract EXT1 ... Last record lag:2 seconds. At EOF, no more records to process. Sending Getlag request to EXTRACT EXT2 ... Last record lag:10 seconds. At EOF, no more records to process.                 Ggsci (ZBDBA1) 46> View report ext1*********************************************************************** Oracle GoldenGate Capture for Oracle Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO Linux, x64, 64bit (optimized), Oracle 11g on APR 08:42:16copyright (C) 1995, and Oracle and/or its affiliates.                    All rights reserved. Starting at 2015-03-03 21:20:41***********************************************************************operating System version:linuxversion #1 SMP WedJune 18:24:36 EDT, Release 2.6.32-279.el6.x86_64node:zbdba1machine:x86_64 soft limit ha            Rd limitaddress Space size:unlimited unlimitedheap size:unlimited unlimitedfile Size : Unlimited unlimitedcpu time:unlimited unlimitedprocess id:1839description:****************                  Running with the following parameters 2015-03-03 21:20:41 INFO OGG-03035 Operat ing system character set identified as UTF-8. Locale:en_us, Lc_all:. EXTRACT ext1setenv (Nls_lang = American_america. ZHS16GBK) Set environment variable (nls_lang=american_america. ZHS16GBK) USERID Ogg,password ***ddl include MAPPED OBJTYPE ' TABLE ' include MAPPED OBJTYPE ' Idnex ' include MAPPED OBJTYPE ' SEQUENCE ' include MAPPED OBJTYPE ' VIEW ' include MAPPED OBJTYPE ' PROCEDURE ' include MAPPED OBJTYPE ' FUNCTION ' include MAPPED OBJTYPE ' package ' include MAPPED OBJTYPE ' materialized VIEW ' EXCLUDE OPTYPE commentddlo ptions addtrandata nocrossrename Reportggsci (ZBDBA1) 47> send Mgr Childstatussending childstatus request to MANAGER: . Child process Status-2 Entriesid Group Process Retry Retry time Start time--------------------     --------------------------------------------0 EXT1 1839 0 None 2015/03/03 21:19:38 1 EXT2 1848 0 None 2015/03/03 21:20:56ggsci (ZBDBA1) 48> info extract ext1,showchextract EX T1 last Started 2015-03-03 21:20 Status runningcheckpoint Lag 00:00:00 (updated 00:00:04 ago) Log Read Checkpo int Oracle Redo Logs 2015-03-03 21:45:44 seqno, RBA 22211584 SCN 0.1296506 (1 296506) Current Checkpoint detail:read Checkpoint #1 Oracle Redo Log Startup Checkpoint (starting position in the data so  Urce): Thread #: 1  Sequence #: rba:33336336 timestamp:2015-03-03 21:20:22.000000 scn:not available Redo file:recovery C Heckpoint (position of oldest unprocessed transaction in the data source): Thread #: 1 Sequence #: rba:222110 timestamp:2015-03-03 21:45:44.000000 scn:0.1296506 (1296506) Redo File:/OPT/ORACLE/ORADATA/ORCL11G/REDO03.L og current Checkpoint (position of last record, read in the data source): Thread #: 1 Sequence #: rba:2221158 4 timestamp:2015-03-03 21:45:44.000000 scn:0.1296506 (1296506) Redo File:/opt/oracle/oradata/orcl11g/redo03.lo  Gwrite Checkpoint #1 GGS Log Trail current Checkpoint (current write position): Sequence #: 0 rba:0 Timestamp: 2015-03-03 21:20:22.216536 Extract Trail:/ogg/dirdat/sawrite Checkpoint #2 GGS Log Trail current Checkpoint (Curren T write position): Sequence #: 0 rba:54236007 timestamp:2015-03-03 21:46:38.082286 Extract Trail:./dirdat/s ACSN State information: Crc:43-dd-d5-af Latest csn:1296177 Latest txn:5.8.1011 Latest CSN of finished txns:1296177 completed txns:5.8.10  11header:version = 2 Record Source = A Type = ten # Input checkpoints = 1 # Output checkpoints = 2File information: Block Size = 2048 Max Blocks = Record Length = 2048 current Offset = 0configuration:data Source = 3 Transaction  Integrity = 1 Task Type = 0status:start time = 2015-03-03 21:20:41 last Update time = 2015-03-03 21:46:38 Stop Status = A Last Result = Ggsci (ZBDBA1) 58> send extract ext1,showtranssending Showtrans request to extract EXT1 ... No Transactions foundoldest Redo log file necessary to restart Extract Is:redo log Sequence number, RBA 32715280.

Monitor goldengate Status