GoldenGate单向DDL同步(六)

2014-11-24 15:23:24 · 作者: · 浏览: 10
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
2013-04-17 13:13:46 INFO OGG-01513 Positioning to Sequence 14, RBA 31137296.
2013-04-17 13:13:46 INFO OGG-01516 Positioned to Sequence 14, RBA 31137296, Apr 17, 2013 1:13:17 PM.
2013-04-17 13:13:51 INFO OGG-01226 Socket buffer size set to 27985 (flush size 27985).
2013-04-17 13:13:51 INFO OGG-01055 Recovery initialization completed for target file /data/oracle/ogg11/dirdat/lt000004, at RBA 1046.
2013-04-17 13:13:51 INFO OGG-01478 Output file /data/oracle/ogg11/dirdat/lt is using format RELEASE 10.4/11.1.
2013-04-17 13:13:51 INFO OGG-01026 Rolling over remote file /data/oracle/ogg11/dirdat/lt000005.
2013-04-17 13:13:51 INFO OGG-01053 Recovery completed for target file /data/oracle/ogg11/dirdat/lt000005, at RBA 986.
2013-04-17 13:13:51 INFO OGG-01057 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
2013-04-17 13:13:51 INFO OGG-01517 Position of first record processed Sequence 14, RBA 31137296, SCN 0.1216816, Apr 17, 2013 1:13:17 PM.
目标库开启replicat进程,并检查info和report是否正常:
GGSCI (kf2.calvin) 14> start replicat test2
Sending START request to MANAGER ...
REPLICAT TEST2 starting
GGSCI (kf2.calvin) 15> info all
Program Status Group Lag Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING TEST2 00:00:00 00:00:05
GGSCI (kf2.calvin) 16> view report test2
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Linux, x64, 64bit (optimized), Oracle 11g on Oct 7 2011 05:44:59
Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.
Starting at 2013-04-17 13:19:20
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Tue May 10 15:42:40 EDT 2011, Release 2.6.32-131.0.15.el6.x86_64
Node: kf2.calvin
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 5858
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
replicat test2
ASSUMETARGETDEFS
userid ogguser@test2,password *******
discardfile /data/oracle/ogg11/dirdat/test2_discard.txt,append, megabytes 10
DDL INCLUDE MAPPED
DDLERROR DEFAULT IGNORE RETRYOP
map stat.*, target stat.*;
CACHEMGR virtual memory