Remote trail file Change

How to change remote trail file location in Oracle GoldenGate.

3 years ago by Binnary Ajay KumarGolden Gate

Hello Everyone, This article will teach you how to change remote trail file location in Oracle GoldenGate. Current location : /u01/GG_AWS_P1/GG_trails/aws_trails/ New Location : /dbbackup/GG_trails/aws_trails GG Process Details : Source :

GGSCI (gg.oracle.com) 2> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING DPAWSP1 00:00:00 00:00:06
EXTRACT RUNNING EXAWSP1 00:00:03 00:00:05

GGSCI (gg.oracle.com) 2> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

EXTRACT RUNNING DPAWSP1 00:00:00 00:00:06

EXTRACT RUNNING EXAWSP1 00:00:03 00:00:05

Target :

GGSCI (gg2.oracle.com) 6> info all
Program Status Group Lag at Chkpt Time Since Chkpt
REPLICAT RUNNING REPAWSP1 00:00:08 00:00:04

GGSCI (gg2.oracle.com) 6> info all

Program Status Group Lag at Chkpt Time Since Chkpt

REPLICAT RUNNING REPAWSP1 00:00:08 00:00:04

Check Replicat trail file location

GGSCI (gg2.oracle.com) 2> info REPAWSP1 detail 

REPLICAT   REPAWSP1  Last Started 2021-12-10 01:01   Status RUNNING
INTEGRATED
Checkpoint Lag       00:00:00 (updated 00:00:07 ago)
Process ID           45824
Log Read Checkpoint  File /u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321
                     2022-01-22 06:44:24.997155  RBA 202887709
INTEGRATED Replicat
No DBLOGIN Provided, constructed inbound server name is OGG$REPAWSP1
Current Log BSN value: (requires database login)
Low Watermark CSN value: (requires database login)
High Watermark CSN value: (requires database login)
  Extract Source                          Begin             End             
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321  2021-12-10 00:38  2022-01-22 06:44
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658  2021-12-10 00:14  2021-12-10 00:38
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658  2021-11-12 04:02  2021-12-10 00:14
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000000000  * Initialized *   First Record    
  /u01/GG_AWS_P1/GG_trails/aws_trails/R1000000000  * Initialized *   First Record    
Current directory    /u01/app/oracle/product/ogg_src
Report file          /u01/app/oracle/product/ogg_src/dirrpt/REPAWSP1.rpt
Parameter file       /u01/app/oracle/product/ogg_src/dirprm/REPAWSP1.prm
Checkpoint file      /u01/app/oracle/product/ogg_src/dirchk/REPAWSP1.cpr
Process file         
Error log            /u01/app/oracle/product/ogg_src/ggserr.log

GGSCI (gg2.oracle.com) 2> info REPAWSP1 detail

REPLICAT REPAWSP1 Last Started 2021-12-10 01:01 Status RUNNING

INTEGRATED

Checkpoint Lag 00:00:00 (updated 00:00:07 ago)

Process ID 45824

Log Read Checkpoint File /u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321

2022-01-22 06:44:24.997155 RBA 202887709

INTEGRATED Replicat

No DBLOGIN Provided, constructed inbound server name is OGG$REPAWSP1

Current Log BSN value: (requires database login)

Low Watermark CSN value: (requires database login)

High Watermark CSN value: (requires database login)

Extract Source Begin End

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000004321 2021-12-10 00:38 2022-01-22 06:44

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658 2021-12-10 00:14 2021-12-10 00:38

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000003658 2021-11-12 04:02 2021-12-10 00:14

/u01/GG_AWS_P1/GG_trails/aws_trails/R1000000000 * Initialized * First Record

Current directory /u01/app/oracle/product/ogg_src

Report file /u01/app/oracle/product/ogg_src/dirrpt/REPAWSP1.rpt

Parameter file /u01/app/oracle/product/ogg_src/dirprm/REPAWSP1.prm

Checkpoint file /u01/app/oracle/product/ogg_src/dirchk/REPAWSP1.cpr

Process file

Error log /u01/app/oracle/product/ogg_src/ggserr.log

Remote trail file location… Read More