ogg sqlserver mysql_时间不同步导致ogg部署异常 – 提供7*24专业数据库(Oracle,SQL Server,MySQL等)恢复和Oracle技术服务@Tel:+86 1342...

最新推荐文章于 2022-08-22 18:10:05 发布
最新推荐文章于 2022-08-22 18:10:05 发布
阅读量659 收藏
点赞数
文章标签： ogg sqlserver mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_35476730/article/details/113469613
版权

一、错误检查

[oracle@srtcreen ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700

Linux, x64, 64bit (optimized), Oracle 10g on Jul 29 2011 19:43:29

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

GGSCI (srtcreen) 1> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING R_1 00:00:00 00:00:07

REPLICAT RUNNING R_2 00:00:00 00:00:05

REPLICAT ABENDED R_3 19:19:34 00:17:33

REPLICAT STOPPED R_4 00:00:00 19:44:24

REPLICAT STOPPED R_5 00:00:00 19:44:13

GGSCI (srtcreen) 2> view report r_3

***********************************************************************

Oracle GoldenGate Delivery for Oracle

Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700

Linux, x64, 64bit (optimized), Oracle 10g on Sep 13 2011 21:33:03

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

Starting at 2011-12-02 16:36:58

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Fri Apr 2 14:58:14 EDT 2010, Release 2.6.18-194.el5

Node: srtcreen

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: 13398

Description:

***********************************************************************

** Running with the following parameters **

***********************************************************************

replicat r_3

ASSUMETARGETDEFS

HANDLECOLLISIONS

SETENV (NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)

Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

userid it1ogg, password ********

--file for dicarded transaction --

discardfile /opt/OGG/discard/R_3.txt, append, megabytes 100

DDL

MAP CSCNEW.TAB_CS_CALL_PICKUP, TARGET SRT_CREEN.TAB_CS_CALL_PICKUP, KEYCOLS (CALL_ID);

CACHEMGR virtual memory values (may have been adjusted)

CACHEBUFFERSIZE: 64K

CACHESIZE: 512M

CACHEBUFFERSIZE (soft max): 4M

CACHEPAGEOUTSIZE (normal): 4M

PROCESS VM AVAIL FROM OS (min): 1G

CACHESIZEMAX (strict force to disk): 881M

Database Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

Database Language and Character Set:

NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"

NLS_LANGUAGE = "AMERICAN"

NLS_TERRITORY = "AMERICA"

NLS_CHARACTERSET = "ZHS16GBK"

For further information on character set settings, please refer to user manual.

***********************************************************************

** Run Time Messages **

***********************************************************************

Opened trail file /opt/OGG/dirdat/U3000000 at 2011-12-02 16:36:58

MAP resolved (entry CSCNEW.TAB_CS_CALL_PICKUP):

MAP CSCNEW.TAB_CS_CALL_PICKUP, TARGET SRT_CREEN.TAB_CS_CALL_PICKUP, KEYCOLS (CALL_ID);

Using following columns in default map by name:

PICKUP_ID, CALL_ID, CALL_SERIAL, USER_ID, PICKUP_TIME, CALL_RESULT,

FAIL_REASON, CALL_TIME, CALL_DURA, END_TIME

Using the following key columns for target table SRT_CREEN.TAB_CS_CALL_PICKUP: CALL_ID.

2011-12-02 16:36:58 WARNING OGG-00869 OCI Error ORA-01407: cannot update ("SRT_CREEN"."TAB_CS_CALL_PICKUP"."PICKUP_ID") to NULL (status = 1407), SQL

E "SRT_CREEN"."TAB_CS_CALL_PICKUP" SET "PICKUP_ID" = :a0,"CALL_SERIAL" = :a2,"USER_ID" = :a3,"PICKUP_TIME" = :a4,"CALL_RESULT" = :a5,"FAIL_REASON" = :a6,"CAL

L_TIME" = :a7,"CALL_DURA" = :a8,"END_T>.

2011-12-02 16:36:58 WARNING OGG-01004 Aborted grouped transaction on 'SRT_CREEN.TAB_CS_CALL_PICKUP', Database error 1407 (OCI Error ORA-01407: cannot updat

e ("SRT_CREEN"."TAB_CS_CALL_PICKUP"."PICKUP_ID") to NULL (status = 1407), SQL

:a2,"USER_ID" = :a3,"PICKUP_TIME" = :a4,"CALL_RESULT" = :a5,"FAIL_REASON" = :a6,"CALL_TIME" = :a7,"CALL_DURA" = :a8,"END_T>).

2011-12-02 16:36:58 WARNING OGG-01003 Repositioning to rba 924 in seqno 0.

2011-12-02 16:36:59 WARNING OGG-01154 SQL error 1407 mapping CSCNEW.TAB_CS_CALL_PICKUP to SRT_CREEN.TAB_CS_CALL_PICKUP OCI Error ORA-01407: cannot update (

"SRT_CREEN"."TAB_CS_CALL_PICKUP"."PICKUP_ID") to NULL (status = 1407), SQL

,"USER_ID" = :a3,"PICKUP_TIME" = :a4,"CALL_RESULT" = :a5,"FAIL_REASON" = :a6,"CALL_TIME" = :a7,"CALL_DURA" = :a8,"END_T>.

2011-12-02 16:36:59 WARNING OGG-01003 Repositioning to rba 924 in seqno 0.

***********************************************************************

* ** Run Time Statistics ** *

***********************************************************************

Last record for the last committed transaction is the following:

___________________________________________________________________

Trail name : /opt/OGG/dirdat/U3000000

Hdr-Ind : E (x45) Partition : . (x04)

UndoFlag : . (x00) BeforeAfter: A (x41)

RecLength : 157 (x009d) IO Time : 2011-12-01 21:17:24.084108

IOType : 15 (x0f) OrigNode : 255 (xff)

TransInd : . (x03) FormatType : R (x52)

SyskeyLen : 0 (x00) Incomplete : . (x00)

AuditRBA : 3225 AuditPos : 42227728

Continued : N (x00) RecCount : 1 (x01)

2011-12-01 21:17:24.084108 FieldComp Len 157 RBA 924

Name: CSCNEW.TAB_CS_CALL_PICKUP

___________________________________________________________________

Reading /opt/OGG/dirdat/U3000000, current RBA 924, 0 records

Report at 2011-12-02 16:36:59 (activity since 2011-12-02 16:36:58)

From Table CSCNEW.TAB_CS_CALL_PICKUP to SRT_CREEN.TAB_CS_CALL_PICKUP:

# inserts: 0

# updates: 0

# deletes: 0

# discards: 1

DDL replication statistics:

Operations: 0

Mapped operations: 0

Unmapped operations: 0

Other operations: 0

Excluded operations: 0

Errors: 0

Retried errors: 0

Discarded errors: 0

Ignored errors: 0

Last log location read:

FILE: /opt/OGG/dirdat/U3000000

SEQNO: 0

RBA: 924

TIMESTAMP: 2011-12-01 21:17:24.084108

EOF: NO

READERR: 0

2011-12-02 16:36:59 ERROR OGG-01668 PROCESS ABENDING.

--发现奇怪现象，我2011-12-02早上过来检查这个，发现时间竟然显示2011-12-02 16:36:59，第一反应系统时间错误,继续检查

GGSCI (srtcreen) 2> info r_2

REPLICAT R_2 Last Started 2011-12-01 21:09 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:05 ago)

Log Read Checkpoint File /opt/OGG/dirdat/U2000000

2011-12-02 17:01:29.927591 RBA 6234

GGSCI (srtcreen) 3> exit

[oracle@srtcreen OGG]$ cd dirdat

[oracle@srtcreen dirdat]$ ll

total 396

-rw-rw-rw- 1 oracle oinstall 0 Dec 1 21:10 U1000000

-rw-rw-rw- 1 oracle oinstall 5984 Dec 2 05:36 U2000000

-rw-rw-rw- 1 oracle oinstall 392258 Dec 2 16:52 U3000000

[oracle@srtcreen dirdat]$ stat U3000000

File: `U3000000'

Size: 392258 Blocks: 776 IO Block: 4096 regular file

Device: fd00h/64768d Inode: 213844220 Links: 1

Access: (0666/-rw-rw-rw-) Uid: ( 501/ oracle) Gid: ( 501/oinstall)

Access: 2011-12-02 16:36:59.000000000 +0800

Modify: 2011-12-02 16:52:55.000000000 +0800

Change: 2011-12-02 16:52:55.000000000 +0800

###############查看源端数据库服务器时间#####################

[oracle@tykf ~]$ date

Fri Dec 2 08:50:10 CST 2011

[oracle@tykf ~]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.0.0 Build 078

Linux, x64, 64bit (optimized), Oracle 10 on Jul 28 2010 13:21:11

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

GGSCI (tykf) 1> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING EXT_1 00:00:00 00:00:05

EXTRACT RUNNING EXT_2 00:00:00 00:00:01

EXTRACT RUNNING EXT_3 00:00:00 00:00:05

EXTRACT STOPPED EXT_4 00:00:00 21:59:56

EXTRACT STOPPED EXT_5 00:00:00 21:59:28

EXTRACT RUNNING P_1 00:00:00 00:00:04

EXTRACT RUNNING P_2 00:00:00 00:00:04

EXTRACT RUNNING P_3 00:00:00 00:00:05

EXTRACT STOPPED P_4 00:00:00 21:56:42

EXTRACT STOPPED P_5 00:00:00 21:56:11

GGSCI (tykf) 2> info ext_3

EXTRACT EXT_3 Last Started 2011-12-01 13:11 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:03 ago)

Log Read Checkpoint Oracle Redo Logs

2011-12-02 08:50:06 Seqno 3233, RBA 32267264

GGSCI (tykf) 3> info p_3

EXTRACT P_3 Last Started 2011-12-01 13:11 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:00 ago)

Log Read Checkpoint File /opt/OGG/dirdat/extract/A3000000

2011-12-02 08:50:15.000000 RBA 393705

--ext_3和p_3是目标端r_3的对应进程

#######################################################################

果然是系统时间错误，源端和目标端相差了近八个小时

二、更正目标端时间

[oracle@srtcreen dirdat]$ date

Fri Dec 2 16:55:55 CST 2011

[oracle@srtcreen OGG]$ su - root

Password:

[root@srtcreen ~]# date -s 08:58:20

Fri Dec 2 08:58:20 CST

[root@srtcreen ~]# clock -w

[root@srtcreen ~]# date

Fri Dec 2 08:58:28 CST

[root@srtcreen ~]# su - oracle

[oracle@srtcreen dirdat]$ ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700

Linux, x64, 64bit (optimized), Oracle 10g on Jul 29 2011 19:43:29

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

GGSCI (srtcreen) 1> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING R_1 00:00:00 unknown

REPLICAT RUNNING R_2 00:00:00 unknown

REPLICAT ABENDED R_3 19:19:34 unknown

REPLICAT STOPPED R_4 00:00:00 11:54:31

REPLICAT STOPPED R_5 00:00:00 11:54:20

[oracle@srtcreen OGG]$ cd dirdat

[oracle@srtcreen dirdat]$ ll

total 412

-rw-rw-rw- 1 oracle oinstall 0 Dec 1 21:10 U1000000

-rw-rw-rw- 1 oracle oinstall 6485 Dec 2 2011 U2000000

-rw-rw-rw- 1 oracle oinstall 407519 Dec 2 09:04 U3000000

最新写到目标端的数据已经是当前修改时间(这个是系统时间，肯定会修改过来)

出现Time Since Chkpt unknown，处理方法见ogg中Time Since Chkpt显示unknown解决

三、重设r_3时间点

GGSCI (srtcreen) 7> alter r_3,begin 2011-12-02 09:00:00

REPLICAT altered.

GGSCI (srtcreen) 9> start r_3

Sending START request to MANAGER ...

REPLICAT R_3 starting

GGSCI (srtcreen) 10> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING R_1 00:00:00 00:00:05

REPLICAT RUNNING R_2 00:00:00 00:00:02

REPLICAT ABENDED R_3 unknown 00:00:00

REPLICAT STOPPED R_4 00:00:00 11:55:40

REPLICAT STOPPED R_5 00:00:00 11:55:29

GGSCI (srtcreen) 11> view report r_3

***********************************************************************

Oracle GoldenGate Delivery for Oracle

Version 11.1.1.1.1 OGGCORE_11.1.1.1.1_PLATFORMS_110729.1700

Linux, x64, 64bit (optimized), Oracle 10g on Sep 13 2011 21:33:03

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

Starting at 2011-12-02 09:09:31

***********************************************************************

Operating System Version:

Linux

Version #1 SMP Fri Apr 2 14:58:14 EDT 2010, Release 2.6.18-194.el5

Node: srtcreen

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: 13629

Description:

***********************************************************************

** Running with the following parameters **

***********************************************************************

replicat r_3

ASSUMETARGETDEFS

HANDLECOLLISIONS

SETENV (NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)

Set environment variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

userid it1ogg, password ********

--file for dicarded transaction --

discardfile /opt/OGG/discard/R_3.txt, append, megabytes 100

DDL

MAP CSCNEW.TAB_CS_CALL_PICKUP, TARGET SRT_CREEN.TAB_CS_CALL_PICKUP, KEYCOLS (CALL_ID);

CACHEMGR virtual memory values (may have been adjusted)

CACHEBUFFERSIZE: 64K

CACHESIZE: 512M

CACHEBUFFERSIZE (soft max): 4M

CACHEPAGEOUTSIZE (normal): 4M

PROCESS VM AVAIL FROM OS (min): 1G

CACHESIZEMAX (strict force to disk): 881M

Database Version:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi

PL/SQL Release 10.2.0.4.0 - Production

CORE 10.2.0.4.0 Production

TNS for Linux: Version 10.2.0.4.0 - Production

NLSRTL Version 10.2.0.4.0 - Production

Database Language and Character Set:

NLS_LANG = "AMERICAN_AMERICA.ZHS16GBK"

NLS_LANGUAGE = "AMERICAN"

NLS_TERRITORY = "AMERICA"

NLS_CHARACTERSET = "ZHS16GBK"

For further information on character set settings, please refer to user manual.

***********************************************************************

** Run Time Messages **

***********************************************************************

Opened trail file /opt/OGG/dirdat/U3000000 at 2011-12-02 09:09:32

MAP resolved (entry CSCNEW.TAB_CS_CALL_PICKUP):

MAP CSCNEW.TAB_CS_CALL_PICKUP, TARGET SRT_CREEN.TAB_CS_CALL_PICKUP, KEYCOLS (CALL_ID);

Using following columns in default map by name:

PICKUP_ID, CALL_ID, CALL_SERIAL, USER_ID, PICKUP_TIME, CALL_RESULT,

FAIL_REASON, CALL_TIME, CALL_DURA, END_TIME

Using the following key columns for target table SRT_CREEN.TAB_CS_CALL_PICKUP: CALL_ID.

2011-12-02 09:09:32 WARNING OGG-00869 OCI Error ORA-01407: cannot update ("SRT_CREEN"."TAB_CS_CALL_PICKUP"."PICKUP_ID") to NULL (status = 1407), SQL

E "SRT_CREEN"."TAB_CS_CALL_PICKUP" SET "PICKUP_ID" = :a0,"CALL_SERIAL" = :a2,"USER_ID" = :a3,"PICKUP_TIME" = :a4,"CALL_RESULT" = :a5,"FAIL_REASON" = :a6,"CAL

L_TIME" = :a7,"CALL_DURA" = :a8,"END_T>.

2011-12-02 09:09:32 WARNING OGG-01004 Aborted grouped transaction on 'SRT_CREEN.TAB_CS_CALL_PICKUP', Database error 1407 (OCI Error ORA-01407: cannot updat

e ("SRT_CREEN"."TAB_CS_CALL_PICKUP"."PICKUP_ID") to NULL (status = 1407), SQL

:a2,"USER_ID" = :a3,"PICKUP_TIME" = :a4,"CALL_RESULT" = :a5,"FAIL_REASON" = :a6,"CALL_TIME" = :a7,"CALL_DURA" = :a8,"END_T>).

2011-12-02 09:09:32 WARNING OGG-01003 Repositioning to rba 375833 in seqno 0.

2011-12-02 09:09:32 WARNING OGG-01154 SQL error 1407 mapping CSCNEW.TAB_CS_CALL_PICKUP to SRT_CREEN.TAB_CS_CALL_PICKUP OCI Error ORA-01407: cannot update (

"SRT_CREEN"."TAB_CS_CALL_PICKUP"."PICKUP_ID") to NULL (status = 1407), SQL

,"USER_ID" = :a3,"PICKUP_TIME" = :a4,"CALL_RESULT" = :a5,"FAIL_REASON" = :a6,"CALL_TIME" = :a7,"CALL_DURA" = :a8,"END_T>.

2011-12-02 09:09:32 WARNING OGG-01003 Repositioning to rba 375833 in seqno 0.

Source Context :

SourceModule : [er.main]

SourceID : [/scratch/angorant/view_storage/angorant_ogg_12978807_x64/oggcore/OpenSys/src/app/er/rep.c]

SourceFunction : [take_rep_err_action]

SourceLine : [16134]

ThreadBacktrace : [8] elements

: [/opt/OGG/replicat(CMessageContext::AddThreadContext()+0x26) [0x5ef8b6]]

: [/opt/OGG/replicat(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x7b2) [0x5e6382]]

: [/opt/OGG/replicat(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, DBString<777> const&, DBString<777> const&, CMessageFactory::Me

ssageDisposition)+0x9b) [0x5c4bcb]]

: [/opt/OGG/replicat [0x81ac2f]]

: [/opt/OGG/replicat [0x8f73e2]]

: [/opt/OGG/replicat(main+0x84b) [0x50764b]]

: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3e2f41d994]]

: [/opt/OGG/replicat(__gxx_personality_v0+0x1da) [0x4e3c2a]]

2011-12-02 09:09:32 ERROR OGG-01296 Error mapping from CSCNEW.TAB_CS_CALL_PICKUP to SRT_CREEN.TAB_CS_CALL_PICKUP.

***********************************************************************

* ** Run Time Statistics ** *

***********************************************************************

Last record for the last committed transaction is the following:

___________________________________________________________________

Trail name : /opt/OGG/dirdat/U3000000

Hdr-Ind : E (x45) Partition : . (x04)

UndoFlag : . (x00) BeforeAfter: A (x41)

RecLength : 157 (x009d) IO Time : 2011-12-02 11:52:49.559112

IOType : 15 (x0f) OrigNode : 255 (xff)

TransInd : . (x03) FormatType : R (x52)

SyskeyLen : 0 (x00) Incomplete : . (x00)

AuditRBA : 3233 AuditPos : 8194064

Continued : N (x00) RecCount : 1 (x01)

2011-12-02 11:52:49.559112 FieldComp Len 157 RBA 375833

Name: CSCNEW.TAB_CS_CALL_PICKUP

___________________________________________________________________

Reading /opt/OGG/dirdat/U3000000, current RBA 375833, 0 records

Report at 2011-12-02 09:09:32 (activity since 2011-12-02 09:09:32)

From Table CSCNEW.TAB_CS_CALL_PICKUP to SRT_CREEN.TAB_CS_CALL_PICKUP:

# inserts: 0

# updates: 0

# deletes: 0

# discards: 1

DDL replication statistics:

Operations: 0

Mapped operations: 0

Unmapped operations: 0

Other operations: 0

Excluded operations: 0

Errors: 0

Retried errors: 0

Discarded errors: 0

Ignored errors: 0

Last log location read:

FILE: /opt/OGG/dirdat/U3000000

SEQNO: 0

RBA: 375833

TIMESTAMP: 2011-12-02 11:52:49.559112

EOF: NO

READERR: 0

2011-12-02 09:09:32 ERROR OGG-01668 PROCESS ABENDING.

--这里可以看出我重设的当前的时间点对应的io time为2011-12-02 11:52:49.559112,而现在尚未到这个时间，进程启动失败

GGSCI (srtcreen) 2> alter r_3,begin 2011-12-02 18:00:00

REPLICAT altered.

--重设时间到今天早上我重设时间之前的错误时间之后

GGSCI (srtcreen) 3> start r_3

Sending START request to MANAGER ...

REPLICAT R_3 starting

GGSCI (srtcreen) 4> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING R_1 00:00:00 00:00:06

REPLICAT RUNNING R_2 00:00:00 00:00:01

REPLICAT RUNNING R_3 unknown 00:00:08

REPLICAT RUNNING R_4 00:00:00 00:00:09

REPLICAT RUNNING R_5 00:00:00 00:00:09

GGSCI (srtcreen) 5> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING R_1 00:00:00 00:00:09

REPLICAT RUNNING R_2 00:00:00 00:00:03

REPLICAT RUNNING R_3 00:00:00 00:00:00

REPLICAT RUNNING R_4 00:00:00 00:00:02

REPLICAT RUNNING R_5 00:00:00 00:00:01

GGSCI (srtcreen) 6> stats r_3

Sending STATS request to REPLICAT R_3 ...

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

--进程启动，工作正常

三、补充说明

1、部署ogg前需要核对两边时间是否相同，为了避免不必要的麻烦，建议配置ntp同步时间

2、这里因为我们这要求该同步上线无严格时间要求，所以通过重设r_3时间点实现工作正常，如果事情比较紧急，建议删除trail文件，重建pump和replicat进程

3、这里说明ogg同步也还不是和时间一点关系都没有

goldengate sqlserver mysql_使用 Oracle GoldenGate 在 Microsoft SQL Server 和 Oracle Database 之间复制事务...
weixin_39907713的博客
02-15 194
大多数关注数据复制的 Oracle 技术专家都熟悉 Oracle Streams。在 2009 年之前，Streams 一直是推荐使用的最流行的 Oracle 数据分发技术。2009 年 7 月，Oracle 收购了 GoldenGate 这一数据库复制软件供应商。Oracle 现在鼓励客户使用Oracle GoldenGate(Oracle 融合中间件系列的组成部分)来满足新应用中的数据复制需...
mysql ogg_异构平台mysql-oracle(ogg)安装部署
weixin_39520393的博客
01-18 539
如图所示：源端采用Mysql库，目标端采用Oracle库一、OGG安装配置(源端)1、OGG下载※Mysql to Oracle注意事项※1. Supported data types for mysqlCHAR DOUBLE TINYTEXTVARCHAR DATE MEDIUMTEXTINT TIME LONGTEXTTINYINT...
配置ext重新抓取
oradbm的博客
08-04 499
ogg source端意外宕机后(13:00宕机)，引起ogg不能同步（source和target端数据不同步）。 处理办法如下：一、source端1.extract服务：extract服务状态为：abended解决办法：alter extract extract_name ETROLLOVER--指定抽取进程extract_name从13:00重新抽取数据alter extract e...
日志传输延迟导致OGG 抽数失败
cuigou4391的博客
05-29 333
OGG 源端从备库抽数，一直运行稳定，突然有天发现，进程虽然running，但是数据目标端数据却停止了更新。看起来就像投递失败。 源端检查了投递进程，状态正常。然后检查抽取进程，查看日志发现有如下报错： ...
Oracle ogg同步SQL server 问题排查
demonson的专栏
05-20 697
1.检查目标库SQL server上ogg进程是否正常 info all info rer stats rer,total 若是ogg的mgr或rer进程stop/abended状态 start mgr start rer 2.检查目标库Oracle上ogg进程是否正常 info all info ex info pup stats pup,total 若是ogg的mgr/ex/pup进程stop/abended状态 start mgr start ex start..
OGG-01004|OGG 初始化数据问题处理
JiekeXu的博客
08-19 3750
作者 | JiekeXu来源 |JiekeXu DBA之路（ID: JiekeXu_IT）大家好，我是 JiekeXu,很高兴又和大家见面了,今天和大家一起来看看 OGG 初始化数据问题...
No active replication maps
雅冰石的专栏
11-04 2330
一 问题描述 有同事反映ogg存在数据无法同步问题(源端的数据无法同步到目标端)。 二 问题排查 2.1 检查下目标端相关进程是否启动 发现进程停止，启动进程： 启动mgr进程后，会自动启动REPLICAT进程。 但是当查看replicat进程状态时，有些异常，输出： No active replication maps. 2.2 检查下源端相关进程是否启动 启动完源端extract进程后，再次查看目标端的Replicat进程，就正常了： ...
ogg sqlserver-oracle mysql-oracle mysql-mysql的同步配置参考
02-17
在本配置参考中，我们将探讨如何使用Oracle GoldenGate（简称OGG）来实现SQL Server到Oracle，MySQL到Oracle以及MySQL到MySQL的同步配置。 1. SQL Server到Oracle的同步配置： - 首先，你需要在SQL Server上安装并...
ogg112101_fbo_ggs_Linux_x64_ora11g_64bit
11-27
通过捕获、变换和应用数据更改，Golden Gate能够实现实时的数据同步，支持多种数据库平台，包括Oracle、SQL Server、MySQL等。 2. **数据复制技术**：Golden Gate采用日志解析技术，直接读取数据库的日志文件（redo...
ogg for mysql ddl_OGG配置DDL同步
weixin_42298105的博客
02-08 549
GoldenGate的DDL同步只支持两边一致的数据库、单向复制，限制条件较多(如不能进行字段映射、转换等)，所以实际应用价值不是很大。基本配置步骤为：(1)关闭ORACLE的回收站功能。(2)选择一个数据库schema存放支持DDL的GoldenGate对象，运行相应创建脚本。(3)编辑globals参数文件。(4)修改extl和repl的配置文件具体步骤：(1). 关闭数据库回收站：SQL&g...
ogg错误信息大全(英文版)
05-31
ogg错误信息大全 个人收集电子书，仅用学习使用，不可用于商业用途，如有版权问题，请联系删除！
OGG-15051|OGG 同步 Oracle 到 Kafka 时遇到的一个错误
JiekeXu的博客
08-22 2205
作者 | JiekeXu来源 |公众号 JiekeXu DBA之路（ID: JiekeXu_IT）如需转载请联系授权 |(个人微信 ID：JiekeXu_DBA)大家好，我是 JiekeXu,很高兴又和大家见面了,今天和大家一起来学习 OGG 同步 Oracle 到 Kafka 时遇到的一个错误，欢迎点击上方蓝字关注我，标星或置顶，更多干货第一时间到达！有时候随着业务的需要，需要将 Oracle...
OGG中Time Since Chkpt状态为UNKNOWN解决方法
kevin_LCC的专栏
12-05 2600
 数据库服务器异常关机，重启后启动OGG后，Time Since Chkpt状态为UNKNOWN 此时只需要重启进程即可： GGSCI>stop *              ------如果关闭不了  用  kill -9 进程   杀掉 GGSCI>stop mgr GGSCI>start mgr GGSCI>start * 如果还是不行，那么就检查下操作系统上的OGG进程是
oracle ogg--ogg搭建过程中遇到的错误及处理
weixin_30856725的博客
06-21 2672
1 PRVF-0002 : Could not retrieve local nodename---# Begin Stacktrace #---------------------------ID: oracle.install.commons.util.exception.DefaultErrorAdvisor:37oracle.cluster.verification.Verificatio...
oracle with rs 用法,Oracle GoldenGate 学习教程二、配置和使用
weixin_39785150的博客
04-09 395
阅读导航配置和使用GoldenGate的步骤1 配置数据库支持GoldenGate1.1 OGG用户和权限分配1.2 数据库附加日志1.2.1 数据库级别的附加日志1.2.2 用户级别的附加日志1.2.3 表级别的附加日志2 配置GoldenGate2.1 GoldenGate MGR进程2.1.1 配置GoldenGate MGR进程2.1.2 启动mgr进程2.2 在源端创建和配置Extrac...
ERROR OGG-10151 Oracle GoldenGate Capture for Oracle, capture.prm: (capture
EVISWANG的博客
04-01 7282
2016-04-01 12:23:34  ERROR   OGG-10151  Oracle GoldenGate Capture for Oracle, capture.prm:  (capture.prm) line 8: Parsing error, parameter [exttrail] has unrecognized keyword or extra value "100".
OGG server 时间调整的注意事项与调整步骤
msdnchina的专栏@JiNan,ShanDong
08-29 1410
OGG server 时间调整的注意事项与调整步骤
Oracle OGG 12.2.0.2 Windows到Linux同步详细步骤
Oracle GoldenGate 提供了一种高效的数据集成解决方案，支持多种数据库间的实时数据复制，包括Oracle、SQL Server、MySQL等。在本场景中，我们将重点讨论Windows到Linux环境的数据同步。 1. 安装 Oracle GoldenGate...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值