Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

Using GoldenGate event actions to suspend replication for end of day reporting

By | Database Administration & Monitoring | 3 Comments

The last post in this series outlined on how to do an initial load of the target database using the “expdp/impdp” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat Performing an initial load with GoldenGate (2) – expdp/impdp In this post I’ll look into how to use event actions to suspend GoldenGate replication for…

 
Read More
Oracle Team

set state=apply-off and datafile consistency

By | Database Administration & Monitoring, Oracle | One Comment

By Franck Pachot . In a standby database (or in any database you recover) do you think the recovery uses buffer cache? And when you stop the apply in a standby database, do you think the datafiles are in a consistent state? We know the answer, but want to prove it. This is the kind of question you may have, as I did last Friday morning in the train with Ludovico Caldara when going to…

 
Read More
Daniel Westermann

Performing an initial load with GoldenGate (2) – expdp/impdp

By | Database Administration & Monitoring | 11 Comments

The last post in this series outlined on how to do an initial load of the target database using the “file to replicat” method: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate Performing an initial load with GoldenGate (1) – file to replicat In this post I’ll show how to do the initial load by exporting a schema from the source database, importing that into the…

 
Read More
Daniel Westermann

Performing an initial load with GoldenGate (1) – file to replicat

By | Database Administration & Monitoring | 4 Comments

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release.The second post explained how to create a sample replication with Oracle GoldenGate: Installing and patching Oracle GoldenGate 12c to the latest release Setting up a sample replication with GoldenGate In this post I’ll look how to do an initial load using GoldenGate by using the “File to replicat” method (several other methods are available). To start…

 
Read More
David Barbarin

SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks?

By | Database Administration & Monitoring | 12 Comments

A couple of days ago, I was involved in a project about implementing availability groups with SQL Server 2014. My customer wanted to isolate the replication traffic from the public network. The idea behind was to get a better control of the network bandwidth as well as to be sure that the replication can be done without any latency issues in case of heavily network traffic issued by other applications or backup activities for instance….

 
Read More
Daniel Westermann

Setting up a sample replication with GoldenGate

By | Database Administration & Monitoring | 7 Comments

The first post in this series outlined on how to install and patch Oracle GoldenGate to the latest release: Installing and patching Oracle GoldenGate 12c to the latest release In this post I’ll look in how to prepare the databases and how to setup GoldenGate for a first sample replication between two Oracle 12.1.0.2 databases. My test setup is as follows: Hostname Database Type oelgg1 DB1 Source oelgg2 DB2 Target   The idea is that…

 
Read More