Home » Server Options » Replication » adding checkpoint table (10g,Solaris)
adding checkpoint table [message #641889] Wed, 26 August 2015 18:26 Go to next message
eswararaodba@gmail.com
Messages: 3
Registered: July 2015
Junior Member
Hi Team,

We created replicate process with nodbcheckpoint Option by using below command.

ADD REPLICAT REP1234, EXTTRAIL /opt/app/prod/ggs/ab, begin now, nodbcheckpoint

Now I am looking to add check point table for above replicate with below command. However I facing error.

step 1:

GGSCI > add checkpointtable ggsuser.CHKPT_REP1234

Successfully created checkpoint table ggsuser.CHKPT_REP1234.

Step 2:

GGSCI > ALTER REPLICAT REP1234, NONINTEGRATED, CHECKPOINTTABLE ggsuser.CHKPT_ REP1234
ERROR: Invalid parameter specified for ALTER REPLICAT.

Can you please help me here to add check point table without drop and recreate of replicate process and it won't be any impact for data loss.

Thanks
Eswar
Re: adding checkpoint table [message #645917 is a reply to message #641889] Wed, 16 December 2015 05:07 Go to previous message
ssumesh
Messages: 4
Registered: May 2015
Location: delhi
Junior Member
hi

the correct sequence for adding chkpt table to your rep should be.

create new chkpt table. (you have already created)
stop replicat
info replicat detail (note down current trail LOGSEQNO and EXTRBA
delete replicat
ADD REPLICAT REP1234, EXTTRAIL <trail_name>, BEGIN EXTSEQNO <seq_no> EXRBA <rba>, CHECKPOINTTABLE owner.table
start replicat

Previous Topic: OGG-01921 Oracle GoldenGate Delivery for Oracle, rep1.prm: Missing GETBEFORECOLS with conflict det
Next Topic: GG extract process running slow and lag is in increasing mode.
Goto Forum:
  


Current Time: Mon Nov 20 20:46:05 CST 2017

Total time taken to generate the page: 0.02017 seconds