GoldenGate错误
来源:互联网 发布:听书软件电脑版 编辑:程序博客网 时间:2024/06/04 23:26
GoldenGate错误
一、2012-10-12 16:46:55 WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, ryszx.prm: SQL error 1403 mapping YSZX2012.DOWNLOAD_PLATFORM_BASEDATA to YSZX2012.DOWNLOAD_PLATFORM_BASEDATA.
2012-10-12 16:46:55 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ryszx.prm: Repositioning to rba 58391562 in seqno 215.
2012-10-12 16:46:55 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ryszx.prm: Error mapping from YSZX2012.DOWNLOAD_PLATFORM_BASEDATA to YSZX2012.DOWNLOAD_PLATFORM_BASEDATA.
2012-10-12 16:46:55 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ryszx.prm: PROCESS ABENDING.
问题原因:goldengate在配置的时候没有开启DDL,由于源端进行了表结构更改,没有通知目标端,导致此错误。
处理方法:在目标端执行相应的语句,将表结构修改为和源端一致。
二、2012-10-15 07:23:58 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RYSZX starting.
2012-10-15 07:23:58 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RYSZX restarted automatically.
2012-10-15 07:23:58 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ryszx.prm: REPLICAT RYSZX starting.
2012-10-15 07:23:58 ERROR OGG-01172 Oracle GoldenGate Delivery for Oracle, ryszx.prm: Discard file (./dirrpt/ryszx.dsc) exceeded max bytes (1000000).
2012-10-15 07:23:58 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ryszx.prm: PROCESS ABENDING.
问题原因:dsc这个文件超过定义的最大值
解决方法:更改队列文件的最大值( Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-font-kerning:1.0pt;} megabytes)或者将这个文件备份删除。
三、2012-07-07 16:31:32 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ryszx.prm: No unique key is defined for table SYS_WF_CURRENT_ITEM. All viable columns w
ill be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-07-07 16:31:32 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ryszx.prm: No unique key is defined for table SYS_WF_TASK_ROUTING. All viable columns w
ill be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
问题现象:由于要同步的表没有主键或者唯一索引, goldengate默认将所有列当做主键进行同步,这样不能保证灾备端的表和源端的表完全一样,有时会出现灾备端数据大量重复现象。
解决方法:
1,将要进行同步的表增加主键。
2,使用keycols,KEYCOLS关键字用于对没有主键的表,指定能够唯一标识数据的字段,语法如下:
TABLE <source_table>, KEYCOLS (<column> [, <column>, <column>, ...]);
and...
MAP <source_table>, TARGET <target_table>, KEYCOLS (<column>
[, <column>, <column>, ...]);
例如:
TABLE hr.emp, KEYCOLS (FIRST_NAME, LAST_NAME, DOB, ID_NO);
MAP hr.emp, TARGET hr.emp2, KEYCOLS (FIRST_NAME, LAST_NAME, DOB, ID_NO);
3,如果目标表不含有主键或唯一键,就可能存在重复的行,GoldenGate有可能在目标表上更新或删除太多的行,使得源端和目标段的数据不同步,而且不会 有警告信息。为了限制更新的行的数量,可以在Replicat参数文件的DBOPTIONS参数中使用LIMITROWS选项(这个目前还没测试是否可用以及效果怎样)
四、./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory
问题原因:环境变量设置不正确
解决方法:export LD_LIBRARY_PATH=$ORACLE_HOME/lib
2012-10-12 16:46:55 WARNING OGG-01003 Oracle GoldenGate Delivery for Oracle, ryszx.prm: Repositioning to rba 58391562 in seqno 215.
2012-10-12 16:46:55 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, ryszx.prm: Error mapping from YSZX2012.DOWNLOAD_PLATFORM_BASEDATA to YSZX2012.DOWNLOAD_PLATFORM_BASEDATA.
2012-10-12 16:46:55 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ryszx.prm: PROCESS ABENDING.
问题原因:goldengate在配置的时候没有开启DDL,由于源端进行了表结构更改,没有通知目标端,导致此错误。
处理方法:在目标端执行相应的语句,将表结构修改为和源端一致。
二、2012-10-15 07:23:58 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RYSZX starting.
2012-10-15 07:23:58 INFO OGG-00965 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT RYSZX restarted automatically.
2012-10-15 07:23:58 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, ryszx.prm: REPLICAT RYSZX starting.
2012-10-15 07:23:58 ERROR OGG-01172 Oracle GoldenGate Delivery for Oracle, ryszx.prm: Discard file (./dirrpt/ryszx.dsc) exceeded max bytes (1000000).
2012-10-15 07:23:58 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, ryszx.prm: PROCESS ABENDING.
问题原因:dsc这个文件超过定义的最大值
解决方法:更改队列文件的最大值( Normal 0 7.8 磅 0 2 false false false EN-US ZH-CN X-NONE /* Style Definitions */ table.MsoNormalTable {mso-style-name:普通表格; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.5pt; mso-bidi-font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi; mso-font-kerning:1.0pt;} megabytes)或者将这个文件备份删除。
三、2012-07-07 16:31:32 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ryszx.prm: No unique key is defined for table SYS_WF_CURRENT_ITEM. All viable columns w
ill be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
2012-07-07 16:31:32 WARNING OGG-00869 Oracle GoldenGate Delivery for Oracle, ryszx.prm: No unique key is defined for table SYS_WF_TASK_ROUTING. All viable columns w
ill be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.
问题现象:由于要同步的表没有主键或者唯一索引, goldengate默认将所有列当做主键进行同步,这样不能保证灾备端的表和源端的表完全一样,有时会出现灾备端数据大量重复现象。
解决方法:
1,将要进行同步的表增加主键。
2,使用keycols,KEYCOLS关键字用于对没有主键的表,指定能够唯一标识数据的字段,语法如下:
TABLE <source_table>, KEYCOLS (<column> [, <column>, <column>, ...]);
and...
MAP <source_table>, TARGET <target_table>, KEYCOLS (<column>
[, <column>, <column>, ...]);
例如:
TABLE hr.emp, KEYCOLS (FIRST_NAME, LAST_NAME, DOB, ID_NO);
MAP hr.emp, TARGET hr.emp2, KEYCOLS (FIRST_NAME, LAST_NAME, DOB, ID_NO);
3,如果目标表不含有主键或唯一键,就可能存在重复的行,GoldenGate有可能在目标表上更新或删除太多的行,使得源端和目标段的数据不同步,而且不会 有警告信息。为了限制更新的行的数量,可以在Replicat参数文件的DBOPTIONS参数中使用LIMITROWS选项(这个目前还没测试是否可用以及效果怎样)
四、./ggsci: error while loading shared libraries: libnnz10.so: cannot open shared object file: No such file or directory
问题原因:环境变量设置不正确
解决方法:export LD_LIBRARY_PATH=$ORACLE_HOME/lib
4,
./ggsci
exec(): 0509-036 Cannot load program ./ggsci because of the following errors:
0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.
0509-022 Cannot load module libclntsh.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
exec(): 0509-036 Cannot load program ./ggsci because of the following errors:
0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.
0509-022 Cannot load module libclntsh.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
问题原因,所属用户不对
解决方式:用oracle用户执行
阅读全文
0 0
- GoldenGate错误
- goldengate忽略错误
- 安装GoldenGate错误OGG-01756
- Goldengate常见错误处理方式
- Oracle GoldenGate 处理错误方式
- GoldenGate
- goldengate
- GoldenGate
- GoldenGate
- GoldenGate SQL error 1403 mapping 错误解决方案
- GoldenGate for RAC 错误一例
- Oracle goldengate 11g错误汇总
- Oracle GoldenGate跳过错误的事务
- GoldenGate 使用reperror进行错误处理
- goldengate命令输入错误导致的血案2
- 创建Goldengate例外句丙记录跟踪Oracle错误
- Oracle GoldenGate 监控工具:ggserr.log 错误日志不可忽视
- Oracle Goldengate For Mysql 复制进程错误ERROR OGG-00768
- android studio 升级2.3.2或2.3.3打包项目时signature versions v2打包成功,安装失败问题解决
- FactoryBean的实现原理与作用
- App之间跨应用跳转
- C++跨平台开源库 之二
- JPA 开发中遇到的错误
- GoldenGate错误
- 冒泡排序
- Linux下安装GraphicsMagick
- 类加载的过程
- Gcd & Lcm game
- Android笔记(六)ANR
- 计算机组成原理知识点(第七章: 指令系统)
- linux c++ 多进程 匿名管道 命名管道 消息队列 信号量 共享内存 内存映射
- Ubuntu16.10 下codeblocks的安装配置