小白，ORACLE GOLDENGATE問題求教？第一次發，有點激動，幫我看下下面這個問題是什么原因呢？
環境是2臺linux,資料庫都ORACLE,單向復制，目前情況是主備服務行程都正常，但是從主服務器不能投遞資料到備服務器，具體日志如下：
主
GGSCI (localhost.localdomain) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPEA 00:00:00 00:00:09
EXTRACT RUNNING EXTA 00:00:00 00:00:03
備
GGSCI (localhost.localdomain) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING REPA 00:00:00 00:00:02
日志如下
SCN [1906769342], commit SCN [1906769453] instance [ecology (1)], DDL seqno [738090], marker 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], marker 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], marker 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過，所以目前就這樣情況，很捉急。
uj5u.com熱心網友回復：
沒人，自己頂頂uj5u.com熱心網友回復：
這種情況檢查一下目標端有沒最新的日志過來先，如果有stats一下復制行程看有沒應用記錄uj5u.com熱心網友回復：
GSCI (localhost.localdomain) 2> stats repaSending 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
Excluded operations 0.00
Errors 0.00
Retried errors 0.00
Discarded errors 0.00
Ignored errors 0.00
uj5u.com熱心網友回復：
沒有應用到，你先看看trail檔案更新過來沒有？如果有更新過來，我懷疑是你的復制行程配置錯了 map引數部分轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/24625.html
標籤：高級技術
上一篇：求教，ORA-01950: 對表空間無權限 怎么解決？
下一篇：商品規格應該怎么設計資料庫？