解除安裝goldengate相關配置資訊
Oracle 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 ...
Manager stopped.
GGSCI (rac1) 4> info all
MANAGER STOPPED
EXTRACT STOPPED EXT1 00:00:00 00:00:42
二,在目标端,停止replicat和管理服務:
GSCI (redhat6) 6> info all
REPLICAT RUNNING REP1 00:00:00 00:00:09
GGSCI (redhat6) 7> stop rep1
Sending STOP request to REPLICAT REP1 ...
GGSCI (redhat6) 8> stop mgr
GGSCI (redhat6) 9> info all
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 ggs cascade;
四,删除目标資料庫中的使用者:
SQL> drop user ggt cascade;
五,删除gg所在目錄,至此gg完全删除。