OGG状态都是RUNING，但是目标端不同步是咋回事

[sxq129601]

我在源端创建了一个表，然后插入几条数据。但是目标端没有创建表和数据，信息如下：

=============================源端========================
GGSCI (ogg1) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING DPUMP1 00:00:00 00:00:04
EXTRACT RUNNING EXT1 00:00:00 00:00:07

GGSCI (ogg1) 3> stats dpump1

Sending STATS request to EXTRACT DPUMP1 ...

Start of Statistics at 2019-09-26 09:52:05.

Output to /home/oracle/app/oracle/product/ogg_trg/dirdat/sr:

Extracting from SCOTT.AA to SCOTT.AA:

*** Total statistics since 2019-09-26 09:17:59 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 6.00

*** Daily statistics since 2019-09-26 09:17:59 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 6.00

*** Hourly statistics since 2019-09-26 09:17:59 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 6.00

*** Latest statistics since 2019-09-26 09:17:59 ***
Total inserts 6.00
Total updates 0.00
Total deletes 0.00
Total discards 0.00
Total operations 6.00

End of Statistics.


GGSCI (ogg1) 9> view param dpump1

extract dpump1
SETENV(ORACLE_SID="orcl")
SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ogg,password ogg
RMTHOST 192.168.60.135, mgrport 7809, COMPRESS
PASSTHRU
RMTTRAIL /home/oracle/app/oracle/product/ogg_trg/dirdat/sr
--DYNAMICRESOLUTION
table scott.*;


GGSCI (ogg1) 11> view param ext1

extract ext1
SETENV(ORACLE_SID="orcl")
SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ogg, password ogg
REPORTCOUNT EVERY 30 MINUTES, RATE
DISCARDFILE /home/oracle/app/oracle/product/ogg_src/dirrpt/extsr.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 3:00
EXTTRAIL /home/oracle/app/oracle/product/ogg_src/dirdat/sr
DYNAMICRESOLUTION
DBOPTIONS ALLOWUNUSEDCOLUMN
FETCHOPTIONS NOUSESNAPSHOT
FETCHOPTIONS FETCHPKUPDATECOLS
table scott.*;


=============================目标库=======================

GGSCI (ogg2) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:02


GGSCI (ogg2) 2> stats rep1

Sending STATS request to REPLICAT REP1 ...

No active replication maps.


GGSCI (ogg2) 3> view param rep1

REPLICAT rep1
SETENV(ORACLE_SID="orcl2")
SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg, PASSWORD ogg
REPORT AT 06:00
REPORTCOUNT EVERY 30 MINUTES, RATE
REPORTROLLOVER AT 02:00
REPERROR DEFAULT, ABEND
ALLOWNOOPUPDATES
ASSUMETARGETDEFS
HANDLECOLLISIONS
DISCARDFILE /home/oracle/app/oracle/product/ogg_trg/dirrpt/repsa.dsc, APPEND, MEGABYTES 1024
DISCARDROLLOVER AT 02:00
MAP scott.*, target scott.*;

[sxq129601]

引用 1 楼 自由与责任 的回复:

你在源端启用ddl复制了吗？各种前提环境条件都做了吗？

我后来删除dirdat目录重做，只添加一条记录，也不能同步。目标库的dirdat已经有文件过来，但是目标库的进程没有抽取。 GGSCI (ogg2) 1> stats rep1 Sending STATS request to REPLICAT REP1 ... No active replication maps.

[好记忆不如烂笔头abc]

你在源端启用ddl复制了吗？各种前提环境条件都做了吗？

[life8207]

OGG环境是新搭建的不，怎么判断是没有抽取的？info rep1看看；然后看看dirdat中文件有哪些

[天凯科技]

如果目标端stats没信息，你先看看trail文件有没传过来？另外看看源端的ogg日志有没报错，我估计是网络层面问题或配置有问题！