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 :) !!!!!!