OGG 配置過程中的錯誤處理

報錯處理: 
問題一:2014-11-17 10:02:09  ERROR   OGG-00446  No valid log files for current redo sequence 14, thread 1, error retrieving redo file name for sequence 14, 
archived = 0, use_alternate = 0Not able to establish initial position for begin time 2014-11-17 10:00:17.


分析: 當前日誌序列14沒有有效的日誌檔案,所以不能建立有效的開始時間點的初始化位置.


SQL> select a.group#,a.sequence#,a.status,b.member from v$log a, v$logfile b where a.group#=b.group#;
 
    GROUP#  SEQUENCE# STATUS           MEMBER
---------- ---------- ---------------- ----------------------------------------
         1         13 INACTIVE         +DATA/sdcrm01/onlinelog/group_1.661.862138407
         1         13 INACTIVE         +DATA/sdcrm01/onlinelog/group_1.662.862138407
         2         14 INACTIVE         +DATA/sdcrm01/onlinelog/group_2.663.862138407
         2         14 INACTIVE         +DATA/sdcrm01/onlinelog/group_2.664.862138407
         3         15 CURRENT          +DATA/sdcrm01/onlinelog/group_3.665.862138409
         3         15 CURRENT          +DATA/sdcrm01/onlinelog/group_3.666.862138409


這個就牽涉到ASM檔案的分析和讀取了.
解決方法: 連線到ASM instance, 然後建立使用者ogg, 並且賦予sysasm許可權.
create user ogg identified by oracle; grant sysdba to ogg;
然後在extract 的引數檔案中加一行 TRANLOGOPTIONS ASMUSER ogg@+ASM,ASMPASSWORD oracle 就可以了.


問題二
2014-11-17 11:10:54  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, ext1.prm:  No valid default archive log destination directory found for thread 1.
2014-11-17 11:10:54  INFO    OGG-01513  Oracle GoldenGate Capture for Oracle, ext1.prm:  Positioning to Sequence 15, RBA 4672528, SCN 0.25567606.
2014-11-17 11:10:54  INFO    OGG-01516  Oracle GoldenGate Capture for Oracle, ext1.prm:  Positioned to Sequence 15, RBA 4672528, SCN 0.25567606, Nov 17, 2014 11:03:57 AM.
2014-11-17 11:10:54  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, ext1.prm:  EXTRACT EXT1 started.
2014-11-17 11:10:54  ERROR   OGG-01496  Oracle GoldenGate Capture for Oracle, ext1.prm:  Failed to open target trail file dirdat/sp000001, at RBA 1207.
2014-11-17 11:10:54  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, ext1.prm:  PROCESS ABENDING.


原來是sp000001不存在所致. 重新建立ext1程式即可.


問題三: 一直都有WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, ext1.prm:  No valid default archive log destination directory found for thread 1.
雖然有個warning OGG-01423, 但是透過實驗:
stop ext1, 然後插入資料,在切換logfile, 然後重新啟動ext1, 資料照樣可以同步過去.




問題四: TCP/IP error 111 連線拒絕
Check swap space. Recommended swap/extract: 128G (64bit system).
2014-11-14 17:12:05  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, dp1.prm:  EXTRACT DP1 started.
2014-11-14 17:12:35  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).
2014-11-14 17:13:16  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).
2014-11-14 17:13:57  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).
2014-11-14 17:14:38  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).
2014-11-14 17:15:19  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).
2014-11-14 17:16:00  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).
2014-11-14 17:16:41  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, dp1.prm:  TCP/IP error 111 (Connection refused).


這個是由於在target 端的mgr引數中設定了dynamicportlist 7808~7820 造成的.去掉就可以了.
當單向複製的時候,可以在source端設定dynamicportlist 7808~7820, 意味著當指定的port實效時候,使用定義的動態埠,並且目標端在連線的時候會自動應用新的埠.
但是目標端,就不能有此引數. 並且做雙向同步的時候,兩端都不能出現此引數.