Please note: Be careful to modify read checkpoints and write checkpoints for each process of Oracle GoldenGate (OGG). Make sure you have mastered the specific meanings of read checkpoints and write checkpoints for each process in Ogg.
BEGIN {now | yyyy-mm-dd[:hh:mi:[ss[.cccccc]] | EOF | Seqno <sequence number>}--Modify the starting extraction point of the extraction process: (i.e.: Myext read checkpoint) alter extract MYEXT begin Yyyy-mm-dd:hh:mi:ssalter Extract Myext BEGIN Now--Modify Myext's write checkpoint: ALTER EXTRACT Myext, Etrollover
--Modify the read checkpoint of the transfer MYDP process alter EXTRACT MYDP, extseqno 1234, Extrba 0
--Modify the write checkpoint of the transfer MYDP process alter extract MYDP Etrollover
--Modify MYREP reading checkpoint alter Replicat Myrep, extseqno 1234, Extrba 0
Modify read checkpoints and write checkpoints for each process of Oracle GoldenGate (OGG)