goldengate performance https://docs.oracle.com/goldengate/1212/gg-winux/GWUAD/wu_performance.htm#GWUAD684 and Goldengate 12c Implementors Guide Chapter 9 et. al. and my list LOBs are special case – separate the processing of them with parallel processing groups – and don’t use BATCHSQL tuning parameter on them, obviously make sure there is a PK. Baseline with default single extract, data pump, and replicate processes …
Goldengate in help in general is not very user friendly but, a good start is the help command at a ggsci prompt: For help on a specific command, type HELP <command> <object> Example: HELP ADD REPLICAT This guy has supplemented help at this blog… a truly useful summary of commands – it may not be …
Reference to another blog showing Goldengate command summary with examples Read More »
# create the table(s), primary key, sequence, and trigger # the sequence and trigger auto populate the primary key CREATE TABLE dept ( ID NUMBER(10) NOT NULL, DESCRIPTION VARCHAR2(50) NOT NULL); ALTER TABLE dept ADD ( CONSTRAINT dept_pk1 PRIMARY KEY (ID)); CREATE SEQUENCE dept_seq START WITH 1; Trigger definition: CREATE OR REPLACE TRIGGER dept_bir BEFORE INSERT …
Simple PL/SQL to generate a load for Goldengate and others Read More »
While working on tuning a Goldengate replicate process I ran into something that would speed up slow migrations. The redolog algorythm modifying parameters below can be used for more than just Goldengate. When using Goldengate these would only be used during conversion on the 12c replicat side – and possibly at the session level. Both …
The 12c new feature “identity columns” are not yet support with Goldengate 12.2 / 12c. The failure to replicate the new “identity” type will not be logged – anywhere. The issue is only identified by running GoldenGate Integrated Extract Healthcheck script, found in MOS article 1448324.1 – but that means you have to be pro-active. So, if …
12c new feature identity column not yet support with Goldengate 12.2 / 12c Read More »
This blog demonstrates an Oracle GoldenGate 12.2 setup Uni-Directional Sync of a subset of schemas Oracle 12.2 DB with / using RMAN Active Duplicate for the “Initial Load” (initial GoldenGate load of the target). The entire DB will be duplicated so we can replicate whatever schemas we choose – for now I’m picking HR – which …
Encrypting passwords in GoldenGate parameter files on Linux generate keys, run the keygen command from the GoldenGate software installation home KEYGEN key length n Where: (key length) is the encryption key length (n) represents the number of keys to generate. # cd into your goldengate home – oraInventory knows where that is if you don’t …
Encrypting passwords in GoldenGate parameter files Linux Read More »