Switch the Extract trail file on the fly. (Doc ID 1322239.1)

Last updated on JANUARY 13, 2017

Applies to:

Management Pack for Oracle GoldenGate - Version: 11.1.1.0.0 to 11.1.1.1.9 - Release: 11.1.1 to 11.1.1
Information in this document applies to any platform.
Issue the below command from the GGSCI prompt to switch trail on the fly:

GGSCI> send extract rollover

Here is the below sample:


GGSCI> info extract ext detail

EXTRACT EXT Last Started 2011-05-16 12:10 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint Oracle Redo Logs
2011-05-16 12:12:04 Seqno 71, RBA 5611520

Target Extract Trails:

Remote Trail Name Seqno RBA Max MB

./dirdat/10 3 915 10

Extract Source Begin End

D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLGG\REDO01.LOG 2011-05-16 12:07 2011-05-16 12:12
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLGG\REDO01.LOG 2011-05-16 12:07 2011-05-16 12:07
Not Available * Initialized * 2011-05-16 12:07


Current directory D:\GG10

Report file D:\GG10\dirrpt\EXT.rpt
Parameter file D:\GG10\dirprm\EXT.prm
Checkpoint file D:\GG10\dirchk\EXT.cpe
Process file D:\GG10\dirpcs\EXT.pce
Error log D:\GG10\ggserr.log

GGSCI> send extract ext rollover

GGSCI> info extract ext detail

EXTRACT EXT Last Started 2011-05-16 12:10 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint Oracle Redo Logs
2011-05-16 12:13:58 Seqno 71, RBA 5628928

Target Extract Trails:

Remote Trail Name Seqno RBA Max MB

./dirdat/10 4 915 10

Extract Source Begin End

D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLGG\REDO01.LOG 2011-05-16 12:07 2011-05-16 12:13
D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCLGG\REDO01.LOG 2011-05-16 12:07 2011-05-16 12:07
Not Available * Initialized * 2011-05-16 12:07


Current directory D:\GG10

Report file D:\GG10\dirrpt\EXT.rpt
Parameter file D:\GG10\dirprm\EXT.prm
Checkpoint file D:\GG10\dirchk\EXT.cpe
Process file D:\GG10\dirpcs\EXT.pce
Error log D:\GG10\ggserr.log

Goal

How can you switch to the next trail of the extract without restarting?

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms