Database Administration & Monitoring If we stop the GoldenGate replication: Will transactions running at that time on the source will be replicated before replication stops? 08.09.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring, Oracle Measuring IOPS on XtremIO 07.09.2015 by Oracle Team By Franck Pachot . Today, we can put our database on very efficient storage. EMC XtremIO is one of them. In this blog post, I'll show how to look at the IO performance from Enterprise Manager, Orachrome Lighty, and XtremIO(…)
Database Administration & Monitoring Using GoldenGate event actions to suspend replication for end of day reporting 07.09.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring, Oracle set state=apply-off and datafile consistency 06.09.2015 by Oracle Team 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(…)
Database Administration & Monitoring Performing an initial load with GoldenGate (2) – expdp/impdp 04.09.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring Performing an initial load with GoldenGate (1) – file to replicat 03.09.2015 by Daniel Westermann 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(…)
Database Administration & Monitoring, Database management Oracle 12c duplicate in cluster fails with ORA-65500 03.09.2015 by David Hueber I had to perform a duplicate database between 2 ODAs and was always facing an ORA-65500 at the begin of the RMAN operation. Looking a bit deeper in the log outputs pointed me out that it was due to some(…)
Database Administration & Monitoring, Oracle Oracle Standard Edition Two 02.09.2015 by Oracle Team By Franck Pachot . Look at the Oracle Download page: Standard Edition is there in 12.1.0.2 - more than one year after the release of the patchset for Enterprise Edition. It's a new name - SE2(…)
Database Administration & Monitoring SQL Server AlwaysOn and availability groups : how to isolate the replication traffic from other networks? 01.09.2015 by Microsoft Team 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(…)
Database Administration & Monitoring Setting up a sample replication with GoldenGate 01.09.2015 by Daniel Westermann 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(…)