小白,ORACLE GOLDENGATE问题求教?第一次发,有点激动,帮我看下下面这个问题是什么原因呢?环境是2台linux,数据库都ORACLE,单向复制,目前情况是主备服务进程都正常,但是从主服务器不能投递数据到备服务器,具体日志如下:主
GGSCI (localhost.localdomain) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
EXTRACT RUNNING DPEA 00:00:00 00:00:09
EXTRACT RUNNING EXTA 00:00:00 00:00:03
备
GGSCI (localhost.localdomain) 2> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
REPLICAT RUNNING REPA 00:00:00 00:00:02
日志如下
SCN [1906769342], commit SCN [1906769453] instance [ecology (1)], DDL seqno [738090], er seqno [532218].
2019-11-14T08:34:59.692+0800 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY, objname FORMTABLE_MAIN_803.
2019-11-14T08:35:00.024+0800 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, exta.prm: Writing DDL operation to extract trail file.
2019-11-14T08:35:00.024+0800 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, exta.prm: MAP (TABLE) resolved (entry ecology.htmllabelindex): table "ECOLOGY"."HTMLLABELINDEX".
2019-11-14T08:35:00.290+0800 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, exta.prm: No unique key is defined for table HTMLLABELINDEX. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-11-14T08:35:00.290+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, exta.prm: Using the following key columns for source table ECOLOGY.HTMLLABELINDEX: ID, INDEXDESC.
2019-11-14T08:35:00.290+0800 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, exta.prm: MAP (TABLE) resolved (entry ecology.htmllabelinfo): table "ECOLOGY"."HTMLLABELINFO".
2019-11-14T08:35:00.556+0800 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, exta.prm: No unique key is defined for table HTMLLABELINFO. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-11-14T08:35:00.556+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, exta.prm: Using the following key columns for source table ECOLOGY.HTMLLABELINFO: INDEXID, LABELNAME, LANGUAGEID.
2019-11-14T08:35:00.556+0800 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL found, operation [alter table formtable_main_803 add qqq varchar2(11) (size 52)], start SCN [1906769471], commit SCN [1906769482] instance [ecology (1)], DDL seqno [738091], er seqno [532219].
2019-11-14T08:35:00.556+0800 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY, objname FORMTABLE_MAIN_803.
2019-11-14T08:35:00.622+0800 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, exta.prm: Writing DDL operation to extract trail file.
2019-11-14T08:36:22.581+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2019-11-14T08:38:43.323+0800 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL found, operation [alter table formtable_main_803 add www varchar2(11) (size 52)], start SCN [1906775242], commit SCN [1906775280] instance [ecology (1)], DDL seqno [738092], er seqno [532220].
2019-11-14T08:38:43.326+0800 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY, objname FORMTABLE_MAIN_803.
2019-11-14T08:38:43.361+0800 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, exta.prm: Writing DDL operation to extract trail file.
2019-11-14T08:40:19.600+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
因为前二天备数据库出了问题,我用以前的备份RECOVERY过,所以目前就这样情况,很捉急。
GGSCI (localhost.localdomain) 1> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
EXTRACT RUNNING DPEA 00:00:00 00:00:09
EXTRACT RUNNING EXTA 00:00:00 00:00:03
备
GGSCI (localhost.localdomain) 2> info allProgram Status Group Lag at Chkpt Time Since ChkptMANAGER RUNNING
REPLICAT RUNNING REPA 00:00:00 00:00:02
日志如下
SCN [1906769342], commit SCN [1906769453] instance [ecology (1)], DDL seqno [738090], er seqno [532218].
2019-11-14T08:34:59.692+0800 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY, objname FORMTABLE_MAIN_803.
2019-11-14T08:35:00.024+0800 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, exta.prm: Writing DDL operation to extract trail file.
2019-11-14T08:35:00.024+0800 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, exta.prm: MAP (TABLE) resolved (entry ecology.htmllabelindex): table "ECOLOGY"."HTMLLABELINDEX".
2019-11-14T08:35:00.290+0800 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, exta.prm: No unique key is defined for table HTMLLABELINDEX. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-11-14T08:35:00.290+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, exta.prm: Using the following key columns for source table ECOLOGY.HTMLLABELINDEX: ID, INDEXDESC.
2019-11-14T08:35:00.290+0800 INFO OGG-06507 Oracle GoldenGate Capture for Oracle, exta.prm: MAP (TABLE) resolved (entry ecology.htmllabelinfo): table "ECOLOGY"."HTMLLABELINFO".
2019-11-14T08:35:00.556+0800 WARNING OGG-06439 Oracle GoldenGate Capture for Oracle, exta.prm: No unique key is defined for table HTMLLABELINFO. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2019-11-14T08:35:00.556+0800 INFO OGG-06509 Oracle GoldenGate Capture for Oracle, exta.prm: Using the following key columns for source table ECOLOGY.HTMLLABELINFO: INDEXID, LABELNAME, LANGUAGEID.
2019-11-14T08:35:00.556+0800 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL found, operation [alter table formtable_main_803 add qqq varchar2(11) (size 52)], start SCN [1906769471], commit SCN [1906769482] instance [ecology (1)], DDL seqno [738091], er seqno [532219].
2019-11-14T08:35:00.556+0800 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY, objname FORMTABLE_MAIN_803.
2019-11-14T08:35:00.622+0800 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, exta.prm: Writing DDL operation to extract trail file.
2019-11-14T08:36:22.581+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
2019-11-14T08:38:43.323+0800 INFO OGG-01487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL found, operation [alter table formtable_main_803 add www varchar2(11) (size 52)], start SCN [1906775242], commit SCN [1906775280] instance [ecology (1)], DDL seqno [738092], er seqno [532220].
2019-11-14T08:38:43.326+0800 INFO OGG-00487 Oracle GoldenGate Capture for Oracle, exta.prm: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY, objname FORMTABLE_MAIN_803.
2019-11-14T08:38:43.361+0800 INFO OGG-00497 Oracle GoldenGate Capture for Oracle, exta.prm: Writing DDL operation to extract trail file.
2019-11-14T08:40:19.600+0800 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): info all.
因为前二天备数据库出了问题,我用以前的备份RECOVERY过,所以目前就这样情况,很捉急。
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