Hello,
I'm just starting to work with OGG and MySQL, and I'm noticing some interesting things that change when working with Oracle Databases:
Working with the default extraction way, that is when the Mysql server is not configured in GTID mode.
2025-04-29 12:06:33 INFO OGG-05137 GTID_MODE system variable is set to 'OFF'.
All transactions will be anonymous.
Capture will use log number and offset for positioning and recovery.
The command with several open transacctions:
GGSCI (server1) 13> send extract extwest, showtrans
Sending SHOWTRANS request to Extract group EXTWEST ...
Transaction ID : 000000000000000000027:000000073759642
Transaction Timestamp : 1745931071
Transaction Log Number : 27
Transaction Log Offset : 73759642
Transaction Status : Running
Show only a general transacction, and is is quite different from an OGG with Oracle that shows information about each transaction with details.
GGSCI (server1.localdomain) 11> send extract extwest, showtrans tabular
Sending showtrans request to EXTRACT EXTWEST ...
Oldest redo log file necessary to restart Extract is:
Redo Log Sequence Number 433, RBA 3564048
XID Items Extract Redo Thread Start Time SCN Redo Seq Redo RBA Status
----------------------------------------------------------------------------------------------------------------------------------
3.1.10619 10001 EXTWEST 1 2017-01-18:21:35:39 0.21438094 (21438094) 433 3564048 Running
1.0.42744 10001 EXTWEST 1 2017-01-18:22:00:02 0.21461028 (21461028) 434 6093840 Running
I have set the server to GTID (Global Transaction ID) mode to see if it would change but this command still works the same.
Gtid mode:
GGSCI (server1) 5> info EXTWEST
Extract EXTWEST Last Started 2025-05-05 14:13 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:08 ago)
Process ID 8586
VAM Read Checkpoint 2025-05-05 14:12:26.000000
SeqId: 00000000000000000001:6923fc88-1558-11f0-83cf-000c29b3a30e:
0000000000000000002,
GtidSet: 6923fc88-1558-11f0-83cf-000c29b3a30e:1-2
GGSCI (server1) 3> send extwest showtrans
Sending SHOWTRANS request to Extract group EXTWEST ...
Transaction ID : 000000000000000000029:000000000000000
Transaction Timestamp : 1746447146
Transaction Log Number : 29
Transaction Log Offset : 0
Transaction Status : Running
I find this command very useful for viewing the volume and items (modified rows), and if it's an LRT transaction, how long it's been running, etc.
Does anyone know if this limitation is overcome in a higher version of OGG?
The version used is:
Oracle GoldenGate Command Interpreter for MySQL
Version 21.17.0.0.0 OGGCORE_21.17.0.0.0OGGRU_PLATFORMS_250125.0558
Thanks
Arturo