How to handle ddl in GoldenGate environment without ddl replication?

Question:gg only config to replicate dml, when source has some ddl changes, how to handle in source and target?

Answer:
GoldenGate capture the dml changes only by default,if you have made any changes in DDL structure,then stop the extract and replicat process and make changes in DDL structure and restart the extract and replicat process,then only extract can be able to capture the changes done at DDL structure.

It is advisible that stop extract,pump and replicat process make changes in the DDL and restart the extract,pump and replicat.
The above suggested procedure will not make any impact in DDL replication.

Also you can follow the below procedure
1. stop extract
2. stop data pump
3. there are lag in replicat, so replicat still running to reduce lag
4. do ddl in source, when replicat is running
5. stop replicat untill lag=0
6.do ddl in target
7.start extract and pump and replicat

Question:After do ddl in source, whether need to do delete and re-add the trandata on the table which is been changed?

Answer:
yes,you are correct,After doing DDL changes,you need to do delete and re-add the trandata on the table which is being changed.

© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.

相关文章 | Related posts:

1. GoldenGate实现Live Standby主备库切换(2)
2. How to create a GoldenGate uni-directional target database in a production database zero downtime
3. GoldenGate实现Live Standby主备库切换(1)
4. How to understand goldengate report file statistics
5. Compare and Converge in an Oracle Streams Replication Environment
6. Goldengate can’t extract data from compressed table
7. Oracle GoldenGate: Disaster Recovery Solution
8. How To Exclude A Table From Schema Capture And Replication When Using Schema Level Streams Replication
9. Goldengate一个令人郁闷的小细节
10. 配置GoldenGate同步DDL语句(2)