Hello
I'm replicating data from source database 11g on Windows to target 12c (pdb) on Linux. Problem arises when extract process stop working and Time Since Chkpt keep increasing. Though the process still shows it self as running but the transactions are not being replicated.
I don't see anything significant in extract log file:
***********************************************************************
** Run Time Messages **
***********************************************************************
2016-11-18 00:02:46 INFO OGG-01516 Positioned to Sequence 95, RBA 101420048, SCN 0.0 (0), Nov 18, 2016 12:01:22 AM.
2016-11-18 00:02:46 INFO OGG-01517 Position of first record processed Sequence 95, RBA 101420048, SCN 0.1158429947 (1158429947), Nov 18, 2016 12:01:22 AM.
2016-11-18 00:05:18 INFO OGG-06507 MAP (TABLE) resolved (entry test.invoices): table "test"."invoices".
2016-11-18 00:05:18 WARNING OGG-00752 Failed to validate table test.invoices. Likely due to existence of unused column. Please make sure you use sourcedefs in downstream Replicat, or the target table has exactly the same unused columns when using ASSUMETARGETDEFS or DDL replication.
2016-11-18 00:05:19 INFO OGG-06509 Using the following key columns for source table test.invoices: INVOICEID.
2016-11-18 00:05:19 INFO OGG-01054 Recovery completed for target file d:\gg_src\dirdat\s1000000007, at RBA 1764, CSN 1156010201.
2016-11-18 00:05:19 INFO OGG-01057 Recovery completed for all targets.
Every time I've to restart the process to make it working again.
Please help me to resolve this issue.
Regards
Aneel Ahmed