Oracle Goldengate OGG 11g与各操作系统及数据库版本的兼容列表

Oracle Goldengate OGG 11g (11.1.1.0.0)与各操作系统及数据库版本的兼容列表如下,仅供参考:

 

Oracle GoldenGate Certification Matrix 11.1.1.0.0 Version Supported Processor Type OS Version OS 32/64 bit Oracle FM 32/64 bit JDK Vendor Version* JDK 32/64 bit Oracle Database* Exceptions and Additional Information 11gR1 (11.1.1.1+) x86 Red Hat EL 4 (UL7+) 32 NA NA NA Oracle 9.2.0.7+ Oracle 10.2.0.4+ Oracle 11.1+ Oracle . . . → Read More: Oracle Goldengate OGG 11g与各操作系统及数据库版本的兼容列表

Goldengate Parameter SUPPRESSTRIGGERS & DEFERREFCONST

DBOPTIONS SUPPRESSTRIGGERS for delete cascade constraint on the target side (REPLICAT) in 11.1.0.7 is missing.

Ct was using OGG ver 10.4 initially for replicating from 9.2.0.8 on Sun Solaris to 11.1.0.7 on AIX. Ct ran into issues as they had 232 tables with 250 DELETE CASCADE constraints while replicating delete records. We gave the . . . → Read More: Goldengate Parameter SUPPRESSTRIGGERS & DEFERREFCONST

Slide:配置GoldenGate同步DDL语句

配置Golden gate同步ddl语句 View more documents from Maclean Liu

Best Practice – Oracle GoldenGate and Oracle Data Guard – Switchover/Failover Operations

Ogg golden gate and oracle data guard v8 View more documents from Maclean Liu

Oracle GoldenGate Best Practice sample parameter files

Ogg best practices_parameter_files_v1 View more documents from Maclean Liu

Goldengate OGG常见问题与错误列表

以下列出了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 . . . → Read More: Goldengate OGG常见问题与错误列表

How to set LOGSOURCE PATHMAP on GoldenGate

Question: the source machine os is solaris ,the mid machine os is linux , the target machine os is solaris,i want extract archive log file and pump trail file to target on mid machine , i check GoldenGate Reference Guide version 10.4 about TRANLOGOPTIONS, must set ARCHIVEDLOGONLY and LOGSOURCE PATHMAP , in my environment ,how . . . → Read More: How to set LOGSOURCE PATHMAP on GoldenGate

How GoldenGate process consumes memory

Question: We are using Golden Gate to replicate the data from Oracle 9.2.0.8 on Solaris8 SPARC 64 bit (GoldenGate Version 10.4.0.31 Build 001) to Oracle RAC 11.2.0.1 on Solaris10 SPARC 64bit (GoldenGate Version 10.4.0.19 Build 002). Both GoldenGate Extract and Replicat process are working fine. Please refer below information for more easy to understand our . . . → Read More: How GoldenGate process consumes memory