Change remote trail location RMTTRAIL in pump in Goldengate

 Summary: This section explains the method to change REMOTE TRAIL location used in PUMP process in goldengate.

Description:

This blog is for modifying the remote trail RMTRAIL location in pump.

Case if to changing the mount point.

Location Before -/u02/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2

Location After -/u03/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2

Assumptions: 

1. GG manager is already configured.
2. DB level metadata, table/schema trandata is configured.
3. GG user is configured and had DBA access to datatabase

Detailed steps :

export ORACLE_HOME=/u01/app/oracle/product/12.1.0.2/dbhome_1
export GG_HOME=/gghome/app/oracle/product/dbhome_2/gghome12c    
export ORACLE_SID=GGDB01
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$GG_HOME:$LD_LIBRARY_PATH:$ORACLE_HOME/bin:$PATH:.

On Destination server, create the complete path , where trails files will be transfered by the PUMP process.

Go to Parameter Directory:

cd ${GG_HOME}

Steps:

info extract ppppia02

stop extract ppppia02

delete RMTTRAIL ./dirdat/j2, EXTRACT ppppia02

ADD RMTTRAIL /u03/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIA02/j2, EXTRACT ppppia02

Note: the new directory must be in /GLOBALS parameter on destination GG ,

under the paramete ALLOWOUTPUTDIR [relative_dir_name | absolute_dir_name]

info extract ppppia02

info extract ppppia02, detail

edit param ppppia02 >> Change RMTRAIL Location in parameter file: RMTTRAIL /u03/app/oracle/product/19.0.0.0/gghome_1/dirdat/RPPPIB03/j3

start EXTRACT ppppia02

info extract ppppia02