GoldenGate单向复制配置(支持DDL复制)

版本说明

                   Source               Target
Oracle             11.2.0.4.0           11.2.0.4.0
GoldenGate         12.2.0.1.1           12.2.0.1.1
OS                 CentOS 6.5           CentOS 6.5

不支持DDL验证

源端运行DDL语句

SQL> create table test(id number);

Table created.

目标端报错

[oracle@acarsorcl-ogg ogg]$ tail -n 500 ggserr.log

2016-07-18 15:45:25  INFO    OGG-06506  Oracle GoldenGate Delivery for Oracle, repa.prm:  Wildcard MAP resolved (entry skylink.*): map "SKYLINK"."TEST" target skylink."TEST".
2016-07-18 15:45:25  WARNING OGG-00869  Oracle GoldenGate Delivery for Oracle, repa.prm:  Table SKYLINK.TEST does not exist.
2016-07-18 15:45:25  ERROR   OGG-00199  Oracle GoldenGate Delivery for Oracle, repa.prm:  Table skylink.TEST does not exist in target database.
2016-07-18 15:45:25  ERROR   OGG-01668  Oracle GoldenGate Delivery for Oracle, repa.prm:  PROCESS ABENDING.

配置OGG支持DDL

1、赋予ogg用户相应的权限，修改全局配置文件添加ggschema参数（源端操作）

SQL> conn / as sysdba
Connected.
SQL> 
SQL> 
SQL> grant execute on utl_file to ogg;

Grant succeeded.

GGSCI (acarsorcl-primary) 17> edit param ./GLOBALS
GGSCI (acarsorcl-primary) 1> view param ./GLOBALS

    ggschema ogg

2、运行相关sql脚本（源端操作）

[oracle@acarsorcl-primary ~]$ cd /u01/ogg

[oracle@acarsorcl-primary ogg]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Mon Jul 18 15:56:33 2016
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @marker_setup.sql
Marker setup script
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: The schema must be created prior to running this script.
NOTE: Stop all DDL replication before starting this installation.
Enter Oracle GoldenGate schema name:ogg
Marker setup table script complete, running verification script...
Please enter the name of a schema for the GoldenGate database objects:
Setting schema name to OGG
MARKER TABLE
-------------------------------
OK
MARKER SEQUENCE
-------------------------------
OK
Script complete.

SQL> @ddl_setup.sql
Oracle GoldenGate DDL Replication setup script
Verifying that current user has privileges to install DDL Replication...
You will be prompted for the name of a schema for the Oracle GoldenGate database objects.
NOTE: For an Or