Goldengate OGG常见问题与错误列表

本文汇总了Oracle GoldenGate (OGG) 在使用过程中遇到的一些常见问题及解决办法,包括同步单表、TCP/IP错误处理、压缩表支持等问题,为用户提供故障排查与优化建议。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

以下列出了OGG一些常见的问题与错误及其解答:
Note: 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
Note: 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note: 972954.1 What Causes The 'Bad Column Index(xxxx)' Error In Replicat?
Note: 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed
Note: 1112506.1 GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
Note: 1124403.1 When Replicat is Running but Not Applying Records
Note: 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note: 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note: 1266389.1 Oracle GoldenGate and compressed tables
Note: 1270168.1 OGG-01028 Compression Not Supported - when extract processes regular and cluster tables
Note: 1276538.1 Replicat abending with missing key cols
Note: 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note: 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side
Note: 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note: 1271578.1 How to Handle Tables without Primary Keys or Unique Indexes with Oracle GoldenGate
Note: 957053.1 Recovering From a GG Pump Process Abending With An Incompatible Record Error
Note: 968622.1 Does GoldenGate Support Tables With An UNUSED Column?
Note: 968614.1 Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
Note: 968769.1 GoldenGate Errors That Occur In Teradata Extract Setting
Note: 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note: 964709.1 How To Handle Oracle DDLs (add/drop/resize a Column) 22 19 1
Note: 1300076.1 Usage and considerations for allocation of ports and DYNAMICPORTLIST
Note: 1232303.1 mount options to use when configuring GoldenGate to run on NFS mounted file system
Note: 1298548.1 Extract not accepting CACHESIZE settings
Note: 1300197.1 Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
Note: 1273285.1 How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue  Note: 965356.1 GGS Error 150: No Dynamic Ports Available
Note: 1199561.1 Characterset Conversion: Error 160 Bad column length
Note: 1159684.1 Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
Note: 1292874.1 GoldenGate Extract Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
Note: 1271522.1 Oracle GoldenGate (OGG) 11.1>>> .1>>> .0 and Transparent Data Encryption (TDE)
Note: 965270.1 How does the Manager Allocate TCPIP Ports?
Note: 1195995.1 Implementing GoldenGate for DataGuard fail overs
Note: 965373.1 Installing And Configuring GoldenGate In An Oracle RAC Environment
Note: 1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
Note: 971264.1 How To Upgrade GGS Objects In A DDL Replication Environment  Note 957112.1 Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
Note 969550.1 Using SCN To Do The Initial Load From Oracle To Oracle Database
Note 966211.1 How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
Note 1235986.1 Does Oracle Goldengate extract support distributed transactions?
Note 966227.1 Troubleshooting TCP/IP Errors In Open Systems
Note 972954.1 What Causes The 'Bad Column Index(xxxx)'; Error In Replicat?
Note 987379.1 How to recover from Extract ERROR 180 encountered commit SCN that is not greater than the highest SCN already processed (GG Version 10)
Note 1112325.1 Deploying OGG to Achieve Operational Reporting for Oracle E-Business Suite
Note 1112506.1 GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
Note 1120793.1 How to Get More Information than from Just a Trace on LINUX Boxes for GoldenGate
Note 1124403.1 When Replicat is Running but Not Applying Records
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH
Note 1163073.1 When using rmthost with timeout option, there are orphaned data collector processes on target system
Note 1266389.1 Oracle GoldenGate and compressed tables
Note 1270168.1 OGG-01028 Compression Not Supported - when extract processes regular and cluster tables
Note 1272645.1 Maintaining the OGG Marker table
Note 1276058.1 Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
Note 1276538.1 Replicat abending with missing key cols
Note 1280584.1 Where To Find The List Of Supported And Unsupported Oracle Data Types for GoldenGate
Note 1288562.1 GG Data Pumps Error With OGG-01031 When Upgrading the Target Side

 


本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277682


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值