Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Starting OGG replication

Jitender RanaJan 19 2018 — edited Jan 23 2018

Hello! Gururs,

I have to redirect my OGG Replication from prod  to DG database. Right now primary db is being replicated from prod and i have to reverse the roles of primary to standby and standby to primary and direct my replication to DG (become primapry). How do I take cut off point for strating replication to DG db. I do have checkpointtable on primary db and I am using coordinated replicats. what should be my starting point for replication after the role switch. I have though of few options and one of them is using LOG_CMPLT_CSN of checkpointtable on existing primary db as the starting point, but the problem is that each thread might have diff CSN, which one should I take min or max. any other suggestions. Thanks!

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 20 2018
Added on Jan 19 2018
10 comments
275 views