Clean the environment
We can clean our environment by deleting the components as follows:
Delete all groups
GGSCI (sourceSRV.izb.local) 1> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EBKDMP1 00:00:00 00:00:08 EXTRACT RUNNING EBKEXT1 00:00:00 00:00:04 GGSCI (sourceSRV.izb.local) 2> stop EBKDMP1 Sending STOP request to EXTRACT EBKDMP1 ... Request processed. GGSCI (sourceSRV.izb.local) 3> info EBKEXT1 EXTRACT EBKEXT1 Last Started 2018-01-16 11:15 Status RUNNING Checkpoint Lag 00:00:00 (updated 00:00:08 ago) Process ID 17209 Log Read Checkpoint Oracle Redo Logs 2018-01-16 12:36:12 Seqno 2664, RBA 5423616 SCN 0.474510079 (474510079) GGSCI (sourceSRV.izb.local) 4> stop EBKEXT1 Sending STOP request to EXTRACT EBKEXT1 ... Request processed. GGSCI (sourceSRV.izb.local) 5> cleanup EBKDMP1 Cleanup completed GGSCI (sourceSRV.izb.local) 6> dblogin userid ggate password "password" Successfully logged into database. GGSCI (sourceSRV.izb.local as ggate@DBNAME) 7> cleanup EBKEXT1 Cleanup completed GGSCI (sourceSRV.izb.local as ggate@DBNAME) 8> delete EBKDMP1 Deleted EXTRACT EBKDMP1. GGSCI (sourceSRV.izb.local as ggate@DBNAME) 9> delete EBKEXT1 Deleted EXTRACT EBKEXT1. GGSCI (sourceSRV.izb.local as ggate@DBNAME) 10> info all Program Status Group Lag at Chkpt Time Since Chkpt MANAGER RUNNING
Be sure to delete any retail file: local retail and remote retail file. Any configuration can files can be located via:
Check config
GGSCI (sourceSRV.izb.local) 4> show all Parameter settings: SET DEBUG OFF Current directory: /u01/app/oracle/product/12.1.2/<instance release> Editor: vi Reports (.rpt) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirrpt Parameters (.prm) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirprm Replicat Checkpoints (.cpr) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirchk Extract Checkpoints (.cpe) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirchk Process Status (.pcs) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirpcs SQL Scripts (.sql) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirsql Database Definitions (.def) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirdef Dump files (.dmp) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirdmp Masterkey wallet files (.wlt) /u01/app/oracle/product/12.1.2/DBNAME_gg/dirwlt Credential store files (.crd) /u01/app/oracle/product/12.1.2/DBNAME_gg/dircrd
Last, clean the local trails in dirdat directory on the home. P.S. the file started with lt (local trails)
Clean local trails
[oracle@sourceSRV dirdat]$ ls -lart total 8 drwxr-xr-x 29 oracle oinstall 4096 Nov 14 14:35 .. drwxr-x--- 2 oracle oinstall 4096 Jan 16 12:35 .
!!!!!P.S. DO NOT DELETE THE REDO LOG FILES :) !!!!!!