Ogg_oracle GoldenGate Checkpoint checkpoint (case)

2014-12-24 Created by Abalone new

I. Summary

Second, modify

BEGIN {now | yyyy-mm-dd[:hh:mi:[ss[.cccccc]] | EOF | Seqno <sequence Number>}


--Modify the start extraction point of the extraction process: (i.e.: Myext read checkpoint)

Alter extract Myext BEGIN YYYY-MM-DD:HH:MI:SS

Alter extract Myext BEGIN now







--Modify Myext's write Checkpoint:

ALTER EXTRACT Myext, Etrollover





--Modify the read checkpoint for the transfer MYDP process


ALTER EXTRACT MYDP, extseqno 1234, Extrba 0




--Modify the write checkpoint for the transfer MYDP process

Alter extract MYDP Etrollover





--Modify the reading checkpoint for Myrep

ALTER replicat Myrep, extseqno 1234, Extrba 0

Ogg_oracle GoldenGate Checkpoint checkpoint (case)