Today on one of my Goldengate server i want to see the transaction statistics for a particular table on source side and when I queried below using ggsci stats command I see “Fully qualified table name MYCUSTOMER.CUST_CLEAR_HIST is not found in the Oracle GoldenGate configuration“ in the output
Reason:
Yes this is NOT an issue and it is expected when there are no transactions performed on this table ever since on source side then the output prints this message.
According to (Doc ID 1941158.1), If no transaction log records for the specific table have been read and processed by the extract process, the internal mapping table has not been built.
myproddemo:custdb1:/
Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
GGSCI (myproddemo) 1> stats ECUSTDBP totalsonly MYCUSTOMER.CUST_CLR_HIST
Sending STATS request to EXTRACT ECUSTDBP ...
Start of Statistics at 2018-03-30 10:19:28.
DDL replication statistics (for all trails):
*** Total statistics since extract started ***
Operations
Output to /goldengate/home/dirdat/SRC/
Cumulative totals for specified table(s):
*** Total statistics since 2018-03-05 06:47:25 ***
No database operations have been performed.
*** Daily statistics since 2018-03-30 00:00:00 ***
No database operations have been performed.
*** Hourly statistics since 2018-03-30 10:00:00 ***
No database operations have been performed.
*** Latest statistics since 2018-03-05 06:47:25 ***
No database operations have been performed.
Fully qualified table name MYCUSTOMER.CUST_CLR_HIST is not found in the Oracle GoldenGate configuration.
End of Statistics.
1 comments:
It was an excellent Blog to see from you which is very useful. Thank you so much for gathering all this information about Oracle Goldengate, it’s very clever and will be extremely helpful for all people.
Post a Comment