监控Goldengate状态(一)

2015-11-21 02:00:53 · 作者: · 浏览: 25

配置好goldengate之后,我们需要监控它的传输数据量,进程延迟,进程状态等信息,下面是一些具体的命令:

GGSCI (zbdba1) 36> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     RUNNING     EXT1        00:00:00      00:00:00   
EXTRACT     RUNNING     EXT2        00:00:00      00:00:09   


GGSCI (zbdba1) 37> status mgr

Manager is running (IP port zbdba1.7839).


GGSCI (zbdba1) 38> status extract ext1
EXTRACT EXT1: RUNNING


GGSCI (zbdba1) 39> info extract ext1,detail

EXTRACT    EXT1      Last Started 2015-03-03 21:20   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint  Oracle Redo Logs
                     2015-03-03 21:41:55  Seqno 48, RBA 22201344
                     SCN 0.1296423 (1296423)

  Target Extract Trails:

  Remote Trail Name                                Seqno        RBA     Max MB

  /ogg/dirdat/sa                                       0          0        100
  ./dirdat/sa                                          0   54236007        100

  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:20


Current directory    /ogg

Report file          /ogg/dirrpt/EXT1.rpt
Parameter file       /ogg/dirprm/ext1.prm
Checkpoint file      /ogg/dirchk/EXT1.cpe
Process file         /ogg/dirpcs/EXT1.pce
Stdout file          /ogg/dirout/EXT1.out
Error log            /ogg/ggserr.log


GGSCI (zbdba1) 40> send extract ext1 status

Sending STATUS request to EXTRACT EXT1 ...


EXTRACT EXT1 (PID 1839)
  Current status: Recovery complete: At EOF

  Current read position:
  Redo thread #: 1
  Sequence #: 48
  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/sa



GGSCI (zbdba1) 41> stats extract ext1

Sending 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.00 Output to ./dirdat/sa: Extracting from 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 2015-03-03 21:24:31 *** No database operations have been performed. *** Latest statistics since 2015-03-03 21:24:31 *** No database operations have 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 86589.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 Total updates 0.00 Total deletes 0.00 Total discards 0.00 Total operations 86589.00 Extracting 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.00 Total discards 0.00 Total operations 86592.00 *** Daily statistics since 2015-03-03 21:24:31 ***