Book Image

Oracle Goldengate 11g Complete Cookbook

By : Ankur Gupta
Book Image

Oracle Goldengate 11g Complete Cookbook

By: Ankur Gupta

Overview of this book

Oracle Goldengate 11g Complete Cookbook is your complete guide to all aspects of Goldengate administration. The recipes in this book will teach you how to setup Goldengate configurations for simple and complex environments requiring various filtering and transformations. It also covers various aspects of tuning and troubleshooting the replication setups using exception handling, custom fields, and logdump utility.The book begins by explaining some basic tasks like Installation and Process groups setup. You will then be introduced to some further topics including DDL replication and various options to perform Initial Loads. You will then learn some advanced administration tasks such as Multi Master replication setup and conflict resolution. Further recipes, contain the cross platform replication and high availability options for Goldengate.
Table of Contents (16 chapters)
Oracle GoldenGate 11g Complete Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Supported datatypes in Oracle GoldenGate


Oracle GoldenGate has some restrictions in terms of what it can replicate. With every new release, Oracle is adding new datatypes to the list of what is supported. The list of the datatypes of the objects that you are planning to replicate should be checked against the list of supported datatypes for the GoldenGate version that you are planning to install.

Getting ready

You should have identified the various datatypes of the objects that you plan to replicate.

How to do it…

The following is a high-level list of the datatypes that are supported by Oracle GoldenGate v11.2.1.0.1:

  • NUMBER

  • BINARY FLOAT

  • BINARY DOUBLE

  • CHAR

  • VARCHAR2

  • LONG

  • NCHAR

  • NVARCHAR2

  • RAW

  • LONG RAW

  • DATE

  • TIMESTAMP

  • CLOB

  • NCLOB

  • BLOB

  • SECUREFILE and BASICFILE

  • XML datatypes

  • User defined/Abstract datatypes

  • SDO_GEOMETRY, SDO_TOPO_GEOMETRY, and SDO_GEORASTER are supported

How it works…

There are some additional details that one needs to consider while evaluating the supported datatypes for a GoldenGate version. For example, the user-defined datatypes are only supported if the source and target tables have the same structures. Both Classic and Integrated Capture modes support XML types which are stored as XML, CLOB, and XML binary. However, XML type tables stored as Object Relational are only supported in Integrated Capture mode.

There's more…

The support restrictions apply to a few other factors apart from the datatypes. Some of these are as Manipulating Data:

  • INSERTs, UPDATEs and DELETEs are supported on regular tables, IOTs, clustered tables and materialized views

  • Tables created as EXTERNAL are not supported

  • Extraction from compressed tables is supported only in Integrated Capture mode

  • Materialized views created with ROWID are not supported

  • Oracle GoldenGate supports replication of the sequences only in uni-directional mode