Forum Stats

  • 3,758,235 Users
  • 2,251,358 Discussions
  • 7,870,123 Comments

Discussions

Primary Extract abends with "OGG-10461 Failed to retrieve tombstone timestamp value for table" erro

User_4VEYT
User_4VEYT Member Posts: 2 Green Ribbon
edited Jul 9, 2020 1:28PM in GoldenGate

I am using integrated Extract and replicat in ACTIVE-ACTIVE env. Components added as follow on host site:

GGSCI> REGISTER EXTRACT ggextrm1 DATABASE

GGSCI> ADD EXTRACT ggextrm1, INTEGRATED TRANLOG, BEGIN NOW

GGSCI> ADD EXTTRAIL /u01/ogg/GoldenGate/dirdat/e1, EXTRACT GGEXTRM1

GGSCI> ADD EXTRACT ggpumpm1, EXTTRAILSOURCE /u01/ogg/GoldenGate/dirdat/e1, BEGIN NOW

GGSCI> ADD RMTTRAIL /u01/ogg/GoldenGate/dirdat/m1, EXTRACT ggpumpm1

GGSCI> ADD REPLICAT ggrepm1, INTEGRATED EXTTRAIL /u01/ogg/GoldenGate/dirdat/d1, BEGIN NOW

Extract param:

$cat dirprm/ggextrm1.prm

EXTRACT ggextrm1

SETENV (ORACLE_SID="dbprod1")

SETENV (ORACLE_HOME='/u01/app/oracle/product/19.3.0/dbhome_1')

USERID [email protected]_own.agnity.com, PASSWORD gg_own

TRANLOGOPTIONS EXCLUDEUSER gg_own

GETTRUNCATES

DISCARDFILE /u01/ogg/GoldenGate/dirrpt/ggextrm1.dsc, PURGE

DISCARDROLLOVER AT 00:01 ON SUNDAY

EXTTRAIL /u01/ogg/GoldenGate/dirdat/e1

DDL INCLUDE MAPPED

LOGALLSUPCOLS

GETUPDATEBEFORES

STATOPTIONS RESETREPORTSTATS, REPORTFETCH

REPORTCOUNT EVERY 30 MINUTES, RATE

REPORTROLLOVER AT 00:01 ON SUNDAY

ROLLOVER AT 00:00

WARNLONGTRANS 4H, CHECKINTERVAL 4H

TABLE sps50.*, GETBEFORECOLS(ON UPDATE ALL, ON DELETE ALL);

Earlier, I had configiured autoCDR also for all tables. But now disabled it still getting this error for Primary extract:

Source Context :

  SourceModule            : [er.redo.oraxo]

  SourceID                : [er/redo/oracle/redooraix.c]

  SourceMethod            : [formatLCRInternal]

  SourceLine              : [16239]

  ThreadBacktrace         : [10] elements

                          : [/u01/ogg/GoldenGate/libgglog.so(CMessageContext::AddThreadContext())]

                          : [/u01/ogg/GoldenGate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*

, unsigned int, ...))]

                          : [/u01/ogg/GoldenGate/libgglog.so(_MSG_String(CSourceContext*, int, char const*,

CMessageFactory::MessageDisposition))]

                          : [/u01/ogg/GoldenGate/extract()]

                          : [/u01/ogg/GoldenGate/extract(ProducerContext::readLCR(bool&, bool&))]

                          : [/u01/ogg/GoldenGate/extract(IXFormatter::readLCR())]

                          : [/u01/ogg/GoldenGate/extract(IXFormatter::FormatterThread(void*))]

                          : [/u01/ogg/GoldenGate/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs:

:gglib::MultiThreading::Thread::ThreadArgs*))]

                          : [/lib64/libpthread.so.0()]

                          : [/lib64/libc.so.6(clone)]

2020-07-08 10:49:56  ERROR   OGG-10461  Failed to retrieve tombstone timestamp value for table "SPS50.ACCOU

NT".

As per the posts available related with this error, it is observed with Oracle GG 12.3 version and is fixed in 19.1. But I am using 19.1 version only. Still facing this issue.

Answers

  • Sreesha Nair-Oracle
    Sreesha Nair-Oracle Member Posts: 77 Employee
    edited Jul 8, 2020 11:28PM

    Hi,

    What is your DB version. Please check if you need to patch at DB level.

    There are some DB level bugs as well which could result in " OGG-10461  Failed to retrieve tombstone timestamp value"

    Extract Abend With ERROR OGG-10461 Failed To Retrieve Tombstone Timestamp Value For Table (Doc ID 2461553.1)

  • User_4VEYT
    User_4VEYT Member Posts: 2 Green Ribbon
    edited Jul 9, 2020 12:11AM

    My DB version is 19.3.0 and following patches are applied:

    $/u01/app/oracle/product/19.3.0/dbhome_1/OPatch/opatch lspatches

    30557433;Database Release Update : 19.6.0.0.200114 (30557433)

    30489227;OCW RELEASE UPDATE 19.6.0.0.0 (30489227)

  • ORASCN
    ORASCN Member Posts: 1,816 Gold Trophy
    edited Jul 9, 2020 1:28PM

    Hi ,

    The document and Bug is for a classic replicat,

    Integrated Replicat should work. There shouldn't be any issues. May I know your compatible parameter set in the database?

    Regards,

    Veera

  • aoflima44
    aoflima44 Member Posts: 107 Blue Ribbon

    I am running into the same issue with parallel integrated. DB version is 19.9