Small white, ORACLE GOLDENGATE problem for advice? Hair for the first time, a little excited, help me to look at the issue below is what reason?



Is two Linux environment, ORACLE database, one-way replication, is in is the primary condition for service process works, but from the master server cannot deliver data to the server, the log is as follows:

The
GGSCI (localhost. Localdomain) 1 & gt; The info all

The Program Status Group Lag at Chkpt Time Since Chkpt

The MANAGER RUNNING
EXTRACT RUNNING DPEA 00:00:00 00:00:09
EXTRACT RUNNING EXTA 00:00:00 00:00:03



GGSCI (localhost. Localdomain) 2 & gt; The info all

The Program Status Group Lag at Chkpt Time Since Chkpt

The MANAGER RUNNING
REPLICAT RUNNING REPA 00:00:00 00:00:02


Log the following
SCN [1906769342], commit the SCN [1906769453] the instance [ecology (1)], DDL seqno [738090], marker seqno [532218].
The 2019-11-14 T08:34:59. 692 + 0800-00487 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY which objname FORMTABLE_MAIN_803.
The 2019-11-14 T08:35:00. 024 + 0800-00497 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: Writing DDL operation to extract trail file.
The 2019-11-14 T08:35:00. 024 + 0800-06507 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: the MAP (TABLE) resolved (entry ecology. Htmllabelindex) : TABLE "ecology". "htmllabelindex".
The 2019-11-14 T08:35:00. 290 + 0800-06439 WARNING OGG Oracle GoldenGate Capture for Oracle, exta. Also: No unique key is defined for the table HTMLLABELINDEX. All viable columns will be 2 represent the key, but may not guarantee uniqueness. KEYCOLS may be 2 define the key.
The 2019-11-14 T08:35:00. 290 + 0800-06509 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: Using the following key columns for the source table ECOLOGY. HTMLLABELINDEX: ID, INDEXDESC.
The 2019-11-14 T08:35:00. 290 + 0800-06507 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: the MAP (TABLE) resolved (entry ecology. Htmllabelinfo) : TABLE "ecology". "htmllabelinfo".
The 2019-11-14 T08:35:00. 556 + 0800-06439 WARNING OGG Oracle GoldenGate Capture for Oracle, exta. Also: No unique key is defined for the table HTMLLABELINFO. All viable columns will be 2 represent the key, but may not guarantee uniqueness. KEYCOLS may be 2 define the key.
The 2019-11-14 T08:35:00. 556 + 0800-06509 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: Using the following key columns for the source table ECOLOGY. HTMLLABELINFO: INDEXID, LABELNAME, LANGUAGEID.
The 2019-11-14 T08:35:00. 556 + 0800-01487 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: DDL found, operation [alter table formtable_main_803 add: QQQ varchar2 (11) (size 52)], start the SCN [1906769471], commit the SCN [1906769482] the instance [ecology (1)], DDL seqno [738091], marker seqno [532219].
The 2019-11-14 T08:35:00. 556 + 0800-00487 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY which objname FORMTABLE_MAIN_803.
The 2019-11-14 T08:35:00. 622 + 0800-00497 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: Writing DDL operation to extract trail file.
The 2019-11-14 T08: one. 581 + 0800-00987 Oracle GoldenGate INFO OGG Command Interpreter for Oracle: GGSCI Command (Oracle) : the INFO all.
The 2019-11-14 T08:38:43. 323 + 0800-01487 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: DDL found, operation [alter table formtable_main_803 add WWW varchar2 (11) (size 52)], start the SCN [1906775242], commit the SCN [1906775280] the instance [ecology (1)], DDL seqno [738092], marker seqno [532220].
The 2019-11-14 T08:38:43. 326 + 0800-00487 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: DDL operation included [include all], optype [ALTER], objtype [TABLE], objowner ECOLOGY which objname FORMTABLE_MAIN_803.
The 2019-11-14 T08:38:43. 361 + 0800-00497 Oracle GoldenGate INFO OGG Capture for Oracle, exta. Also: Writing DDL operation to extract trail file.
The 2019-11-14 T08: first. 600 + 0800-00987 Oracle GoldenGate INFO OGG Command Interpreter for Oracle: GGSCI Command (Oracle) : the INFO all.


Because two days before the standby database has a problem, I use the backup RECOVERY before, so now is such situation, worried,

CodePudding user response:

No one, by himself

CodePudding user response:

This check is there the latest log target side first, if have the stats replication process have no application record

CodePudding user response:

GSCI (localhost. Localdomain) 2 & gt; Stats repa

Sending STATS request to REPLICAT REPA...

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
nullnullnullnullnullnullnullnullnullnullnullnull