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!

restart initial-load

Matthew WatsonJan 12 2012 — edited Jan 15 2012
Hi,

I'm currently doing a migration proof of concept from DB2 -> Oracle, using golden gate to move the data between the systems. We have some quite large tables ( up to a billion rows ) and restarting an extract on these tables is quite painful if it fails part way through for some reason.

Is there any way to restart an extract/replicat where it failed?

my extract is

extract ALT4
SOURCEDB RUMBARPT, USERID XXXXXXXX, PASSWORD XXXXXXXXX
RMTHOST target-host, MGRPORT 7809
RMTTASK REPLICAT, GROUP ALT4
TABLE FOO.BAR;


the replicat is

REPLICAT ALT4
USERID XXXXXXXX, PASSWORD XXXXXXXXX
SOURCEDEFS /opt/ggs/dirdef/sources.def
MAP FOO.BAR, TARGET FOO.BAR;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 12 2012
Added on Jan 12 2012
5 comments
948 views