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 gg_own@gg_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.