The application team observed as one of the tables out of 600 tables replication is not working.
- Observed as the table was included in the extract process to write into the trail file.
- Observed as the table was included in the pump process
- Observed as the table was included in the target replicat process
Still, there is no clue or reason, why the single table was unable to replicat but the rest of the tables working as usual. So started investigating the issue from scratch of the implementation and, at the very first step, identified that table supplemental logging was not enabled. Due to that, Golden Gate is not considered part of the replication.
GGSCI (ORA-X2 as ggadmin@PRODT) 31> info trandata SCOTT.DB_UTILISATEUR 2021-06-30 19:04:31 INFO OGG-10471 ***** Oracle Goldengate support information on table SCOTT.DB_UTILISATEUR ***** Oracle Goldengate support native capture on table SCOTT.DB_UTILISATEUR. Oracle Goldengate marked following column as key columns on table SCOTT.DB_UTILISATEUR: ID_UTILISATEUR. Logging of supplemental redo log data is disabled for table SCOTT.DB_UTILISATEUR. GGSCI (ORA-X2 as ggadmin@ PRODT) 32>
As soon as identified enabled supplemental logging for the table as below.
GGSCI (ORA-X2 as ggadmin@ PRODT) 32> add trandata SCOTT.DB_UTILISATEUR allcols 2021-06-30 19:05:34 INFO OGG-15132 Logging of supplemental redo data enabled for table SCOTT.DB_UTILISATEUR. 2021-06-30 19:05:34 INFO OGG-15133 TRANDATA for scheduling columns has been added on table SCOTT.DB_UTILISATEUR. 2021-06-30 19:05:34 INFO OGG-15134 TRANDATA for all columns has been added on table SCOTT.DB_UTILISATEUR. 2021-06-30 19:05:34 INFO OGG-15135 TRANDATA for instantiation CSN has been added on table SCOTT.DB_UTILISATEUR. 2021-06-30 19:05:34 INFO OGG-10471 ***** Oracle Goldengate support information on table SCOTT.DB_UTILISATEUR ***** Oracle Goldengate support native capture on table SCOTT.DB_UTILISATEUR. Oracle Goldengate marked following column as key columns on table SCOTT.DB_UTILISATEUR: ID_UTILISATEUR. GGSCI (ORA-X2 as ggadmin@ PRODT) 33>
Verify the supplemental logging status for the table.
GGSCI (ORA-X2 as ggadmin@ PRODT) 102> info trandata SCOTT.DB_UTILISATEUR 2021-06-30 19:04:15 INFO OGG-10471 ***** Oracle Goldengate support information on table SCOTT.DB_UTILISATEUR ***** Oracle Goldengate support native capture on table SCOTT.DB_UTILISATEUR. Oracle Goldengate marked following column as key columns on table SCOTT.DB_UTILISATEUR: ID_UTILISATEUR. Logging of supplemental redo log data is enabled for table SCOTT.DB_UTILISATEUR. All columns supplementally logged for table SCOTT.DB_UTILISATEUR. Prepared CSN for table SCOTT.DB_UTILISATEUR: 172862113315 GGSCI (ORA-X2 as ggadmin@ PRODT) 103>
After this step, we should again export from the source and import into the table and start the replication to consider this table part of the replication.
Tip: Make an action plan for any table that will be added in the future so that no step can be missed.
