ITPub博客

首页 > 数据库 > Oracle > goldengate命令输入错误导致的血案2

goldengate命令输入错误导致的血案2

原创 Oracle 作者:msdnchina 时间:2011-04-16 20:54:26 0 删除 编辑

环境介绍:

源头:rhel5 32bit,oracle10.2.0.4 32bit ,goldengate v11.1.1 for oracle 10g 32bit

目的地:rhel5 32bit,oracle10.2.0.4 32bit ,goldengate v11.1.1 for oracle 10g 32bit

源头的goldengate 配置没有问题,info all 命令都是running

目的地的goldengate 配置看似没有问题,虽然info all 命令都是running

从源头做了几个dml操作后,查看源头extract进程和datapump进程的统计信息:

stats extract ext 和 stats extract datapump,都反馈如下的结果


*** Daily statistics since 2011-04-15 21:12:07 ***
Total inserts 1.00
Total updates 0.00
Total deletes 1.00
Total discards 0.00
Total operations 2.00

查看目的地的replicat进程的统计信息 stats replicat rep

GGSCI (host1) 1> stats replicat rep

Sending STATS request to REPLICAT REP ...

No active replication maps
DDL replication statistics:

*** Total statistics since replicat started ***
Operations 0.00
Mapped operations 0.00
Unmapped operations 0.00
Other operations 0.00
Excluded operations 0.00
Errors 0.00
Retried errors 0.00
Discarded errors 0.00
Ignored errors 0.00

后来发现居然是目的端add replicat 命令写错了:

错误的:add replicat rep, exttrail /u01/dirdat/bj , CHECKPOINTTABLE goldengate.ckpttable

正确的:add replicat rep, exttrail /u01/ggs/dirdat/bj , CHECKPOINTTABLE goldengate.ckpttable

此问题是通过查看原始的部署脚本看出来的(部署脚本就写错了)

此问题也可以通过如下命令查看rep进程和trail文件的对应关系:

GGSCI (host1) 11> info replicat rep, detail

REPLICAT REP Last Started 2011-04-15 21:12 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Log Read Checkpoint File /u01/dirdat/bj000000
First Record RBA 0[@more@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/161195/viewspace-1048758/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1542051