APPLIES TO:
Oracle GoldenGate - Version 10.4.0.78 and later
Information in this document applies to any platform.
SYMPTOMS:
1. When using SAMFS file system replicat may abend incompatible record error or Bad column Index error
Oracle GoldenGate (OGG) replicat abends with error about incompatible record
GGS ERROR 190 Incompatible record (101)
Checking the affected trail, the data looks good in the physical file
Re-starting replicat on an earlier RBA might help to overcome the issue
2.Replicat abend with Bad column Index
ERROR OGG-01161 Bad column index (##) specified for table <schema>.<table_name>,max columns = ##.
CAUSE:
The above said issues can occur any time the target file system uses AsyncIO. This includes the SAMFS file system.
OGG does not support any file system with async IO writes.
SOLUTION:
If an AsyncIO file system is used, caching should be disabled. If the problem persists, try disabling async io.
Note : This has not been tested for performance impact. Please check with your system administrator for the mount options.
Other workaround, is to change the file system to regular UFS filesystem. UFS filesystem does not need any specific mount options.
Incompatilbe record error can happen when trails are stored on NFS mounted file system. To avoid this please refer Doc ID 1232303.1 for the Mount options when configuring Oracle GoldenGate
REFERENCES:
BUG:10306932 - RFE: ADD SUPPORT FOR SAMFS
3-5543766031
=====================================
小结：OGG-01161很多问题是由于数据库主备两端的表结构发生该表导致，但是在某些情况下并非如此。例如此次事件就是由于备库开启了异步IO，解决此问题有两种方式，（1）开启异步IO，同事关闭cache。（2）使用同步IO。针对数据库操作系统更倾向于第一种方式。
----thank you & best regards
