Today when doing Initial load my
extract got ABENDED with the error below
2014-10-14
19:46:37 ERROR OGG-00049
Trails cannot be used when
SOURCEISTABLE/SOURCEISFILE is specified.
2014-10-14
19:46:37 ERROR OGG-01668
PROCESS ABENDING.
GGSCI (oracledev01.com)
1> view params initEXT
EXTRACT initEXT
SETENV(ORACLE_HOME="/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV(ORACLE_SID=orcl)
sourceistable
USERID
ggs_admin,PASSWORD xxxxx
RMTHOST oracleqa01,
mgrport 7809
RMTTRAIL /u01/dev/oracle/input/ggs/remote/cb/DEV_ORCL.dat,
purge
TABLE DEV.TAB1;
TABLE DEV.TAB2;
Since here i'm sending the ".dat" files to the target server for the reporting purpose i'm not using Datapump and Replicat process, just sending files directly from my extract process (datapump process is always OPTIONAL)
SOURCEISTABLE: extracts the records from the source tables
directly.
RMTFILE: Specifies the location and file name of the
extract file that will be written during the load.
SOLUTION: Remove the EXTTRAIL or RMTTRAIL
parameter.
When I replaced RMTTRAIL with RMTFILE, then my issue got resolved.
RMTFILE /u01/dev/oracle/input/ggs/remote/cb/DEV_ORCL.dat,
purge
GGSCI (oracledev01.domain.com) 3> start
initEXT
Sending START request to MANAGER ...
EXTRACT INITEXT starting
GGSCI (oracledev01.domain.com) 4>
info initEXT
EXTRACT INITEXT
Initialized
2014-10-14 17:40 Status RUNNING
Checkpoint Lag Not
Available
Log Read Checkpoint Not
Available
First
Record Record 0
Task SOURCEISTABLE
Reference:
0 comments:
Post a Comment