解除安裝goldengate相關配置資訊

 GoldenGate軟體基於資料庫日誌結構變化，透過解析源端線上日誌或歸檔日誌獲得資料增量，再將這些變化傳輸並應用到目標資料庫，從而實現源庫和目標庫的資料同步
解除安裝goldengate，需要停止gg相關的所有服務，刪除gg所有檔案所在的目錄，然後刪除資料庫中相關的記錄。

一，在源端，停止extract和管理服務：
GGSCI (rac1) 1> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING EXT1 00:00:00 00:00:09

GGSCI (rac1) 2> stop ext1

Sending STOP request to EXTRACT EXT1 …
Request processed.

GGSCI (rac1) 3> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER …
Request processed.
Manager stopped.

GGSCI (rac1) 4> info all

Program Status Group Lag Time Since Chkpt

MANAGER STOPPED
EXTRACT STOPPED EXT1 00:00:00 00:00:42

二，在目標端，停止replicat和管理服務：
GSCI (redhat6) 6> info all

Program Status Group Lag Time Since Chkpt

MANAGER RUNNING
REPLICAT RUNNING REP1 00:00:00 00:00:09

GGSCI (redhat6) 7> stop rep1

Sending STOP request to REPLICAT REP1 …
Request processed.

GGSCI (redhat6) 8> stop mgr
Manager process is required by other GGS processes.
Are you sure you want to stop it (y/n)? y

Sending STOP request to MANAGER …
Request processed.
Manager stopped.

GGSCI (redhat6) 9> info all

Program Status Group Lag Time Since Chkpt

MANAGER STOPPED
REPLICAT STOPPED REP1 00:00:00 00:00:17

三，刪除源資料庫中的使用者：

SQL> drop user gg cascade;
drop user gg cascade
*
第 1 行出現錯誤:
ORA-00604: 遞迴 SQL 級別 2 出現錯誤
ORA-20782: GoldenGate DDL Replication Error: Code :ORA-20782: Cannot DROP
object used in GoldenGate replication while trigger is enabled. Consult
GoldenGate documentation and/or call GoldenGate Technical Support if you wish
to do so., error stack: ORA-06512: 在 line 203
ORA-06512: 在 line 915

SQL> drop trigger ggs_ddl_trigger_before;

觸發器已刪除。

SQL> drop user gg cascade;

使用者已刪除。

SQL> drop user ggs cascade;

使用者已刪除。

四，刪除目標資料庫中的使用者：

SQL> drop trigger ggs_ddl_trigger_before;

觸發器已刪除。

SQL> drop user gg cascade;

使用者已刪除。

SQL> drop user ggt cascade;

使用者已刪除。