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实效时候,使用定义的动态端口,并且目标端在连接的时候会自动应用新的端口.
但是目标端,就不能有此参数. 并且做双向同步的时候,两端都不能出现此参数.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/674865/viewspace-1336048/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/674865/viewspace-1336048/