一.配置處理：
（1）OGG-00664 Oracle GoldenGate Capture for Oracle, EORA.prm: OCI Error beginning session (status = 12705-ORA-12705: Cannot access NLS data files or invalid environment specified).
- 說明：源端抽取進(jìn)程參數(shù)設(shè)置錯誤：
setenv (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
- 修復(fù)方案：查詢數(shù)據(jù)庫NLS_LANG參數(shù)，并修改
// 查詢語句
SQL> select userenv('language') from dual;
USERENV('LANGUAGE')
----------------------------------------------------
SIMPLIFIED CHINESE_CHINA.ZHS16GBK
（2）OGG-02091 Oracle GoldenGate Capture for Oracle, EORA.prm: Operation not supported because enable_goldengate_replication is not set to true.
說明：Oracle的ENABLE_GOLDENGATE_REPLICATION參數(shù)未啟用
修復(fù)方案：修改ORACLE的ENABLE_GOLDENGATE_REPLICATION為TRUE
SQL> ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE;
（3）OGG-00717 Oracle GoldenGate Capture for Oracle, EORA.prm: Found unsupported in-memory undo record in sequence 34619, at RBA 2301400, with SCN 0.239272029 (239272029) ... Minimum supplemental logging must be enabled to prevent data loss.
說明：讀取ORACLE日志異常：1.當(dāng)前歸檔模式未啟動；2.設(shè)置的同步時間未找到日志文件
修復(fù)方案1：檢查當(dāng)前歸檔模式是否開啟，開啟當(dāng)前歸檔模式
// 查看數(shù)據(jù)庫當(dāng)前歸檔模式
CMD> sqlplus "/as sysdba"
SQL> select log_mode from v$database;
LOG_MODE
------------
NOARCHIVELOG
// 開啟歸檔模式
SQL> archive log list;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database archivelog;
SQL> alter database open;
- 修復(fù)方案2：查看日志記錄，修改同步時間
日志記錄參考路徑：E:\app\Administrator\fast_recovery_area\orcl
// 查詢?nèi)罩居涗?SQ> select name from v$archived_log;
E:\APP\ADMINISTRATOR\FAST_RECOVERY_AREA\ORCL\ARCHIVELOG\2019_06_27\O1_MF_1_13129_GK85XW88_.ARC
// 修改同步時間
GGSCI> add extract eora,tranlog,begin now //從當(dāng)前時間開始同步
GGSCI> add extract eora, tranlog,begin 2019-06-27 13:00:00 //指定時間點開始同步
（4）OGG-01031 Oracle GoldenGate Capture for Oracle, PUMP_SO.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Reply received is Output file E:\ogg\ogg_tsg\et000000 in the GolenGate installation directory is not allowed.).
- 說明：投遞進(jìn)程參數(shù)路徑設(shè)置錯誤
rmttrail E:\ogg\ogg_tsg
- 修復(fù)方案：檢查投遞進(jìn)程配置并修改錯誤路徑
extract Pump_so
Userid ADLIB3OGG,password 密碼
rmthost 202.202.82.98, mgrport 7905
rmttrail E:\ogg\ogg_tsg\dirdat\et
Table ADLIB3_XZ.*;
GGSCI >edit params pump_so
GGSCI >ADD RMTTRAIL E:\ogg\ogg_tsg\dirdat\et, EXTRACT PUMP_SO
（5）director監(jiān)控工具無法連接ogg實例：
Oracle GoldenGate 之 Director 監(jiān)控工具安裝和郵箱報警
注意：ogg進(jìn)程需啟動
- 檢查端口是否能 telnet通
cmd >telnet 202.202.82.98 7900
-
修復(fù)方案1（端口不能 telnet 通）：查看防火墻是否開放端口
01.png 修復(fù)方案2（端口能 telnet 通）：在ogg的GLOBALS文件中添加參數(shù)：_DISABLEFIX21427144
MGRSERVNAME OGGMGR_TSG
GGSCHEMA oggggs
checkpointtable oggggs.checkpoint
ALLOWOUTPUTDIR E:\ogg\ogg_tsg\dirdat
_DISABLEFIX21427144
// 編輯GLOBALS文件
GGSCI> edit params ./GLOBALS
（6） Oracle GoldenGate Capture for Oracle, PUMP_SO.prm: The trail 'D:\ogg\dirdat\et' is not assigned to extract 'PUMP_SO'. Assign the trail to the extract with the command "ADD EXTTRAIL/RMTTRAIL D:\ogg\dirdat\et, EXTRACT PUMP_SO".
- 說明：未執(zhí)行 "ADD EXTTRAIL/RMTTRAIL D:\ogg\dirdat\et, EXTRACT PUMP_SO" 或執(zhí)行錯誤
- 解決方案：根據(jù)提示執(zhí)行：ADD EXTTRAIL/RMTTRAIL D:\ogg\dirdat\et, EXTRACT PUMP_SO
注意：EXTTRAIL/RMTTRAIL 選一執(zhí)行即可
GGSCI > ADD RMTTRAIL D:\ogg\dirdat\et, EXTRACT PUMP_SO
二·.運行中異常處理：
（1） Oracle GoldenGate Capture for Oracle, ejwinit.prm: No viable key columns found for table JW_USER.ZFTAL_XTGL_ZFTZB.
說明：目標(biāo)端找不到表 JW_USER.ZFTAL_XTGL_ZFTZB
修復(fù)方案1：在源端查詢該表結(jié)構(gòu)，在目標(biāo)端中添加該表，重啟進(jìn)程
GGSCI > start repl
- 修復(fù)方案2：在源端的投遞進(jìn)程和目標(biāo)端的應(yīng)用進(jìn)程忽略該表
源端投遞進(jìn)程添加參數(shù)：
tableexclude JW_USER.ZFTAL_XTGL_ZFTZB目標(biāo)端應(yīng)用進(jìn)程添加參數(shù)：
mapexclude JW_USER.ZFTAL_XTGL_ZFTZB
- 設(shè)置完成后重啟進(jìn)程即可
注意：此處的用戶名以源端為準(zhǔn)，即源端數(shù)據(jù)庫名為JW_USER，目標(biāo)端為JWUSER，、應(yīng)使用JW_USER
（2）Oracle GoldenGate Capture for Oracle, eora.prm: The redo record indicates data loss on object 140,382.
- 說明：暫未發(fā)現(xiàn)影響，ogg進(jìn)程正常
- 參考：
https://maazanjum.com/2013/12/15/ogg-01973-the-redo-record-indicates-data-loss-on-object-objectid/
https://community.oracle.com/message/13905235?tstart=0 - 處理記錄：
嘗試執(zhí)行：select owner,object_name,object_type from dba_objects where object_id=140269; 查找記錄。
目標(biāo)端：無記錄
源端：無記錄
（3）Oracle GoldenGate Delivery for Oracle, REPL_JW.prm: Encountered an update where all key columns for target table JWUSER.JW_JCGL_GYSXXB are not present.
- 說明：表沒有主鍵，ogg也無法將全部字段當(dāng)做唯一鍵進(jìn)行更新
- 修復(fù)方案：在應(yīng)用進(jìn)程中添加參數(shù)，手動指定唯一鍵
map JW_USER.JW_JCGL_GYSXXB, target JWUSER.JW_JCGL_GYSXXB, keycols (GYSXX_ID,GYSM);
注意結(jié)尾的分號
參考：
replicat repl_jw
setenv (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
assumetargetdefs
reperror default, discard
ddl INCLUDE MAPPED
ddloptions report
applynoopupdates
discardfile ./dirrpt/jw_repl.dsc, append, megabytes 2000
userid oggggs,password密碼
REPLACEBADCHAR SKIP
mapexclude JW_USER."JW_CJ_XYYJTJCXXB"
map JW_USER.JW_XMGL_JXXMBMSZZB, target JWUSER.JW_XMGL_JXXMBMSZZB, keycols (JXXMLBDM,JXXMKZBZ);
map JW_USER.JW_JCGL_GYSXXB, target JWUSER.JW_JCGL_GYSXXB, keycols (GYSXX_ID,GYSM);
map JW_USER.JW_PK_KBXXZDXSKZB, target JWUSER.JW_PK_KBXXZDXSKZB, keycols (KBZL,ZDM);
MAP JW_USER., target JWUSER.;
- 設(shè)置完成后重啟進(jìn)程即可
（4）Oracle GoldenGate Capture for Oracle, PUMP_SO.prm: TCP/IP error 10054 (遠(yuǎn)程主機強迫關(guān)閉了一個現(xiàn)有的連接。), endpoint: 202.202.82.98:7905.
- 說明：源端pump_so無法連接目標(biāo)端應(yīng)用進(jìn)程
- 修復(fù)方案：
1.檢查網(wǎng)絡(luò)狀態(tài)
2.檢查目標(biāo)端ogg進(jìn)程狀態(tài)
3.修復(fù)網(wǎng)絡(luò)或ogg進(jìn)程異常
4.重啟進(jìn)程
(5) Oracle GoldenGate Capture for Oracle, pump_so.prm: Receive TCP params error: TCP/IP error 104 (Connection reset by peer), endpoint: 202.202.82.98:7911.
- 說明：網(wǎng)絡(luò)原因造成，正常情況下，會自動重啟
- 修復(fù)方案：
1.檢查網(wǎng)絡(luò)狀態(tài)
2.重啟進(jìn)程
(6) Oracle GoldenGate Capture for Oracle, EORA.prm: Object with object number 318496 is compressed. Table compression is not supported.
- 說明：源端表壓縮，暫未發(fā)現(xiàn)影響，ogg進(jìn)程停止后自動重啟成功后無異常
(7) OGG01098 - Oracle GoldenGate Capture for Oracle, EORA.prm: Could not flush "H:\ogg\oggoracle\dirdat\et000190" (error 112, ).
- 說明：檢查源端磁盤空間
