ogg奇怪的问题 goldengate同步无反应,不成功,ggserr.log也没有报错日志,进程不abended

magikarp 2013-03-26 11:56:55
goldengate里,做好了extract,data pump,replicat进程了。也都是running,不过在测试同步的时候,同步没有实现。
再查看info all。里边的进程也还都是running。没abended。
查看ggserr.log,里边除了启动进程的内容,也没有报错

我的操作是,增加extract,data dump,replicat
然后用带有scn的expdp导出初始化文件,然后impdp导入
之后启动extract,data dump
replicat使用afterscn启动。
所有启动均成功,但就是在操作数据后,没有同步过去

这里是配置
GGSCI (kwtest2) 2> info extract extin
EXTRACT EXTIN Last Started 2013-03-26 10:27 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint Oracle Redo Logs
2013-03-26 11:44:00 Seqno 206, RBA 51043840
SCN 2.119033909 (8708968501)

GGSCI (kwtest2) 3> info extract dumpin
EXTRACT DUMPIN Last Started 2013-03-26 10:27 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:03 ago)
Log Read Checkpoint File /home/oracle/goldengate/dirdat/source/in000000
2013-03-26 10:30:11.000000 RBA 1181

GGSCI (kwtest2) 4> info replicat repin
REPLICAT REPIN Last Started 2013-03-26 10:29 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:04 ago)
Log Read Checkpoint File /home/oracle/goledengate/dirdat/target/in000000
First Record RBA 0

GGSCI (kwtest2) 5>


这里是ggserr.log的末位20行

[root@kwtest2 goldengate]# tail -n 20 ggserr.log
2013-03-26 10:27:42 INFO OGG-01677 Oracle GoldenGate Collector for Oracle: Waiting for connection (started dynamically).
2013-03-26 10:27:42 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from SERVER on host localhost.localdomain (REPORT 12998 7820).
2013-03-26 10:27:42 INFO OGG-00974 Oracle GoldenGate Manager for Oracle, mgr.prm: Manager started collector process (Port 7820).
2013-03-26 10:27:42 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.
2013-03-26 10:27:47 INFO OGG-01226 Oracle GoldenGate Capture for Oracle, dumpin.prm: Socket buffer size set to 27985 (flush size 27985).
2013-03-26 10:27:47 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to kwtest2:14768.
2013-03-26 10:27:47 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, dumpin.prm: No recovery is required for target file /home/oracle/goldengate/dirdat/target/in000000, at RBA 0 (file not opened).
2013-03-26 10:27:47 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, dumpin.prm: Output file /home/oracle/goldengate/dirdat/target/in is using format RELEASE 11.2.
2013-03-26 10:27:47 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening /home/oracle/goldengate/dirdat/target/in000000 (byte -1, current EOF 0).
2013-03-26 10:29:10 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start repin aftercsn 8708960303.
2013-03-26 10:29:10 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host kwtest2 (START REPLICAT REPIN AFTERCSN 8708960303).
2013-03-26 10:29:10 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REPIN starting.
2013-03-26 10:29:11 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, repin.prm: REPLICAT REPIN starting.
2013-03-26 10:29:11 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, repin.prm: Operating system character set identified as gb18030. Locale: zh_CN, LC_ALL:.
2013-03-26 10:29:11 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, repin.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/home/oracle/goldengate/dirtmp.
2013-03-26 10:29:11 INFO OGG-00996 Oracle GoldenGate Delivery for Oracle, repin.prm: REPLICAT REPIN started.
[root@kwtest2 goldengate]#

请问还有什么地方能查看到哪里出了问题了吗?
...全文
3840 6 打赏 收藏 转发到动态 举报
写回复
用AI写文章
6 条回复
切换为时间正序
请发表友善的回复…
发表回复
qq_14809795 2014-09-12
  • 打赏
  • 举报
回复
投递进程pump最可能有问题 举例add extract pump1,exttrailsource /app/oracle/goldengate/dirdat/wf add rmttrail /app/oracle/goldengate/dirdat/pf, extract pump1 确保参数配置与上面路径相匹配
小灰狼W 2014-08-26
  • 打赏
  • 举报
回复
恐怕是ext或rep进程的同步对象没有配置好
zhengcairong520hu 2014-08-26
  • 打赏
  • 举报
回复
为什么楼主不能够分享一下你的解决方法呢?
soar_angel 2014-04-02
  • 打赏
  • 举报
回复
怎么解决的?遇到同样的问题了,楼主共享一下吧
  • 打赏
  • 举报
回复
我也遇到相同问题,你是如何解决的?
magikarp 2013-03-26
  • 打赏
  • 举报
回复
自己找到问题了,犯2了

3,499

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧