The tag has no usage guidance.

learn more… | top users | synonyms

6
votes
1answer
1k 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 ...
3
votes
2answers
2k 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. ...
3
votes
1answer
26 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 ...
1
vote
1answer
93 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 ...
1
vote
1answer
2k 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
vote
0answers
58 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 ...
0
votes
1answer
880 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 ...
0
votes
1answer
237 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 ...
0
votes
0answers
54 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 ...
0
votes
0answers
98 views

Golden Gate replication from primary to secondary database, WARNING OGG-01154 Oracle GoldenGate Delivery for Oracle, rgg1ab.prm: SQL error 1403

I am using golden gate to replicate data from primary(Oracle) to secondary (Oracle). I have inserted records in the primary database, but replication abdends with error message WARNING OGG-01154 ...
0
votes
0answers
33 views

GoldenGate: API to read trail files?

Is there an API to read GoldenGate Trail files? I would like to write my own adapter which reads a trail file and updates the state of an internal proprietary system.
0
votes
0answers
60 views

Integrated Extract: what does LogMiner Reader, Preparer and Builder do Exactly?

Have been pouring over Oracle GoldenGate documentations regarding Integrated Extract process. My understanding is that LogMiner Server LMx processes are now responsible for producing LCRs that Local ...
0
votes
0answers
149 views

Oracle AQ Message Replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far ...
-5
votes
0answers
66 views

Website is working very slowly [closed]

We have replication from Oracle to MySQL via Oracle Golden Gate. Yesterday because of some issues we have rebuilt the replication from Oracle to MySQL (this is called opal replication). Now our ...