Expert Oracle GoldenGate by Ben Prusinski

By Ben Prusinski

Professional Oracle GoldenGate is a hands-on consultant to making and handling complicated info replication environments utilizing the most recent in database replication know-how from Oracle. GoldenGate is the long run in replication expertise from Oracle, and goals to be best-of-breed. GoldenGate helps homogeneous replication among Oracle databases. It helps heterogeneous replication concerning different manufacturers reminiscent of Microsoft SQL Server and IBM DB2 common Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes just a gentle influence at the functionality of databases all for replication.

Show description

Read Online or Download Expert Oracle GoldenGate PDF

Best oracle books

Oracle Database 11g PL / SQL Programming

Layout Feature-Rich PL/SQL ApplicationsDeliver dynamic, client/server PL/SQL functions with specialist counsel from an Oracle programming specialist. With complete assurance of the newest positive factors and instruments, Oracle Database 11g PL/SQL Programming lays out every one subject along particular motives, cut-and-paste syntax examples, and real-world case reports.

Oracle Weblogic Server 11gR1 PS2: Administration Essentials

This ebook is written in an easy-to-read type, with a powerful emphasis on real-world, sensible examples. step by step motives are supplied for appearing very important management projects. when you are an internet server administrator trying to find a brief consultant for appearing regimen and significant WebLogic server management services, together with configuring WebLogic server and deploying Java EE functions, then it is a ideal ebook for you.

Oracle database 11g : the complete reference

The Definitive advisor to Oracle Database 11gGet complete information at the robust positive factors of Oracle Database 11g from this completely up to date Oracle Press consultant. Oracle Database 11g: the whole Reference explains easy methods to use all of the new positive factors and instruments, execute robust SQL queries, build PL/SQL and SQL*Plus statements, and paintings with huge gadgets and object-relational databases.

Extra info for Expert Oracle GoldenGate

Sample text

It discusses adding the local Extract, data-pump Extract, and Replicat for ongoing change synchronization. You also review initial data-loading methods, including using GoldenGate and native DBMS utilities. More advanced configurations are covered in later chapters, such as bidirectional replication in Chapter 5, heterogeneous replication in Chapter 6, and zero-downtime migrations in Chapter 13. Keep in mind that the same concepts covered in this chapter are a foundation to build on for those more advanced configurations.

Data is replicated from a single source to a single target in only one direction. Changes to database data are only made at the source database. The target database is read-only. info CHAPTER 3 ■ ARCHITECTURE Figure 3-4. One-way replication A one-way configuration is useful for offloading intensive queries and reports from the source database. It can also be used for maintaining a hot-standby database for failover purposes. Another concept you should keep in mind is that the source and target databases can be different database technologies.

Online DML changes will be occurring in the source database while the initial-load process is running. This is the most likely scenario in today’s environments, where downtime usually needs to be avoided. If you can quiesce or stop DML activity against the source database while the initial load is occurring, it is not necessary to start the Extract before the initial load. Let’s look at each of the basic replication steps in detail, beginning with setting up and starting the Extract. Starting the Extract When you’ve verified that the prerequisites are complete, the first step you need to complete in setting up replication is to start the Extract.

Download PDF sample

Rated 4.95 of 5 – based on 3 votes