GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Issue extract reposition SCN or timestamp

edited May 8, 2019 5:24PM in GoldenGate, Streams and Distributed Database (MOSC) 4 commentsAnswered ✓

Hi Gurus,

I'm not able to re-position my primary extract even though while adding extract i specified the timestamp as shown below . When i see the trailfile using logdump i see changes from today not from the position timestamp(BEGIN 2019-05-06 14:39:00.000000.) .

2019-05-07T15:36:59.223-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): info all.

2019-05-07T15:37:05.060-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): ADD EXTRACT EODRMNPR  INTEGRATED TRANLOG, BEGIN 2019-05-06 14:39:00.000000.

2019-05-07T15:37:09.820-0400  INFO    OGG-00987  Oracle GoldenGate Command Interpreter for Oracle:  GGSCI command (oracle): ADD EXTTRAIL /acfsadm/oggdat/rm  EXTRACT EODRMNPR, MEGABYTES 200.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center