Arquivo da categoria: GOLDENGATE

<?xml version=”1.0″?> <configuration reset=”true”>   <appender name=”traceini”>     <param name=”BufferedIO”     value=”false”/>     <param name=”Append”         value=”true”/>     <param name=”File”           value=”traceLog_%I_%A”/>     <param name=”MaxBackupIndex” value=”99″/>     <param name=”MaxFileSize”    value=”10MB”/> <layout>       <param name=”Pattern” value=”%d{%m/%d %H:%M:%S} [%C{1}:%L] %m%n”/>     </layout>   </appender> <logger … Continuar lendo →

Purpose Questions and Answers 1. What is the Logdump utility and when to use it? 3. How to filter based on a table name? 4. How to remove the current filter criteria? 5. How to filter on multiple conditions? 6. … Continuar lendo →

Explain the purpose of the REPERROR replicat parameter Questions and Answers The REPERROR parameter is valid for Replicat only Use the REPERROR parameter to control how Replicat responds to errors. You can use one REPERROR statement to handle most errors … Continuar lendo →

Is there a way to improve REPLICAT performance/throughput?   Cause Cause In its normal mode, Replicat applies one SQL statement at a time, in the same order as the changes occurred on the source system.   Despite optimizations and statement … Continuar lendo →

Oracle GoldenGate (OGG) extract abends with following error: OGG-00665 OCI Error getting OCI_ATTR_NAME for UDT (status = 24328-ORA-24328: illegal attribute value), SQL<Not available>. the internal parameter to ignore unsupported datatypes is already in use DBOPTIONS _IGNOREUNSUPPORTEDUDTTYPES one of following OGG … Continuar lendo →

Rows can be ignored or discarded rather than sent to the database if before/after filters are used in the replicat. This can cause the amount of data to be sent to the database to be reduced if certain data is … Continuar lendo →

The GGSCI command INFO EXTRACT <group> shows that the RBA is not increasing and the LAG is increasing. Extract seems to be hanging.   Fix   Extract may be processing a long transaction.   To check, issue this command:   … Continuar lendo →

I am replicating 100 tables, everything has been running fine for a while. Suddenly, one of the target tables is out of sync. How could I bring this table back in sync without affecting other tables? Answer:1. Stop your Replicat … Continuar lendo →

How To Check The Supplemental Log Information In Oracle   Solution There are two types of supplemental logging: database supplemental logging and table supplemental logging.   Database supplemental logging specifies supplemental logging for an entire database, while table supplemental logging … Continuar lendo →

Goal If a column is used to calculate the range, why won’t the downstream trails be divided exactly by the column value?   Here is a customer case that demonstrates this configuration. A customer wanted to split the load on … Continuar lendo →

Splitting an existing replicat ( or extract ) with the RANGE command into multiple replicats (extracts) (Doc ID 1320133.1) Goal Replicating a high volume of change data in a single data stream (one extract, one pump, one replicat, for example) … Continuar lendo →

Some of the Oracle GoldenGate (OGG) Range Replicats abend with following error   ORA-00054: resource busy and acquire with NOWAIT   Cause It happens if one of the Range Replicats applies DDL changes and during that brief moment when the … Continuar lendo →