I have GG working fine with processing updates from source to target. However, I am getting a strange error when trying to do an initial load. I have the extract file from the source and I've set the parameter file to pick it up. I've also added the replicat with ADD REPLICAT rlcosmos, SPECIALRUN, EXTFILE dirdat\ld000000
. When I try to run using START myreplicat
I get and error of "OGG-02419 Missing checkpoint file name". My understanding was that checkpoints were not needed for SPECIALRUN, so I'm a bit confused as to the error, since I can see that the checkpoint file is there. Any ideas?
***[EDIT]***, I tried modifying the configuration file (as PRM FILE2 below) and running as a normal replicat, ADD REPLICAT rlcosmos, EXTFILE dirdat\ld000000
. The process works that way.
REPLICAT DETAIL
GGSCI (xdaz002092) 52> INFO REPLICAT rlcosmos, DETAIL
REPLICAT RLCOSMOS Initialized 2020-07-19 15:12 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:50:23 ago)
Log Read Checkpoint File dirdat\ld000000
First Record RBA 0
Extract Source Begin End
dirdat\ld000000 * Initialized * First Record
Current directory C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1
Report file C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\dirrpt\RLCOSMOS.rpt
Parameter file C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\dirprm\RLCOSMOS.prm
Checkpoint file C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\dirchk\RLCOSMOS.cpr
Checkpoint table
Process file
Error log C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\ggserr.log
LOG FILE:
***********************************************************************
Oracle GoldenGate for Big Data
Version 19.1.0.0.1 (Build 003)
Oracle GoldenGate Delivery
Version 19.1.0.0.2 OGGCORE_OGGADP.19.1.0.0.2_PLATFORMS_190916.0039
Windows x64 (optimized), Generic on Sep 16 2019 05:33:49
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
Starting at 2020-07-19 14:52:55
***********************************************************************
Operating System Version:
Microsoft Windows 10, on x64
Version 10.0 (Build 19041)
Process id: 30828
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2020-07-19 14:52:55 INFO OGG-03059 Operating system character set identified as windows-1252.
2020-07-19 14:52:55 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2020-07-19 14:52:55 INFO OGG-01360 REPLICAT is running in Special Run mode.
Source Context :
SourceModule : [ggapp.checkpt]
SourceID : [../gglib/ggapp/checkpt.c]
SourceMethod : [chkpt_context_t::openCheckpointFile]
SourceLine : [699]
ThreadBacktrace : [14] elements
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\gglog.dll(??1CContextItem@@UEAA@XZ)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\gglog.dll(?CreateMessage@CMessageFactory@@QEAAPEAVCMessage@@PEAVCSourceContext@@IZZ)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\gglog.dll(?_MSG_@@YAPEAVCMessage@@PEAVCSourceContext@@HW4MessageDisposition@CMessageFactory@@@Z)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(ERCALLBACK)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(ERCALLBACK)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(ERCALLBACK)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(ERCALLBACK)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(_ggTryDebugHook)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(_ggTryDebugHook)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(_ggTryDebugHook)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(ERCALLBACK)]
: [C:\oracle\product\19\OGG_BigData_Windows_x64_19.1.0.0.1\replicat.exe(CommonLexerNewSSD)]
: [C:\WINDOWS\System32\KERNEL32.DLL(BaseThreadInitThunk)]
: [C:\WINDOWS\SYSTEM32\ntdll.dll(RtlUserThreadStart)]
2020-07-19 14:52:55 ERROR OGG-02419 Missing checkpoint file name.
2020-07-19 14:52:55 ERROR OGG-01668 PROCESS ABENDING.
PRM FILE:
SPECIALRUN
DISCARDFILE dirrpt\rlcosmos.dsc, purge
ASSUMETARGETDEFS
TARGETDB LIBFILE ggjava.dll SET property=dirprm\cosmos.props
MAP MYPDB.HR.*, TARGET MYPDB.HR.*;
TABLEEXCLUDE MYPDB.HR.EMP_DETAILS_VIEW;
END RUNTIME
PRM FILE2:
--SPECIALRUN
REPLICAT rlcosmos
DISCARDFILE dirrpt\rlcosmos.dsc, purge
ASSUMETARGETDEFS
TARGETDB LIBFILE ggjava.dll SET property=dirprm\cosmos.props
MAP MYPDB.HR.*, TARGET MYPDB.HR.*;
TABLEEXCLUDE MYPDB.HR.EMP_DETAILS_VIEW;
--END RUNTIME
2条答案
按热度按时间fd3cxomn1#
从命令行而不是从GGSCI启动Replicat。当您使用GGSCI启动Replicat时,它会认为您正在运行非初始加载Replicat,因此检查点文件丢失。
replicat.sh 参数文件路径/到/文件.prm报告文件可选输出文件
或replicat.exe(适用于Windows)。
c3frrgcw2#
Old post - but posting for other encountering this...
The following worked for me also from GGSCI - When adding the Replicat, be sure to specify the Checkpoint Table details. For example:
GGSCI> ADD REPLICAT rep_1, EXTTRAIL .\dirdat\d2, CHECKPOINTTABLE ggs_admin.ggschkpt
Notes:
Good luck!