Initial load error: OGG-01194 - There is no trail to reposition to when doi
Hi there,
I am having trouble with starting initial load. I get error “WARNING OGG-01194 EXTRACT task ILREP_2M abended : There is no trail to reposition to when doing direct load task.”
I dont quite understand what that means, although I have the same param files as in examples in documentation. I use oracle goldengate version 11.1.
I would appreciate any help.
here is initial load scripts:
--Source database
ADD EXTRACT ilext_2m, SOURCEISTABLE
EDIT PARAMS ilext_2m
EXTRACT ilext_2m
SETENV (NLS_LANG = "AMERICAN_AMERICA.CL8MSWIN1251")
SETENV (ORACLE_HOME = "/u01/app/oracle/product/10.2.0")
SETENV (ORACLE_SID = "teod1")
USERID ggs_owner, PASSWORD ggs_owner
RMTHOST 192.168.0.2, MGRPORT 7809
RMTTASK replicat, GROUP ilrep_2m
TABLE teod.subs_history;
TABLE teod.subscriber;
--Target database
ADD REPLICAT ilrep_2m,SPECIALRUN
EDIT PARAMS ilrep_2m
--CHECKPARAMS
REPLICAT ilrep_2m
SETENV (NLS_LANG = "AMERICAN_AMERICA.CL8MSWIN1251")
SETENV (ORACLE_HOME = "/data/oracle/ora11gr2")
SETENV (ORACLE_SID = "db11gr2")
USERID ggs_owner, PASSWORD ggs_owner
BULKLOAD
ASSUMETARGETDEFS
MAP teod.subs_history, TARGET teod.subs_history;
MAP teod.subscriber, TARGET teod.subscriber;