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: 5
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: error installing OGG12c Director: java.lang.Exception: JDBC Driver Jar not found
Next Topic: OGG chekpoint recovery
Goto Forum:
  


Current Time: Fri Mar 29 05:05:25 CDT 2024