RE: GoldenGate new replicat not applying

From: Walker, Jed S <Jed_Walker_at_cable.comcast.com>
Date: Thu, 12 Jul 2012 21:54:24 +0000
Message-ID: <BAA6E28B6241F046AED1E62D8697516C6F3C7B45_at_COPDCEXMB08.cable.comcast.com>

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_at_gmail.com] Sent: Thursday, July 12, 2012 3:25 PM
To: Walker, Jed S
Cc: oracle-l_at_freelists.org
Subject: Re: GoldenGate new replicat not applying

Hi,
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 trails. 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 extract->pump->replicat You can start with stats for the table(s) in question

stats extract <initial extract>
stats extract <pump>
stats extract <repl>

Troubleshoot from there...
Regards,
Guenadi Jilevski
On Thu, Jul 12, 2012 at 11:46 PM, Walker, Jed S <Jed_Walker_at_cable.comcast.com<mailto:Jed_Walker_at_cable.comcast.com>> wrote: I've got a RedHat 5.6, Oracle 11.2.0.3.0 RAC cluster. I am using Golden Gate 11.2. 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

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jul 12 2012 - 16:54:24 CDT