REPLICAT Golden gate - "No active replication maps." error message

======================================

Replicat is giving "No active replication maps."

======================================

SEND REP_I_01 STATS
Sending STATS request to REPLICAT REP_I_01 ...
No active replication maps.

What to check?

INFO REP_I_01 DETAIL

Current directory    /software/ogg/191

Report file          /software/ogg/191/dirrpt/REP_I_01.rpt

Parameter file       /software/ogg/191/dirprm/rep_i_01.prm

Checkpoint file      /software/ogg/191/dirchk/REP_I_01.cpr

Checkpoint table     OGG.GGS_CHECKPOINT

Process file

Error log            /software/ogg/191/ggserr.log

less /software/ogg/191/dirrpt/REP_I_01.rpt

 Opened trail file /software/ogg/191/dirdat/01/in/ei000001673 at 2021-06-21 10:38:15.162627.

 

-rw-r----- 1 oracle dba 132849 Jun 21 09:15 /software/ogg/191/dirdat/01/in/ei000001672

-rw-r----- 1 oracle dba  30904 Jun 21 09:40 /software/ogg/191/dirdat/01/in/ei000001673

-rw-r----- 1 oracle dba 114623 Jun 21 11:23 /software/ogg/191/dirdat/01/in/ei000004596

-rw-r----- 1 oracle dba  81883 Jun 21 12:34 /software/ogg/191/dirdat/01/in/ei000004597

GGSCI (hostname) 1> INFO REP_I_01

REPLICAT   REP_I_01  Last Started 2021-06-21 10:38   Status RUNNING

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

Process ID           13683

Log Read Checkpoint  File /software/ogg/191/dirdat/01/in/ei000001673

                     2021-06-21 09:16:11.197537  RBA 30904

ls -ltr /software/ogg/191/dirdat/01/in/ei000*

-rw-r----- 1 oracle dba 132849 Jun 21 09:15 /software/ogg/191/dirdat/01/in/ei000001672

-rw-r----- 1 oracle dba  30904 Jun 21 09:40 /software/ogg/191/dirdat/01/in/ei000001673

-rw-r----- 1 oracle dba 114623 Jun 21 11:23 /software/ogg/191/dirdat/01/in/ei000004596

-rw-r----- 1 oracle dba  81883 Jun 21 12:34 /software/ogg/191/dirdat/01/in/ei000004597

Need to advance REPLICAT to the correct sequence

GGSCI (hostname) 3> STOP REPLICAT REP_I_01

Sending STOP request to REPLICAT REP_I_01 ...

Request processed.

GGSCI (hostname) 4> ALTER REPLICAT REP_I_01, EXTSEQNO 4596, EXTRBA 0

2021-06-21 12:36:56  INFO    OGG-06594  Replicat REP_I_01 has been altered. Even the start up position might be updated, duplicate suppression remains active in next startup. To override duplicate suppression, start REP_I_01 with NOFILTERDUPTRANSACTIONS option.

REPLICAT altered.

GGSCI (hostname) 3> START REPLICAT REP_I_01

Sending START request to MANAGER ...

REPLICAT REP_P_01 starting

GGSCI (hostname) 6> INFO REP_I_01

REPLICAT   REP_I_01  Last Started 2021-06-21 12:37   Status RUNNING

Checkpoint Lag       00:00:06 (updated 00:00:04 ago)

Process ID           11340

Log Read Checkpoint  File /software/ogg/191/dirdat/01/in/ei000004597

                     2021-06-21 12:37:07.003724  RBA 85137

File was set to 4596, but REPLICAT is already at 4597 - working!

 

GGSCI (hostname) 24> SEND REP_I_01 STATS

Sending STATS request to REPLICAT REP_I_01 ...

Start of Statistics at 2021-06-21 12:37:39.

Replicating from OGG.GG_HEARTBEAT_SEED to OGG.GG_HEARTBEAT:

*** Total statistics since 2021-06-21 12:37:09 ***

        Total inserts                                      0.00

        Total updates                                     75.00

        Total deletes                                      0.00

        Total upserts                                      0.00

        Total discards                                     0.00

        Total operations                                  75.00

 

Now, the stats are coming

======================================

Extract is giving "No active replication maps."

======================================

SEND EXTRACT DPM_I_01 STATS

Sending STATS request to EXTRACT DPM_I_01 ...

No active extraction maps.

INFO DPM_P_01

oracle@qanfv-1-dbs-1a:/software/ogg/191>% ls -ltr /software/ogg/191/dirdat/01/in/ep000000*

-rw-r----- 1 oracle dba 1520270 Jun 21 09:15 /software/ogg/191/dirdat/01/in/ep000000028

-rw-r----- 1 oracle dba  362544 Jun 21 09:40 /software/ogg/191/dirdat/01/in/ep000000029

-rw-r----- 1 oracle dba 8493214 Jun 21 09:41 /software/ogg/191/dirdat/01/in/ep000000195

-rw-r----- 1 oracle dba 9944956 Jun 21 10:00 /software/ogg/191/dirdat/01/in/ep000000196

-rw-r----- 1 oracle dba 1068368 Jun 21 10:12 /software/ogg/191/dirdat/01/in/ep000000197

-rw-r----- 1 oracle dba 1051251 Jun 21 11:23 /software/ogg/191/dirdat/01/in/ep000000198

-rw-r----- 1 oracle dba 1006145 Jun 21 12:30 

GGSCI (hostname) 6> SEND EXTRACT DPM_P_01, FORCESTOP

Sending FORCESTOP request to EXTRACT DPM_N_01 ...

STOP request will be executed immediately (recovery aborted).

GGSCI (hostname) 6> ALTER EXTRACT DPM_P_01, begin 2021-06-21 09:59:50

EXTRACT altered.

GGSCI (hostname) 6> START DPM_P_01

Sending START request to MANAGER ...

EXTRACT DPM_P_01 starting

GGSCI (hostname) 6> SEND DPM_P_01 STATS

Sending STATS request to EXTRACT DPM_P_01 ...

Start of Statistics at 2021-06-21 12:32:03.

Output to /software/ogg/191/dirdat/01/in/ep:

Extracting from LAB_QANFV_ALLQQ.SHM_SERVICE_PROCESSES to LAB_QANFV_ALLQQ.SHM_SERVICE_PROCESSES:

*** Total statistics since 2021-06-21 12:31:54 ***

        Total inserts                                      0.00

        Total updates                                  19204.00

        Total deletes                                      0.00

        Total upserts                                      0.00

        Total discards                                     0.00

        Total operations                               19204.00

Now, the stats are coming

Additional info

All GG processes were setup with a wrong remote host IP

After configuration change + restart + unregister and register the extract and datapump,

processes were still using a wrong sequence for files.