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