If we choose to do the Initial Load before synchronization via GoldenGate Replicat or simply Replicat has a large volume of data to synchronize, one Replicat thread is not enough. In this article we will see two ways to… read more
How to create users in databases that belong to a SQL Server Always On Availability Group
When we create new users in databases that belong to an Always On Availability Group in SQL Server, we want them to work even if they failover to a Secondary node, but when we create a new login in a SQL… read more
How do we configure GoldenGate replication to read from Oracle Data Guard Standby
In this article we will see how we can configure an extract process to extract its trail files from the Standby logs without affecting the Primary. This way is called… read more
How can we connect Oracle Database to SQL Server using Oracle Gateway on Windows
In a previous article we saw how we can run queries on a remote SQL Server from an Oracle Database located on Linux through Oracle Database Gateway. In this article we will see how to install Oracle Gateway respectively... read more
How to replicate tables from SQL Server to Oracle Database using GoldenGate
In a previous article we saw how we can replicate tables from Oracle Database to SQL Server using GoldenGate. In this article we will see how we can do the reverse from SQL Server to… read more
How do we add a database that has TDE Encryption enabled to a SQL Server Always On Availability Group?
In a previous article we have seen that TDE (Transparent Data Encryption) is the encryption of a database at a physical level. That is, it encrypts data files, log files and backups. When a database in SQL Server has enabled… read more
How can we get emails whenever syncing to SQL Server via Oracle GoldenGate is having problem
When we synchronize tables through Oracle GoldenGate, it can either stop the extract of the source from writing trail files to the target in the tables, or stop the replicat of the target from applying the trail files. So for any… read more
How we enable Oracle Data Guard with automatic failover for High Availability
In a previous article we saw how we activate Oracle Data Guard in physical standby. Now we will take the installation one step further with a modern commit that will allow us to enable automatic failover from primary to standby... read more
How do we install Oracle Data Guard as a Physical Standby for Disaster Recovery?
In this article we will see step by step how to install Oracle Data Guard as Physical Standby on Unix. By using it, we have the possibility that changes made on the primary base are automatically transferred to another standby... read more
