Table created.

# 查看Extract捕获
GGSCI (fgedu.net.cn)> STATS E_FGEDU01, DDL

DDL operations captured:
CREATE TABLE 1
Total DDL operations 1

# 验证目标端
SQL> SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME=’FGEDU_TEST_DDL’;

TABLE_NAME
——————————
FGEDU_TEST_DDL

# 测试2：ALTER TABLE同步
# 源端修改表
SQL> ALTER TABLE fgedu01.fgedu_test_ddl ADD (description VARCHAR2(500));

Table altered.

SQL> ALTER TABLE fgedu01.fgedu_test_ddl MODIFY (name VARCHAR2(200));

Table altered.

# 验证目标端
SQL> DESC fgedu02.fgedu_test_ddl;

Name Null? Type
—————————————– ——– —————————-
ID NOT NULL NUMBER
NAME VARCHAR2(200)
CREATE_DATE DATE
DESCRIPTION VARCHAR2(500)

# 测试3：CREATE INDEX同步
# 源端创建索引
SQL> CREATE INDEX fgedu01.idx_fgedu_test_name ON fgedu01.fgedu_test_ddl(name);

Index created.

# 验证目标端
SQL> SELECT INDEX_NAME FROM USER_INDEXES WHERE TABLE_NAME=’FGEDU_TEST_DDL’;

INDEX_NAME
——————————
SYS_C001234
IDX_FGEDU_TEST_NAME

# 测试4：DROP同步
# 源端删除索引
SQL> DROP INDEX fgedu01.idx_fgedu_test_name;

Index dropped.

# 验证目标端
SQL> SELECT INDEX_NAME FROM USER_INDEXES WHERE TABLE_NAME=’FGEDU_TEST_DDL’;

INDEX_NAME
——————————
SYS_C001234

# 测试5：TRUNCATE同步
# 源端插入数据
SQL> INSERT INTO fgedu01.fgedu_test_ddl VALUES (1, ‘TEST’, SYSDATE, ‘DESC’);

1 row created.

SQL> COMMIT;

Commit complete.

# 源端TRUNCATE
SQL> TRUNCATE TABLE fgedu01.fgedu_test_ddl;

Table truncated.

# 验证目标端
SQL> SELECT COUNT(*) FROM fgedu02.fgedu_test_ddl;

COUNT(*)
———-
0

# DDL同步配置
# Extract端配置
EXTRACT E_ECOMM
USERIDALIAS fgedu_alias
EXTTRAIL /GoldenGate/app/dirdat/ec

DDL &
INCLUDE MAPPED OBJTYPE ‘TABLE’ &
INCLUDE MAPPED OBJTYPE ‘INDEX’ &
EXCLUDE OBJNAME ‘FGEDU01.TEMP_*’ &
EXCLUDE OBJNAME ‘FGEDU01.BAK_*’ &
EXCLUDE OBJNAME ‘FGEDU01.LOG_*’ &
DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3

TABLE fgedu01.*;

# Replicat端配置
REPLICAT R_ECOMM
USERIDALIAS fgedu_alias
ASSUMETARGETDEFS

DDL &
INCLUDE MAPPED &
DDLOPTIONS REPORT &
DDLOPTIONS RETRYOP RETRYDELAY 10 MAXRETRIES 5 &
DDLOPTIONS IGNOREAPPLOPS &
DDLERROR DEFAULT IGNORE RETRYOP MAXRETRIES 3 &
DDLERROR 1430 IGNORE &
DDLERROR 955 IGNORE

MAP fgedu01.*, TARGET fgedu02.*;

# DDL同步测试结果
# 1. 添加字段测试
SQL> ALTER TABLE fgedu01.fgedu_orders ADD (promo_code VARCHAR2(50));
— 目标端同步成功，耗时约2秒

# 2. 创建索引测试
SQL> CREATE INDEX fgedu01.idx_orders_date ON fgedu01.fgedu_orders(order_date);
— 目标端同步成功，耗时约5秒

# 3. 修改字段测试
SQL> ALTER TABLE fgedu01.fgedu_orders MODIFY (promo_code VARCHAR2(100));
— 目标端同步成功，耗时约1秒

# DDL同步统计（运行30天）
GGSCI (fgedu.net.cn)> STATS R_ECOMM, DDL, TOTAL

DDL operations applied:
CREATE TABLE 15
ALTER TABLE 128
DROP TABLE 8
CREATE INDEX 45
DROP INDEX 12
TRUNCATE TABLE 23
Total DDL operations 231
from GoldenGate视频:www.itpux.com

# 原因分析
目标端有事务正在访问该表，DDL无法获取锁

# 解决方案
# 方案1：配置重试
DDLOPTIONS RETRYOP RETRYDELAY 30 MAXRETRIES 10

# 方案2：等待事务完成后手动重试
GGSCI (fgedu.net.cn)> START R_FGEDU01

# 问题2：DDL对象不存在错误
# 错误信息
ERROR OGG-00519 DDL error [ORA-00942: table or view does not exist].

# 原因分析
目标端缺少对应的表对象

# 解决方案
# 手动在目标端创建表
SQL> CREATE TABLE fgedu02.fgedu_new_table AS SELECT * FROM fgedu01.fgedu_new_table WHERE 1=0;

# 重启Replicat
GGSCI (fgedu.net.cn)> START R_FGEDU01

# 问题3：DDL触发器冲突
# 错误信息
ERROR OGG-00519 DDL error [ORA-04092: cannot COMMIT in a trigger].

# 原因分析
目标端存在触发器与DDL操作冲突

# 解决方案
# 临时禁用触发器
SQL> ALTER TRIGGER fgedu02.trg_orders DISABLE;

# 执行DDL后重新启用
SQL> ALTER TRIGGER fgedu02.trg_orders ENABLE;

# 问题4：DDL同步延迟过大
# 现象
GGSCI (fgedu.net.cn)> INFO R_FGEDU01

REPLICAT R_FGEDU01 Last Started 2026-04-10 10:00:00 Status RUNNING
Checkpoint Lag 00:15:00 (updated 00:00:01 ago)

# 原因分析
大表DDL操作耗时过长

# 解决方案
# 1. 选择低峰期执行大表DDL
# 2. 使用ONLINE选项创建索引
SQL> CREATE INDEX fgedu01.idx_large_table ON fgedu01.fgedu_large(col1) ONLINE;

# 3. 分批执行DDL操作

echo “=== OGG DDL同步监控 ===”
echo “监控时间: $(date)”
echo “”

cd /GoldenGate/app

# 检查DDL统计
echo “1. 检查Extract端DDL捕获…”
./ggsci < STOP R_FGEDU01

# 2. 查看最后成功的DDL
GGSCI (fgedu.net.cn)> INFO R_FGEDU01, SHOWCH

# 3. 手动修复目标端结构
SQL> ALTER TABLE fgedu02.fgedu_orders DROP COLUMN new_column;

# 4. 跳过错误的DDL
GGSCI (fgedu.net.cn)> ALTER REPLICAT R_FGEDU01, EXTRBA 12345678

# 5. 重启Replicat
GGSCI (fgedu.net.cn)> START R_FGEDU01