Oracle GoldenGate 学习教程二、配置和使用(5)

源端进程信息

GGSCI (sywu) 4> info ESYDB001,detail EXTRACT ESYDB001 Last Started 2015-08-26 09:52 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:10 ago) Process ID 14619 Log Read Checkpoint Oracle Redo Logs 2015-08-26 09:58:11 Seqno 13, RBA 1942016 SCN 0.575310 (575310) Target Extract Trails: Trail Name Seqno RBA Max MB Trail Type /u01/app/product/ogg_src/dirdat/es 4 1481 100 EXTTRAIL Extract Source Begin End /u01/oradata/sydb/redo01.log 2015-08-26 09:52 2015-08-26 09:58 /u01/oradata/sydb/redo01.log 2015-08-26 09:49 2015-08-26 09:52 /u01/oradata/sydb/redo01.log 2015-08-26 09:43 2015-08-26 09:49 /u01/oradata/sydb/redo01.log 2015-08-26 09:40 2015-08-26 09:43 /u01/oradata/sydb/redo01.log 2015-08-25 20:43 2015-08-26 09:40 Not Available * Initialized * 2015-08-25 20:43 Not Available * Initialized * 2015-08-25 20:43 Current directory /u01/app/product/ogg_src Report file /u01/app/product/ogg_src/dirrpt/ESYDB001.rpt Parameter file /u01/app/product/ogg_src/dirprm/esydb001.prm Checkpoint file /u01/app/product/ogg_src/dirchk/ESYDB001.cpe Process file /u01/app/product/ogg_src/dirpcs/ESYDB001.pce Error log /u01/app/product/ogg_src/ggserr.log GGSCI (sywu) 5> info PSYDB001,detail EXTRACT PSYDB001 Last Started 2015-08-26 09:52 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:04 ago) Process ID 14648 Log Read Checkpoint File /u01/app/product/ogg_src/dirdat/es000004 2015-08-26 09:52:50.035063 RBA 1481 Target Extract Trails: Trail Name Seqno RBA Max MB Trail Type /u01/app/product/ogg_trg/dirdat/ps 0 0 100 EXTTRAIL Extract Source Begin End /u01/app/product/ogg_src/dirdat/es000004 * Initialized * 2015-08-26 09:52 /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record /u01/app/product/ogg_src/dirdat/es000000 * Initialized * First Record Current directory /u01/app/product/ogg_src Report file /u01/app/product/ogg_src/dirrpt/PSYDB001.rpt Parameter file /u01/app/product/ogg_src/dirprm/psydb001.prm Checkpoint file /u01/app/product/ogg_src/dirchk/PSYDB001.cpe Process file /u01/app/product/ogg_src/dirpcs/PSYDB001.pce Error log /u01/app/product/ogg_src/ggserr.log GGSCI (sywu) 6> stats ESYDB001 Sending STATS request to EXTRACT ESYDB001 ... No active extraction maps. GGSCI (sywu) 7> stats PSYDB001 Sending STATS request to EXTRACT PSYDB001 ... No active extraction maps.

目标端进程信息

GGSCI (sywu) 5> info RSYDB001,detail REPLICAT RSYDB001 Last Started 2015-08-26 09:55 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:08 ago) Process ID 15105 Log Read Checkpoint File /u01/app/product/ogg_trg/dirdat/ps000008 First Record RBA 2032 Current Log BSN value: (requires database login) Last Committed Transaction CSN value: (requires database login) Extract Source Begin End /u01/app/product/ogg_trg/dirdat/ps000008 2015-08-26 09:52 First Record /u01/app/product/ogg_trg/dirdat/ps000008 2015-08-25 13:58 2015-08-26 09:52 /u01/app/product/ogg_trg/dirdat/ps000006 2015-08-25 13:49 2015-08-25 13:58 /u01/app/product/ogg_trg/dirdat/ps000006 2015-08-25 13:49 2015-08-25 13:49 /u01/app/product/ogg_trg/dirdat/ps000006 2015-08-25 13:49 2015-08-25 13:49 /u01/app/product/ogg_trg/dirdat/ps000006 * Initialized * 2015-08-25 13:49 /u01/app/product/ogg_trg/dirdat/ps000006 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record /u01/app/product/ogg_trg/dirdat/ps000000 * Initialized * First Record Current directory /u01/app/product/ogg_trg Report file /u01/app/product/ogg_trg/dirrpt/RSYDB001.rpt Parameter file /u01/app/product/ogg_trg/dirprm/rsydb001.prm Checkpoint file /u01/app/product/ogg_trg/dirchk/RSYDB001.cpr Checkpoint table OGG_TRG.OGG_CHK Process file /u01/app/product/ogg_trg/dirpcs/RSYDB001.pcr Error log /u01/app/product/ogg_trg/ggserr.log GGSCI (sywu) 6> stats RSYDB001 Sending STATS request to REPLICAT RSYDB001 ... No active replication maps.

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/34cc0a588956ba1ccf7320b8e7f0a08e.html