Hello all,
I have installed the golden gate on both servers and all processes are running but the rep(is running ) is not updating the table.
Below i will list the statistics for each process:
GGSCI (DB-TEST as c##ggadmin@CDBPROD/CDB$ROOT) 3> stats ext1
Sending STATS request to EXTRACT EXT1 ...
Start of Statistics at 2023-03-29 15:21:05.
Output to /oracle/gg/GG_HOME/dirdat/ex:
*** Total statistics since 2023-03-24 15:11:57 ***
Total inserts 0.00
Total updates 1.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 1.00
GGSCI (DB-TEST as c##ggadmin@CDBPROD/CDB$ROOT) 4> stats dp1
Sending STATS request to EXTRACT DP1 ...
Start of Statistics at 2023-03-29 15:23:51.
Output to /oracle/gg/GG_HOME/dirdat/rt:
Extracting from DBPROD.REPORT.PASSINV to DBPROD.REPORT.PASSINV:
*** Total statistics since 2023-03-24 15:11:57 ***
Total inserts 0.00
Total updates 1.00
Total deletes 0.00
Total upserts 0.00
Total discards 0.00
Total operations 1.00
Until now it is ok but rep process hasn't done anything
GGSCI (DB-DEV as c##ggadmin@CDBDEV/CDB$ROOT) 4> stats rep1
Sending STATS request to REPLICAT REP1 ...
No active replication maps.
Integrated Replicat Statistics:
Total transactions 0.00
Redirected 0.00
Replicated procedures 0.00
DDL operations 0.00
Stored procedures 0.00
Datatype functionality 0.00
Operation type functionality 0.00
Event actions 0.00
Direct transactions ratio 0.00%
Please have anyone any ide for this issue?
In the report file i haven't any error on rep process:
***********************************************************************
** Run Time Messages **
***********************************************************************
2023-03-24 15:08:16 INFO OGG-02243 Opened trail file /oracle/gg/GG_HOME/dirdat/rt000000000 at 2023-03-24 15:08:16.196336.
2023-03-24 15:08:16 WARNING OGG-02760 ASSUMETARGETDEFS is ignored because trail file /oracle/gg/GG_HOME/dirdat/rt000000000 contains table definitions.
2023-03-24 15:08:16 INFO OGG-03506 The source database character set, as determined from the trail file, is UTF-8.
2023-03-24 15:08:47 INFO OGG-01021 Command received from GGSCI: STATS.
2023-03-24 15:09:40 INFO OGG-02232 Switching to next trail file /oracle/gg/GG_HOME/dirdat/rt000000001 at 2023-03-24 15:09:40.306080 due to EOF. with current RBA 2,219.
2023-03-24 15:09:40 INFO OGG-04048 Processed graceful restart record at seq 1 rba 1,337.
2023-03-24 15:09:46 INFO OGG-04048 Processed graceful restart record at seq 1 rba 1,395.
2023-03-24 15:11:37 INFO OGG-01021 Command received from GGSCI: STATS.
2023-03-24 15:12:07 INFO OGG-01971 The previous message, 'INFO OGG-01021', repeated 4 times.
Thank you