Slow Replicat
edited Feb 12, 2014 10:03AM in GoldenGate, Streams and Distributed Database (MOSC) 29 commentsAnswered
I have this particular REPLICAT that's 47 hours behind, and 8 gigs of logs to apply. Any suggestions how I can speed this up, or what to check for?
GGSCI (sandbox) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING ESBICGAD 00:00:00 00:00:00
EXTRACT RUNNING ESBISDBX 00:00:00 00:00:08
EXTRACT RUNNING ESUNSTSB 00:00:00 00:00:07
EXTRACT RUNNING PSBICGAD 00:00:00 00:00:01
EXTRACT RUNNING PSBISDBX 00:00:00 00:00:04
EXTRACT RUNNING PSUNSTSB 00:00:00 00:00:01
REPLICAT RUNNING RPUNCGAD 47:02:39 00:00:00
REPLICAT RUNNING RSBICGAD 00:00:00 00:00:05
GGSCI (sandbox) 5> info replicat RPUNCGAD
REPLICAT RPUNCGAD Last Started 2014-01-16 21:26 Status RUNNING
Checkpoint Lag 46:41:17 (updated 00:00:10 ago)
Log Read Checkpoint File /cgdb/oggsb/dirdat/r1002398
2014-01-26 11:37:08.001119 RBA 455419544
GGSCI (sandbox) 6> sh ls -ltr /cgdb/oggsb/dirdat/r1*
GGSCI (sandbox) 4> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING ESBICGAD 00:00:00 00:00:00
EXTRACT RUNNING ESBISDBX 00:00:00 00:00:08
EXTRACT RUNNING ESUNSTSB 00:00:00 00:00:07
EXTRACT RUNNING PSBICGAD 00:00:00 00:00:01
EXTRACT RUNNING PSBISDBX 00:00:00 00:00:04
EXTRACT RUNNING PSUNSTSB 00:00:00 00:00:01
REPLICAT RUNNING RPUNCGAD 47:02:39 00:00:00
REPLICAT RUNNING RSBICGAD 00:00:00 00:00:05
GGSCI (sandbox) 5> info replicat RPUNCGAD
REPLICAT RPUNCGAD Last Started 2014-01-16 21:26 Status RUNNING
Checkpoint Lag 46:41:17 (updated 00:00:10 ago)
Log Read Checkpoint File /cgdb/oggsb/dirdat/r1002398
2014-01-26 11:37:08.001119 RBA 455419544
GGSCI (sandbox) 6> sh ls -ltr /cgdb/oggsb/dirdat/r1*
0