配置好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 ***