RE: GoldenGate new replicat not applying

  • From: "Walker, Jed S" <Jed_Walker@xxxxxxxxxxxxxxxxx>
  • To: Guenadi Jilevski <gjilevski@xxxxxxxxx>
  • Date: Thu, 12 Jul 2012 21:54:24 +0000

I know they do because I've had them setup before with the same param files and 
same commands to add. Last time I setup this system from scratch I did them all 
right after creating the extracts and pumps. This time it has been a couple 
days before I go to the last set. I did notice in the checkpoint table it shows 
this one with sequence and RBA of 0.
Let me try the stats commands and see what I find.

From: Guenadi Jilevski [mailto:gjilevski@xxxxxxxxx]
Sent: Thursday, July 12, 2012 3:25 PM
To: Walker, Jed S
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: GoldenGate new replicat not applying

Make sure that for those new replicats
1. specify proper trail file
2. have proper mappings
3. param files
4. etc...
Seems that those replicates that you suggest not working cannot locate data in 
I would suggest stats on extracts and trace it to replicats in order to see how 
a particular table updates/inserts/deletes get processed from the 
You can start with stats for the table(s) in question
stats extract <initial extract>
stats extract <pump>
stats extract <repl>
Troubleshoot from there...
Guenadi Jilevski
On Thu, Jul 12, 2012 at 11:46 PM, Walker, Jed S 
<Jed_Walker@xxxxxxxxxxxxxxxxx<mailto:Jed_Walker@xxxxxxxxxxxxxxxxx>> wrote:
I've got a RedHat 5.6, Oracle RAC cluster. I am using Golden Gate 
I have two extracts that each handle six schemas. With those two pumps that 
send to a second RAC (same versions). (These are very simple, just schema.* and 
sequences, nothing fancy).

I configured 6 of twelve of the schemas with replicats on the second node on 
Tuesday this week with no problems. Now when I try to configure the rest 
several days later the new replicats don't show any errors but the data is not 
being applied (the ones I had already setup are running and I can see data is 
applying). I'm very new to Golden Gate and am hoping I'm not just missing 
something obvious, but could sure use some help.

I have checked status and it says "at EOF" but running.

Any ideas would be appreciated.

- Jed



Other related posts: