小白,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过,所以目前就这样情况,很捉急。
解决方案 »
- 数据库出问题了,急,请大家帮我看看有没有碰到过!!求帮忙!
- 求助这个trigger应该怎么写
- asp查询ORACLE查询指定月份的数据,表内有一字段列gzdate 类型nvarchar2数据格式为2008-12-2 17:45:30
- partition table 删除 partition
- 请教如果将两句查询语句合为一
- oracle开发中遇到的问题求教
- 请教各位大侠一个SQL语句,想了很久也没想出来!!
- 关于oracle服务,急!
- 求救:OracleOraHome90ManagementServer服务启动不了怎么办
- 在oracle9i 中怎样用命令删除一个用户的所有对象(图形界面中的方案)
- 求一个SQL语句
- oracle占位符
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