Tagged Questions

0
votes
0answers
24 views

Oracle to SQL Server DDL replication

We have this customer requirement to do DDL + DML transactional replication from Oracle to SQL Server 2012. The DML part is straightforward. There are multiple options to choose from including the SQL ...
0
votes
0answers
21 views

Oracle Downstream Log transfers

I am attempting to create a downstream capture process for two Oracle 11 databases running on Linux servers. The replication will be one-way and asynchronous using archive logs as the transfer ...
0
votes
0answers
37 views

How we can synchronize a MySQL database to an Oracle database?

How we can synchronize a MySQL database to an Oracle database? The Oracle database is in secure zone that can only be accessed by application servers. We have multiple MySQL databases in different ...
5
votes
1answer
348 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 ...
0
votes
0answers
54 views

Oracle: Mirror database changes between two databases

I need to keep two whole databases constantly synchronized. That includes: Data (of course) DDL Changes (also changes to stored procedures and pl/sql packages) All changes need to be propagated ...
1
vote
1answer
127 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
5
votes
0answers
97 views

9i streams capture doesn't evaluate rules

I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
1
vote
1answer
159 views

oracle streams - how to get last successfully applied scn for crashed apply?

I have a downstream Streams replication set up between Oracle 9i (source) and Oracle 11g (destination). The process is still in developlment stage, so the whole setup is not stable yet. Sometimes my ...
2
votes
1answer
48 views

Transaction stays in capture queue

I set up simple bidirectional db replication using Oracle Streams. I used enterprise manager for this. Streams are active and their status is ok. The problem is that the replication is very slow. What ...
1
vote
1answer
423 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 ...
5
votes
4answers
142 views

Replicating only changes made by a specific database user

I am performing parallel testing. We have upgraded the legacy batch jobs to a new framework which we need to test against the existing batch jobs. In the existing setup, I have web application which ...
2
votes
2answers
630 views

Advanced Replication vs Oracle Streams

I'd like to know what is advantages of Streams over Advanced Replication. I wanted to use updatable materialized views on my project, but on one forum I read comment that if we don't use very old ...
0
votes
0answers
122 views

Oracle Data Guard Fast-Start Failover Questions

Here is the setup in question: Fast-Start Failover: ENABLED Threshold: 30 seconds Target: dbabc Observer: (none) Lag Limit: 30 seconds (not in use) Shutdown Primary: FALSE ...
2
votes
0answers
187 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
2
votes
0answers
472 views

Oracle GoldenGate replication is stuck

I deployed Oracle GoldenGate to integrate many-to-one databases. After initial loading everything works fine. Until recently, some of the replicat seem to stuck and do not proceed to change ...
2
votes
2answers
137 views

Temporary replication of data between continental datacenters

I need a way to temporarily replicate data between two data centers on two continents for a small number of large tables in Oracle. The data in the tables is around 30Gb but the transfer rate is only ...
0
votes
0answers
54 views

Replicating Results of Queries on Oracle

I wan to setup a database such that its data come from queries run on a remote database. Basically the source database is very slow and we have no control over it. So, I want to create a second ...
5
votes
3answers
484 views

Database replication and consistency check

I got a question about 2 databases (oracle 10g) that I have, let's call them A and B. A have some information(in various tables) and I want B to get a partial copy of some tables from A, and ...
1
vote
2answers
730 views

Does the target for Double-Take replication require an Oracle license?

Where would Vision Solution's Double-Take product fall with regard to Oracle Licensing? It is both a backup and a replication of the database. Oracle's Software Investment Guide has a section on ...
2
votes
1answer
549 views

database duplication VS database replication

Is there a difference between duplication and replication with reference to a database? I am not sure if I am correct at all, but duplication means to me that we are copying bit by bit without ...
1
vote
1answer
374 views

SAN Storage & Server for Oracle Replication

I need a 2-3 TB storage server group for Oracle Database. We want SAN Storage & Server for Oracle Replication, but not Microsoft Storage Server. For example : HP DL380 G6 as a server and EMC ...