源库:Oracle11g
目标库:SQL server2012
现在的情况是OGG已配置好了,
两端进程也开启,如图
Oracle端
SQL server端
并且数据文件也已经生成,如图
Oracle端
SQL server端目标端复制进程配置如下:
replicat REMSSQL
sourcedefs C:\oggmssql\dirdef\defgen.def
SETENV (NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK)
targetdb ogg userid sa, password P@ssw0rd
reperror default,discard
discardfile C:\oggmssql\dirrpt\REMSSQL.dsc,append,megabytes 100
map dbo.gehuantest,target gehuan.gehuantest;现在的问题是:
目标端SQL serve里面没有数据进来,各个进程也没有报错,所以不知道是什么原因导致的,求大神指点一二!谢谢!!
目标库:SQL server2012
现在的情况是OGG已配置好了,
两端进程也开启,如图
Oracle端
SQL server端
并且数据文件也已经生成,如图
Oracle端
SQL server端目标端复制进程配置如下:
replicat REMSSQL
sourcedefs C:\oggmssql\dirdef\defgen.def
SETENV (NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK)
targetdb ogg userid sa, password P@ssw0rd
reperror default,discard
discardfile C:\oggmssql\dirrpt\REMSSQL.dsc,append,megabytes 100
map dbo.gehuantest,target gehuan.gehuantest;现在的问题是:
目标端SQL serve里面没有数据进来,各个进程也没有报错,所以不知道是什么原因导致的,求大神指点一二!谢谢!!
这个路径就是目标端服务器的ogg路径,是没有错的
Checkpoint Lag 00:00:00 (updated 00:00:00 ago)
Process ID 2760
Log Read Checkpoint File C:\oggmssql\dirdat\REMSSQL\ex000000004
2019-10-30 14:31:19.830000 RBA 3929418
Current Checkpoint Detail:Read Checkpoint #1 GGS Log Trail Startup Checkpoint (starting position in the data source):
Sequence #: 4
RBA: 2620425
Timestamp: 2019-10-30 10:41:00.814000
Extract Trail: C:\oggmssql\dirdat\REMSSQL\ex
Seqno Length: 6 Current Checkpoint (position of last record read in the data s
Sequence #: 4
RBA: 3929418
Timestamp: 2019-10-30 14:31:19.830000
Extract Trail: C:\oggmssql\dirdat\REMSSQL\ex
Seqno Length: 9Header:
Version = 2
Record Source = A
Type = 1
# Input Checkpoints = 1
# Output Checkpoints = 0File Information:
Block Size = 2048
Max Blocks = 100
Record Length = 2048
Current Offset = 0Configuration:
Data Source = 0
Transaction Integrity = -1
Task Type = 0Database Checkpoint:
Checkpoint table = dbo.ckpttab
Key = 973516930 (0x3a06b082)
Create Time = 2019-10-30 10:39:54Status:
Start Time = 2019-10-30 14:38:29
Last Update Time = 2019-10-31 10:01:12
Stop Status = A
Last Result = 400
这是执行完的信息,看起来是没有报错
源端修改同步的表数据,过1分钟
send REPLICAT REMSSQL trace off看看日志信息
2019-10-30 14:31:19.830000 RBA 3929418
这个rba看着都已经往下走了呀,看着没啥问题