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 RMTTRAILparameter.
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:
No comments:
Post a Comment