Infrastructure at your Service

Category Archives: Database Administration & Monitoring

Daniel Westermann

If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops?

By | Database Administration & Monitoring | No Comments

This is the next post on this GoldenGate series: 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 Using GoldenGate event actions to suspend replication for end of day reporting One question that pops up when stopping the replication by using an event marker is: What happens…

 
Read More
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
Franck Pachot

set state=apply-off and datafile consistency

By | Database Administration & Monitoring, Oracle | One Comment

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 the Paris Oracle Meetup….

 
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 | 2 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