卸载OGG DDL同步

郑全

有时安装了OGG的DDL同步，后面又没有使用了，但在升级数据库版本时，容易出现问题，能否把OGG 的DDL同步卸载掉呢 .

答案是肯定的，安装如下步骤执行即可：


1、进入GoldenGate安装目录，运行ggsci.exe
2、关闭运行中的进程
    info all
    stop *
    stop mgr
3、退出ggsci.exe，从ogg目录进入 sqlplus
    sqlplus "/as sysdba"
4、运行ddl_disable.sql脚本来禁用DDL触发器
SQL> @ddl_disable.sql
触发器已更改
5、运行ddl_remove.sql脚本来移除GoldenGate DDL触发器、DDL历史和标记表以及其他相关的对象。
注意：Enter Oracle GoldenGate schema name：处输入DDL信息所在用户
SQL> @ddl_remove.sql
DDL replication removal script.
WARNING: this script removes all DDL replication objects and data.
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.
Enter Oracle GoldenGate schema name:ggs
Working, please wait ...
Spooling to file ddl_remove_spool.txt
Script complete.
6、运行marker_remove.sql脚本来移除GoldenGate marker支持系统。
SQL> @marker_remove.sql
Marker removal script.
WARNING: this script removes all marker objects and data.
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.
Enter Oracle GoldenGate schema name:ggs
PL/SQL 过程已成功完成。
序列已删除。
表已删除。
Script complete.
7、如果用户是专门用来存放DDL信息的，可以删除用户
SQL> drop user ggs cascade;
用户已删除