Questions tagged [goldengate]
The goldengate tag has no usage guidance, but it has a tag wiki.
30
questions
0
votes
0
answers
87
views
Upgrade Oracle DB from 12C to 19C with minimum downtime
We are planning to apply the below steps -->
Export Live DB setup on the Oracle version 12C
Import on the new DB setup on version 19C
At this point, V12, and V19 schema structures will be exactly ...
0
votes
0
answers
48
views
Converting Wire Protocol from Oracle to Postgres and Vice-Versa
Naive Question
Assume we have an Application which was originally written for ORACLE as DBMS. If I want write an intermediary layer that gives this application independence to be able to work with ...
- 101
0
votes
0
answers
36
views
What is the equivalent of (ENABLE=BROKEN) in GoldenGate?
I realize this is a long shot but here goes. For Oracle databases you can add (ENABLE=BROKEN) in your connect string to work in coordination with OS TCP Keepalive settings. We have used this with AWS ...
- 221
-2
votes
1
answer
54
views
AWS TO OCI GOLDENGATE REPLICATION
I want to use oracle Goldengate to my Multi cloud setup database, I'm just wondering if Im required to down my primary database to avoid data discrepancy? or goldengate can sync the data even if my ...
0
votes
1
answer
284
views
Goldengate timestamp (FFF)
Working with Goldengate 19.1.0.0.211019
replicat inbound to Oracle 19.0.0.0.0
consuming a trail file incoming from Nonstop (ie a non-Oracle database).
Column in question from Nonstop is a string ...
- 476
0
votes
1
answer
197
views
Do we need additional license to dump goldengate trail logs to kafka?
We have a Oracle (12c) GoldenGate license only (we do not have an oracle goldengate for big data).
We need to transfer the gg trail logs to kafka then to hdfs.
Do we need to buy the oracle goldengate ...
- 3
0
votes
1
answer
213
views
oracle goldengate replication
Please I need help. Actually i am working on oracle 19c to perform a data base replication using the goldengate. I created two data bases (source and destination) the 3 processes (extract, pump and ...
0
votes
1
answer
229
views
Exclude Supplemental Logs from Import
I am trying to import tables from a production environment, to a test environment. The production environment has supplemental logs on a number of tables for golden gate replication. The ...
- 676
0
votes
1
answer
859
views
How to enable "only" drop partition DDL for Oracle Golden Gate?
I'm struggling with how to do this, and hoping somebody could assist with some ideas.
Oracle Golden Gate - general question. Version shouldn't be specific, however, I am currently running on:
Golden ...
- 476
0
votes
1
answer
191
views
Oracle golden gate to BigQuery
Im trying to setting up the Golden gate to sync the data to BigQuery. When I start pushing the initial load, my extractor exported all the data and even from the replicat stats Im able to see the ...
- 1,840
2
votes
0
answers
326
views
Whether or Not to Use DataPump with Oracle GoldenGate
We are setting up GoldenGate to keep 3 of our Oracle databases in sync. Regarding configuration:
We plan to have an instance of GoldenGate running on all 3 nodes. Each node will run an extract on (...
Lance Allison
1
vote
1
answer
2k
views
Oracle goldengate service is not starting: Failed to retrieve the name of a missing Oracle redo log
I am trying to start GG service, when try 'start my_service' then starting but it didn't start, status is changed always starting to stopped.
I need to start goldengate service.. I don't know what ...
- 11
1
vote
1
answer
284
views
Oracle Materialized View - Is it Safe to Use Only ROWID as Record Identifier?
this is a question related to Oracle 12c.
I'm currently trying to create MVs as data sources for Golden Gate replication. We need fast refresh because We have to replicate 60,000 rows + at one time ...
- 41
1
vote
2
answers
1k
views
Goldengate warning on table with primary key
Installed Goldengate Version 18.1.0.0.0 for Oracle 11gR2. Table has primary key and yet goldengate complains that there is no key found,see below
GGSCI (server01.localdomain as gguser@UPGR) 3> ...
user168186
2
votes
1
answer
881
views
Migration of table from MySQL to Oracle using GoldenGate
I have a table of size 120 GB in MySQL 5.7 which I need to migrate to Oracle 12c. I am using Oracle GoldenGate for initial load of the table.
I tried with initial load of full table but it consumed ...
- 21
1
vote
1
answer
3k
views
timestamp with timezone issue with TZR vs TZH:TZM
I have a Hibernate with Oracle JDBC based application inserting/updating into the following column;
COLUMN_A TIMESTAMP WITH TIME ZONE DEFAULT systimestamp NOT NULL
but while it automatically appends ...
- 111
0
votes
1
answer
272
views
Golden Gate activity auditing with SQL?
In a scenario where Oracle Golden Gate is used to replicate a primary site with an Oracle RAC database to a secondary site (and active/active back) we suspect unexpected changes from the unused ...
- 1,428
0
votes
1
answer
2k
views
Create User, Tablespace Replication in Oracle GoldenGate
How to replicate - Create User, Procedure and Tablespace using Oracle GoldenGate.
I am able to replicate DDL under schema, however above is not getting replicated i.e. when I create an user, ...
0
votes
1
answer
3k
views
Update is not happening in Golden Gate
I have configured GoldneGate and Extract, Data pump and Replicat everything is working fine. However Update is not happening. Below are my Extract, Data Pump and Replicat file.
Extract File:
extract ...
-1
votes
1
answer
1k
views
Golden Gate Privilege Missing for using Encryption
dblogin userid ogg_user, password AADAAAAAAAAAAAIAKAQIJAGAMFUFKFBGQHXBJIWGECTEIAZHJFYALFFIBGHGJBPFBCPBKEPCRCRHAESJ, AES128, encryptkey securekey1
ERROR: Unable to connect to database using user ...
1
vote
1
answer
2k
views
Getting Error/Exception In GoldenGate Replication
I am planning to configure a simple GoldenGate configuration and want to implement an exception table that will store all the exceptions. I followed two links, neither of which work for me:
...
4
votes
2
answers
1k
views
Golden Gate realtime replication basic question
I have a task to replicate unidirectional real time data from source database A to target database B. I do not need all the table from A, only few tables and few columns inside those tables. Say 10 ...
- 41
4
votes
1
answer
742
views
Can two transactions share the same SCN?
Do all transactions have a unique SCN? Can two transactions share an SCN?
I'm confused by this statement in the Oracle Golden Gate manual:
The CSN is cross-checked with the transaction ID (...
- 809
0
votes
0
answers
308
views
GoldenGate: How to encode Oracle RAW columns as hex strings?
I am using GoldenGate to extract an Oracle table that contains RAW data. The destination is a flat CSV file. How can I encode the RAW columns to hex strings so that they can be written to the CSV ...
- 809
1
vote
1
answer
737
views
Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs
How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database?
I want to have a replication/slave database to have all the ...
0
votes
1
answer
1k
views
BI-DIRECTIONAL Oracle Golden Gate for Oracle 12c and SQL Server 2014
I have two servers (both servers are on Windows OS):
Server_A running Oracle 12c
Server_B running SQL Server 2014
I want to implement data synchronization between them with Oracle Golden Gate ...
- 187
0
votes
1
answer
2k
views
Oracle GoldenGate add trandata errors
I am trying to add trandata to GoldenGate from SQL Server 2008 r2. I am getting an error stating
. ODBC error: SQLSTATE 01000 native database error 16954. [Microsoft][SQL Server Native Client 10.0][...
- 141
6
votes
1
answer
3k
views
Global locking for multi-master Oracle GoldenGate replication
This is a very complex scenario, but I figured a state-of-the-art challenge might interest some of the many high-end users of dba.se.
Problem
I'm working on an intercontinental data replication ...
- 1,060
3
votes
2
answers
3k
views
Tracking changes to a table via the update/insert cmds executed against it daily
We have an oracle database back end for our SAP ECC system. In it we have a table with over a billion records. We would like extract this table to our SAP BW, which happens to be on MSSQL Server. ...
- 133
2
votes
1
answer
4k
views
Replicating data from Oracle to MySQL
I work with a vendor that does data analytics, and they currently receive a replication stream from some of our databases using a product called Goldengate (which is very expensive). Goldengate has ...
- 1,228