了解Maclean Liu|向Maclean Liu提问 Oracle ALLSTARS 全明星(群内有多位Oracle高级售后support,N位OCM和ACE) QQ群 # QQ群号:23549328 # 已经升级到 2000人群,空位多多。欢迎有一定基础的Oracle骨友加入,现在入群需要经过Maclean的技术面试,欢迎面试,请加QQ号:47079569 为好友参加面试 2群基础群 适合刚入门的同学,会共享最佳入门实践和资料 QQ群 # QQ群号:171092051 # 已经升级到 500人的超级群,空位多多,无需面试

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.

posted on 2010-12-23 05:43  Oracle和MySQL  阅读(150)  评论(0编辑  收藏  举报

导航