MOS Oracle GoldenGate documentation

最新推荐文章于 2024-02-29 16:03:49 发布

原创最新推荐文章于 2024-02-29 16:03:49 发布 · 3.2k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle #Oracle GoldenGate

Oracle 同时被 2 个专栏收录

165 篇文章

订阅专栏

Oracle GoldenGate

18 篇文章

订阅专栏

See Individual products Notes for individual links:

Note 1304561.1 Master Note - Oracle GoldenGate - Upgrading OGG code
Note : 1235992.1 How to find Patches and Updates for Oracle GoldenGate
Note : 1293587.1 Searching the Patch site for a particular OGG release
Note : 970860.1 How To Apply Oracle GoldenGate Patches

Note: 1112325.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
Note: 1112406.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
Note: 1114746.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
Note: 1112403.1 Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM

Compatibility

Note : 965423.1 Is GoldenGate Compatible Between Different Releases?
Note : 1086154.1 Compatibility between OGG builds and Oracle database Versions
Note : 1300936.1 NSK Specific Main Note
Note: 266043.1 Support of Linux and Oracle Products on Linux

Performance and Tuning (LAG):

Note 1304557.1 Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes

Tracing:

Note 1304496.1 Main Note - Oracle GoldenGate - Tracing

Handlecollisions

Note 966207.1 What Does The HANDLECOLLISIONS Parameter Do

NLS_LANG

Note 969551.1 How is NLS_LANG Set When You Run OGG On The Superset Character Sets Database
Note 969651.1 ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.

Supplemental Logging

"Supplemental logging at the table level and the database level must be enabled for the tables from the source database."

Note 1304503.1 Main Note - Oracle GoldenGate - Supplemental Logging

RAC

Note 1304593.1 Main Note - Oracle GoldenGate - RAC

ARCHIVE LOG Sequence

Note 1186935.1 GGS Error 500 Could Not Find Archived Log For Sequence
Note 1108953.1 What does this mean? Redo thread 1: Online log /oracle/..... on sequence# nnn has missing
Note 971825.1 Why Does Extract For Oracle Abend With Error "Mismatched Sequences In Archive Log"?

CheckPoint

Note 1304617.1 Main Note - Oracle GoldenGate - Checkpoints
Note 1138409.1 EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAILFILE SIZE, AFTER SERVER CRASH

TCP Port Assignment and Usage:

Note 1300117.1 Main Note - OGG Port Usage and TCP

Colmap

Note 1302422.1 Column Mapping Usage
Note 1277199.1 REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
Note 1111576.1 Replicat Abends With Can Not Process Without All Fields Or Colmap Error

ASM

Note 1304627.1 Main Note - Oracle GoldenGate - ASM

TDE - Transparent data Encryption

Note 965745.1 How To Replicate Oracle TDE (Transparent Data Encryption) Data.
Note 1271522.1 Oracle GoldenGate (OGG) and Transparent Data Encryption (TDE)

ALTARCHIVELOGDEST

ALTARCHIVELOGDEST " Points Extract to the archived or backup Oracle transaction logs when they reside somewhere other than the default location. Extract first checks the specified location and then checks the default location"

Note 1060870.1 ALTARCHIVELOGDEST
Note 966243.1 How Do I Use The ALTARCHIVELOGDEST ; Parameter To Access Oracle Redo Archive Logs In An Alternate Directory?
Note 969500.1 Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
Note 969542.1 Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is

References

NOTE:1112406.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle JD Edwards
NOTE:1112506.1 - GoldenGate Extract Abends with "Unable to lock file" Error For Trail File
NOTE:1114746.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for PeopleSoft
NOTE:1138409.1 - OGG EXTRACT / REPLICAT CHECKPOINT RBA IS LARGER THAN LOCAL TRAIL SIZE
NOTE:1307305.1 - Master Note Oracle GoldenGate Management Pack - Director
NOTE:957053.1 - Recovering From a GG Pump Process Abending With An Incompatible Record Error
NOTE:957112.1 - OGG Encountered SCN That Is Not Greater Than The Highest SCN Already Processed
NOTE:964709.1 - How To Handle Oracle DDLs (add/drop/resize a Column)
NOTE:1298548.1 - Extract not accepting CACHESIZE settings
NOTE:1300076.1 - Usage and considerations for allocation of ports and DYNAMICPORTLIST
NOTE:1300117.1 - Master Note - OGG TCP Port Usage
NOTE:1159684.1 - OGG Extract abends,mss: missing trailing blocks, unable to queue I/O, I/O beyond file size
NOTE:965373.1 - Visual Representation of Oracle GoldenGate In An Oracle RAC Environment
NOTE:1276058.1 - Oracle GoldenGate Best Practices: Instantiation from an Oracle Source Database
NOTE:1276538.1 - Replicat Abending With Missing Key Columns
NOTE:1277199.1 - REPLICAT abend 'Error in COLMAP clause' but we aren't using COLMAP
NOTE:1280584.1 - Where To Find The List Of Supported And Unsupported Oracle Data Types (Datatypes) for GoldenGate ?
NOTE:1199561.1 - GoldenGate Replicat Characterset Conversion: Error 160 Bad column length
NOTE:1271578.1 - How to Handle Tables Without Primary Keys or Unique Indexes With Oracle GoldenGate
NOTE:1195995.1 - Implementing GoldenGate for DataGuard fail overs
NOTE:1271522.1 - Oracle GoldenGate (OGG) 11.1.1.0 and Transparent Data Encryption (TDE)
NOTE:1273285.1 - How To Troubleshoot Oracle Redo Log Reading Extract Slow Performance Issue using TESTMAPPINGSPEED
NOTE:1292874.1 - GoldenGate Extract/Pump/Replicat Abends on Startup with Error OGG-01088 Realloc xxx Bytes Failed.
NOTE:1293587.1 - Searching the Patch site for a particular OGG release
NOTE:965230.1 - How to Find GoldenGate on edelivery.oracle.com (Oracle Software Delivery Cloud)
NOTE:965270.1 - How does the Manager Allocate TCPIP Ports ?
NOTE:965356.1 - OGG GGS Error 150: No Dynamic Ports Available
NOTE:1112325.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle E-Business Suite
NOTE:1060547.1 - How To Set NLS_LANG When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1232303.1 - Oracle GoldenGate Best Practice: NFS Mount options for use with GoldenGate
NOTE:1060867.1 - How To Upgrade A Single Component In GoldenGate Version 10.0
NOTE:1060870.1 - ALTARCHIVELOGDEST Oracle GoldenGate Extract
NOTE:1061093.1 - Extract fail due to an ASM connection configuration issue
NOTE:1124403.1 - When Replicat is Running but Not Applying Records

NOTE:1108953.1 - What does this message mean? "Redo thread 1: Online log /oracle/..... on sequence# 8463 has missing trailing blocks."
NOTE:1111576.1 - Replicat Abends With Can Not Process Without All Fields Or Colmap Error
NOTE:1163073.1 - When using rmthost with timeout option, there are orphaned data collector processes on target system
NOTE:1186935.1 - GGS Error 500 Could Not Find Archived Log For Sequence
NOTE:1112403.1 - Deploying Oracle GoldenGate to Achieve Operational Reporting for Oracle Siebel CRM
NOTE:1235992.1 - How to find Patches and Updates for Oracle GoldenGate
NOTE:1266389.1 - Oracle GoldenGate: Compressed tables are not supported until OGG v11.2.x Integrated Extract.
NOTE:1270168.1 - Ogg-01028 Compression Not Supported - when extract processes regular and cluster tables
NOTE:1286276.1 - Why Isn't GoldenGate Manager Purging The Trail Files?
NOTE:1288562.1 - OGG Data Pumps Error With OGG-01031 When Upgrading the Target Side
NOTE:965394.1 - Installing GoldenGate Code Into An Existing Subvolume on NSK
NOTE:965423.1 - Is GoldenGate Compatible Between Different Releases?
NOTE:965745.1 - OGG How To Replicate Oracle TDE (Transparent Data Encryption) Data.
NOTE:966156.1 - Why Does Replicat Abend With ORA-01461?
NOTE:966181.1 - Installing GoldenGate For Oracle RAC
NOTE:966207.1 - What Does The HANDLECOLLISIONS Parameter Do?
NOTE:966211.1 - How To Resync A Single Table With Minimum Impact To Other Tables' Replication?
NOTE:1300197.1 - Logger not logging cobol transactions for GGSLIB with non default AUDCFG location
NOTE:1300933.1 - Main Note - Oracle GoldenGate Core Product - Open Systems
NOTE:1300936.1 - Main Master Note - Oracle GoldenGate Core Product - HP NonStop (NSK, Tandem, Guardian, S-Series)
NOTE:1302422.1 - Column Mapping Usage - COLMAP , USEDEFAULTS
NOTE:966227.1 - OGG Troubleshooting TCP/IP Errors In Open Systems
NOTE:966243.1 - How Do I Use The "ALTARCHIVELOGDEST" Parameter To Access Oracle Redo Archive Logs In An Alternate Directory Path?
NOTE:1304561.1 - Main Note - Oracle GoldenGate - Documentation and References for Upgrading OGG code
NOTE:1304564.1 - Main Note - Oracle GoldenGate - Installation
NOTE:969551.1 - How is NLS_LANG Set When You Run GoldenGate On The Superset Character Sets Database?
NOTE:1304593.1 - Main Note - Oracle GoldenGate - RAC
NOTE:1304617.1 - Main Note - Oracle GoldenGate - Checkpoints
NOTE:1304627.1 - Main Note - Oracle GoldenGate - ASM
NOTE:1307285.1 - Master Note Oracle GoldenGate Veridata
NOTE:969542.1 - Restored Archive Files To Another Location, Then Extract Failed With LOG_ARCHIVE_FORMAT Parameter Is Undefined
NOTE:969651.1 - ORA-12705: Invalid Or Unknown NLS Parameter Value Specified.
NOTE:970860.1 - How to Apply Oracle GoldenGate Patches
NOTE:971825.1 - Why Does Extract For Oracle Abend With The Error Message "Mismatched Sequences In Archive Log"?
NOTE:972954.1 - What Causes The GGS ERROR 160 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:969500.1 - Parameter Options After ALTARCHIVELOGDEST Entry Are Ignored
NOTE:968614.1 - Why Does GoldenGate Report The Lag Is Unknown or a Timestamp Mismatch?
NOTE:968622.1 - Does GoldenGate Support Tables With An UNUSED Column?
NOTE:968632.1 - Does GoldenGate Support Installation Of Its Product On A Shared Disk Subsystem In A Clustered Environment?
NOTE:968769.1 - GoldenGate Errors That Occur In Teradata Extract Setting
NOTE:1304496.1 - Main Note - Oracle GoldenGate - Tracing
NOTE:1304503.1 - Main Note - Oracle GoldenGate - Supplemental Logging
NOTE:1304557.1 - Main Note - Oracle GoldenGate - Lag, Performance, Slow and Hung Processes