Golden Gate – KTEXPERTS

How to change remote trail file location in Oracle GoldenGate.

2 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

OGG-08223 Error when registering Extract for a container database.

2 years ago by Binnary Ajay KumarGolden Gate

OGG-08223 Error when registering Extract for a container database. Hi Experts. In this article, we will see the OGG-08223 Error when registering Extract for a container database. I do have a plans to setup replication between the pluggable database in different containers. When registering… Read More

Replication to GCP PostgreSQL Using Oracle GoldenGate

2 years ago by Ankit GoyalGolden Gate

Replication to GCP PostgreSQL Using Oracle GoldenGate Use Case: Real-time replication of transactional data from an on-premises database to GCP Managed PostgreSQL instance using GoldenGate. Architecture: Source Database (Source Database can be any GoldenGate supported databases) Oracle GoldenGate (OGG) 19c/18c/12c for extraction from Source DB… Read More

Oracle : Adding new table to existing GoldenGate Replication without downtime

3 years ago by Binnary Ajay KumarAdd new table to existing GoldenGate Replication

Adding new table to existing GoldenGate Replication In this article, we will add a new table in existing GG replication setup without downtime using filter (@GETENV (‘TRANSACTION’,’CSN’) > scn number); Source : GG11 Target : GG12 Source : Connect and Login to the ggsci

[oracle@GG11 19c12]$ ./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.

[oracle@GG11 19c12]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 19.1.0.0.1 OGGCORE_19.1.0.0.0_PLATFORMS_190524.2201_FBO

Operating system character set identified as UTF-8.

Protected: Shell Script to get EMAIL alerts for Lagging between GoldenGate Processes

4 years ago by Vinod SiramAutomation scripts in Goldengate

There is no excerpt because this is a protected post.

Protected: Shell Script to get EMAIL alerts for STOPPED Processes in Oracle GoldenGate.

4 years ago by Vinod SiramAutomation scripts in Goldengate

There is no excerpt because this is a protected post.

Oracle GoldenGate Miscellaneous commands (Part-2)

4 years ago by Binnary Ajay KumarGolden Gate

Dear Readers, In the article, we will see Oracle GoldenGate Miscellaneous commands (Part-2) To check part -1 use below link Oracle goldengate miscellaneous commands part-1 To install Oracle GoldenGate use below link Installation of Oracle GoldenGate Miscellaneous Commands are : Obey LAG CLEANUP KILL SEND … Read More

Oracle GoldenGate Miscellaneous commands (Part-1)

4 years ago by Binnary Ajay KumarGolden Gate

Dear Readers, In the article, we will see Oracle GoldenGate Miscellaneous commands (Part-1) To install Oracle GoldenGate use below link Installation of Oracle GoldenGate Miscellaneous Commands are : INFO ALL, ALLOWNESTED | NOALLOWNESTED,, CREATE SUBDIRS, DEFAULTJOURNAL, FC, HELP, HISTORY OBEY, SHELL, VERSIONS, I want to explain… Read More

Usage of HandleCollisions and No HandleCollisions in Oracle GoldenGate 12c

4 years ago by Binnary Ajay KumarGolden Gate

Dear Readers, In the article, we will see HandleCollisions and NoHandleCollisions in Oracle GoldenGate 12c. To install Oracle GoldenGate use below link Installation of Oracle GoldenGate Note : HandleCollisions and NoHandleCollisions only valid for Replicat Process We use handlecollisons in replicat process on the… Read More

GoldenGate Monitoring Commands

4 years ago by Binnary Ajay KumarGolden Gate

Dear Readers, In this article we will see GoldenGate Monitoring Commands. The following steps will briefly discuss the different commands we can use to monitor the GoldenGate environment and get statistics and reports on various extract and replicat operations which are in progress. 1.Information on… Read More