Data duplication is ubiquitous in enterprises today. Almost every application in an organization needs information from some other part of the organization. Oracle GoldenGate has become such a predominant tool in the industry today thus allowing organizations to share data between disparate environments. Its adoption rate is increasing very quickly because of the ease of use, economy of speed, and small footprint required to implement it.
Implementing design considerations (Simple) presents a number of design decisions to consider, such as your platform of choice, physical memory requirements, storage, and network considerations such as high and low latency networks.
Installing Oracle GoldenGate (Simple) guides you through the step-by-step process of downloading the software from Oracle's website, unpacking the software, and installing it on your server host.
Creating one-way replication (Simple) will explore how to implement a downstream replication by creating Extract and Pump processes on the source system for capturing and transporting source data to your target system. A Replicat process is created on your target server which applies changes received from the source system.
Creating bidirectional replication (Simple) also sometimes referred to as master to master replication, performs the same steps as in the recipe, Creating one-way replication (Simple) and in the opposite direction.
Creating heterogeneous replication (Simple) lets you start discovering the ease of implementing replication between disparate RDBMS environments, such as Oracle to SQL Server. However, there are a number of other different RDBMS combinations as well.
Configuring Oracle GoldenGate for High Availability (HA) (Simple) although might sound more complex than it really is, it is quite simple and differs slightly from a single-instance installation.
Configuring advanced settings (Simple) discovers the power and flexibility of Oracle GoldenGate to perform tasks such as data mapping, filtering, and data transformation.
Performing encryption in OGG (Simple) discusses encrypting the Oracle GoldenGate user ID and trail files at rest and in flight using Blowfish and AES algorithms for 128, 192, and 256 bits.
Managing Oracle GoldenGate (Simple) allows you to explore some of the more interactive commands to view, monitor, and troubleshoot Oracle GoldenGate processes during a running instance.
Performance tuning (Simple) explores plausible solutions to increase efficiencies and data throughput in your environment, even under high latency networks, as one of the most common concerns regarding replication is how to get data faster to the target system.
In order to use Oracle GoldenGate, you need an existing Oracle database in place, or any of the supported databases for Oracle GoldenGate such as SQL Server, Teradata, Sybase, and so on. Then, and only then, you can download and use the Oracle GoldenGate software. For a complete list of supported database, you can reference Oracle® GoldenGate Windows and Unix Administrator's Guide 11g Release 2 Patch Set 1 (11.2.1.0.1) E29397-01.
Typically, Oracle GoldenGate is administered by database administrators because its design is database-centric. Although, not limited to database administrators, data specialists, data architects can also make use of the product from a quality assurance perspective.
In this book, you will find a number of styles of text that distinguish between different kinds of information. Here are some examples of these styles, and an explanation of their meaning:
Code words in text are shown as follows: "We can include other contexts through the use of the include directive."
A block of code is set as follows:
OGG_SRVC =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hosta1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = hosta2-vip)(PORT = 1521))
(LOAD_BALANCE = NO)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = OGG_SRVC)
)
)When we wish to draw your attention to a particular part of a code block, the relevant lines or items are set in bold:
SPECIALRUN ENDRUN SETENV (ORACLE_SID="TRG101") SETENV (ORACLE_HOME="/u01/app/oracle/product/11.2.0/db_1") SETENV (NLS_LANG = "AMERICAN_AMERICA.AL32UTF8")
Any command-line input or output is written as follows:
$ ln –s /ggtrail/dirdat /GG/dirdat $ ln –s /ggtrail/dirchk /GG/dirchk $ ln –s /ggtrail/br /GG/br $ ln –s /ggtrail/dirtmp /GG/dirtmp
New terms and important words are shown in bold. Words that you see on the screen, in menus or dialog boxes for example, appear in the text like this: "clicking the Next button moves you to the next screen".
Feedback from our readers is always welcome. Let us know what you think about this book—what you liked or may have disliked. Reader feedback is important for us to develop titles that you really get the most out of.
To send us general feedback, simply send an e-mail to <[email protected]>, and mention the book title via the subject of your message.
If there is a topic that you have expertise in and you are interested in either writing or contributing to a book, see our author guide on www.packtpub.com/authors.
Now that you are the proud owner of a Packt book, we have a number of things to help you to get the most from your purchase.
Although we have taken every care to ensure the accuracy of our content, mistakes do happen. If you find a mistake in one of our books—maybe a mistake in the text or the code—we would be grateful if you would report this to us. By doing so, you can save other readers from frustration and help us improve subsequent versions of this book. If you find any errata, please report them by visiting http://www.packtpub.com/submit-errata, selecting your book, clicking on the errata submission form link, and entering the details of your errata. Once your errata are verified, your submission will be accepted and the errata will be uploaded on our website, or added to any list of existing errata, under the Errata section of that title. Any existing errata can be viewed by selecting your title from http://www.packtpub.com/support.
Piracy of copyright material on the Internet is an ongoing problem across all media. At Packt, we take the protection of our copyright and licenses very seriously. If you come across any illegal copies of our works, in any form, on the Internet, please provide us with the location address or website name immediately so that we can pursue a remedy.
Please contact us at <[email protected]> with a link to the suspected pirated material.
We appreciate your help in protecting our authors, and our ability to bring you valuable content.
You can contact us at <[email protected]> if you are having a problem with any aspect of the book, and we will do our best to address it.