Loading....

Very often in these forums I get asked the question regarding data types which GoldenGate supports or Oracle software versions or questions like can it work with a database running in NOARCHIVELOG mode or does it support Partitioned and Index Organised tables and so forth.

I have included some snippets taken from the official documentation as well as some of my own experiences and hopefully it will help answer many of the those frequently asked questions.

What Oracle Versions are supported?

Oracle 9.2 and above, Oracle 10.1 and 10.2 and Oracle 11gR1 and 11gR2

How many Extract or Replicat processes can we start?

GoldenGate supports upto 300 Extract and Replicat processes per GoldenGate instance. But keep in mind that each process consumes around 50 MB of memory.

What Oracle Data Types are supported?

NUMBER
BINARY FLOAT
BINARY DOUBLE
CHAR
VARCHAR2
LONG
NCHAR
NVARCHAR2
RAW
LONG RAW
DATE
TIMESTAMP
CLOB
NCLOB
BLOB (SECUREFILE and BASICFILE are both supported.)
XML data types
User defined types

Oracle GoldenGate supports user defined types (UDT) when the source and target objects have the same structure. The schema names can be different.

Oracle GoldenGate does not support REF types.

Oracle GoldenGate supports SDO_GEOMETRY, SDO_TOPO_GEOMETRY, and SDO_GEORASTER for Oracle 10g and later.

Non-Supported Data Types

ORDDICOM
ANYDATA
ANYDATASET
ANYTYPE
BFILE
MLSLABEL
TIMEZONE_ABBR
TIMEZONE_REGION
URITYPE
UROWID

DML Support

Oracle GoldenGate supports the following DML operations made to regular tables, index organized tables, clustered tables, and materialized views.

INSERT
UPDATE
DELETE

Note:

Oracle GoldenGate supports tables with virtual columns, but does not capture change.

Tables created as EXTERNAL are not supported.

Tables created with table compression or OLTP table compression are not supported.

Materialized views created WITH ROWID are not supported.

Support for Sequences

Oracle GoldenGate supports the replication of sequence values by means of the SEQUENCE parameter
The cache size and the increment interval of the source and target sequences must be identical.

DDL Replication Support

Oracle Goldengate supports DDL operations on the following database objects:

clusters
functions
indexes
packages
procedure
tables
tablespaces
roles
sequences
synonyms
triggers
types
views
materialized views
users

Note:

Oracle GoldenGate supports the synchronization of TRUNCATE statements as well as part of the DDL synchronization support.

DDL On Oracle Reserved Schemas is not supported.

These include:

ANONYMOUS
AURORA
$JIS
$UTILITY
$AURORA
$ORB
$UNAUTHENTICATED
CTXSYS
DBSNMP
DMSYS
DSSYS
EXFSYS
MDSYS
ODM
ODM_MTR
OLAPSYS
ORDPLUGINS
ORDSYS
OSE$HTTP$ADMIN
OUTLN
PERFSTAT
PUBLIC
REPADMIN
SYS
SYSMAN
SYSTEM
TRACESVR
WKPROXY
WKSYS
WMSYS
XDB

Because of a known issue in Oracle 10g, the Oracle recycle bin must be turned off to support Oracle GoldenGate DDL replication.

Source and Target database charactersets

The character set of the target database must be a superset of the character set of the source database.

Can I run the source database in NOARCHIVELOG mode?

Oracle GoldenGate reads the online redo logs by default, but will read the archived logs if an online log is not available. If using in NOARCHIVELOG mode ensure that the redo log files are created with a larger size and more memebsrs are created to prevent then form being recycled before the Extract process has completed processing them.

GoldenGate using Data Guard Standby as a source

You can configure the Extract process to read exclusively from the archived logs. This is known as Archived Log Only (ALO) mode. In this mode, Extract only reads from archived logs that are stored in a specified location. ALO mode allows Oracle GoldenGate to use production log files that are shipped over to a standby database as a data source for Oracle GoldenGate. The online logs will not be used.

Oracle GoldenGate will connect to the secondary database to get metadata and other required data as needed. Supplemental logging at the table level and the database level must be enabled for the tables from the source database.

How do we handle Triggers and ON-DELETE cascade constraints on the target?

For Oracle 10.2.0.5 and later patches, and for Oracle 11.2.0.2 and later, you can use the Replicat parameter DBOPTIONS with the SUPPRESSTRIGGERS option to cause Replicat to disable the triggers during its session.

For Oracle 9.2.0.7 and later, you can use the Replicat parameter DBOPTIONS with the DEFERREFCONST option to delay checking and enforcement of integrity constraints until the Replicat transaction commits.

Please follow and like us:

Last Update: May 4, 2017  

November 24, 2010 32 Gavin Soorma
Total 0 Votes:
0

Tell us how can we improve this post?

+ = Verify Human or Spambot ?

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?

7 thoughts on “GoldenGate – What is supported and what is not ….

  1. Patrick

    Hey! Thanks for all your blogs. I was wondering, what’s the ideal timeline for a gg project. I have to do a write up for a gg multi source to a single target config and then i have to do a single node to multi target config and both are bi-directional. I suggested three months but since oracle has no white paper for this, i can’t provide a certified documentation for it. I’d appreciate your input. thanks.

  2. Balasaheb Kambale

    Hi,
    Its very useful info for us .
    as we are new to GG.

    Do we use delete or truncate command on GG’s table when we are importing any new data
    into source database?

    What is effect on GG’s table if we use delete or truncate command ?

    what will be effect if i use DDL command on GG’s table on source database?

  3. Abhi

    Hi Gavin,

    Thank you very much for all the blogs regarding GoldenGate. It is comprehensive and very useful.

  4. Pradeep Gupta

    Bala, you can enable truncate command replication in report parameter file.

    GETTRUNCATES

    Also for DDL replication you can set the parameter for ALL or specific Operation type.

    DDL &
    INCLUDE MAPPED &
    OPTYPE alter &
    OBJTYPE ‘table’ &
    OBJNAME “SCOTT.*” &
    DDLOPTIONS REPORT
    DDLERROR 942 IGNORE RETRYOP MAXRETRIES 5
    DDLERROR 2430 IGNORE
    DDLERROR 2431 IGNORE

    Thanks,

  5. Robin Dong

    hi,
    I have posted 3 comments online and asked you some questions, but never get any single word back from you.

    I guess I should not use this as a commuinication channel with you. It is fine to me.

    your artcles are still very helpful.

  6. Gavin Soorma

    Hi Robin – sorry – in the flood of emails I get I must have missed it – can you drop me an email with your questions again and I will try and answer to the best of my ability or at least tell you where you can get more information.

    email me @ gavin.soorma@oncalldba.com.au

    Regards,

    Gavin

Leave a Comment

Your email address will not be published. Required fields are marked *

*
*

Social media & sharing icons powered by UltimatelySocial
Back To Top

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?