ogg环境上的extract抽取进程启动了运行一段时间停止,再次启动启动不了报错
OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint
重新配置抽取进程
delete extract eora
delete exttrail D:/ogg/dirdat/et
add extract eora, tranlog, begin now
add exttrail D:/ogg/dirdat/et, ext eora, MEGABYTES 200
也解决不了问题
最后关闭BR解决
错误信息如下
2017-03-16 17:34:05 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.
2017-03-16 17:34:05 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
D:\ogg\BR\EORA.
Bounded Recovery Parameter:
Options = BROFF
BRINTERVAL = 4HOURS
BRDIR = D:\ogg
2017-03-16 17:34:05 INFO OGG-01851 filecaching started: thread ID: 97652304.
2017-03-16 17:34:05 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
D:\ogg\dirtmp.
参考如下:
ERROR OGG-01814 File Utility Error: Mkstemp: File: : Permission Denied (error: 13) (文档 ID 1965165.1)
In this Document
Symptoms
Changes
Cause
Solution
APPLIES TO:
Oracle GoldenGate - Version 11.2.1.0.19 and later
Information in this document applies to any platform.
2014-12-12 11:40:56 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or altered checkpoint.
Source Context :
SourceModule : [ggstd.vmfacilities]
SourceID : [/scratch/aime1/adestore/views/aime1_staxj04/oggcore/OpenSys/src/gglib/ggstd/vmfacilites.cpp]
SourceFunction : [ggs::gglib::ggstd::VMFacilities::m_construct(const char **, void *(*)(int, void *), const char *, void *(*)(int, void *), const char *, void *(*)(void *, void *), const char *, void *(*)(void *, void *), const char *, void *(*)(void *), void *, int, const char *, int *)]
SourceLine : [1053]
2014-12-12 11:40:56 ERROR OGG-01814 file utility error: mkstemp: file: : Permission denied (error: 13).
SYMPTOMS
Extract is abending with ERROR OGG-01814 file utility error: mkstemp: file: : Permission denied (error: 13)
CHANGES
Below issue is reported during the restart of Extract after applying patch.
CAUSE
doesn't have enough permissions for below sub-directory OGG_HOME/BR folder
Customer is implementing BR and the directory doesn't have enough permissions to do so.
SOLUTION
ORACLE user does not have a write permission on $GG_HOME/BR/<Extract_Name> directory prompting the issue. Please give the write permissions to the user running manager to fix the issue.
or
Alternatively, you can turn off the BR.
BR BROFF <---- In the extract parameter file