Packt+ | Advance your knowledge in tech

You're reading from Oracle Goldengate 11g Complete Cookbook Dig deep into administering Oracle Goldengate 11g using this comprehensive cookbook. From the very basics of installation to advanced features like migration, you'll learn the practical way through code scripts and examples.

Product type Paperback

Published in Sep 2013

Publisher Packt

ISBN-13 9781849686143

Length 362 pages

Edition 1st Edition

Languages

Java

Tools

GoldenGate

Concepts

Data Streaming

Author (1):

Ankur Gupta

View More author details

Table of Contents (16) Chapters

Oracle GoldenGate 11g Complete Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

1. Installation and Initial Setup FREE CHAPTER

2. Setting up GoldenGate Replication

3. DDL Replication and Initial Load

4. Mapping and Manipulating Data

5. Oracle GoldenGate High Availability

6. Monitoring, Tuning, and Troubleshooting GoldenGate

7. Advanced Administration Tasks – I

8. Advanced Administration Tasks – Part II

9. GoldenGate Veridata, Director, and Monitor

Index

Replicating data from an active standby database in Archivelog mode only

In this recipe you will learn how to set up a GoldenGate configuration to replicate the data from the archived logs on an active standby database.

Getting ready

The setup used for this recipe consists of a primary database called DBORATES running on prim1-ol6-112. A physical standby database for DBORATES has been created with Oracle Active Dataguard on stdprim1-ol6-112. The standby database is configured to write its archived logs to /u01/app/oracle/fast_recovery_area/STDDB. The target database called TGORTEST is running on stdby1-ol6-112. GoldenGate binaries are already installed on stdprim1-ol6-112 and stdby1-ol6-112 and a Manager process has been set up on both of these servers. A GoldenGate Administrator has already been created in both the DBORATES and TGORTEST databases. A TNS entry DBORATEST has been set up on stdprim1-ol6-112 which resolves to the DBORATES database running on prim1-ol6-112.

How to do it…

The steps...

The rest of the chapter is locked