源端：
mgr:
PORT 7500
dynamicportlist 7501-7505
autorestart extract *,waitminutes 2,retries 5
eora:
extract eora
dynamicresolution
userid ggs,password ggs
setenv(ORACLE_SID=orcl)
exttrail .\dirdat\et
table scott.demo;
eora總是stopped狀態
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT STOPPED EORA 00:00:00 01:26:45
uj5u.com熱心網友回復：
補：GGSCI (WIN-F8UGD1L5F3C as ggs@orcl) 85> view report eora
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401
Windows x64 (optimized), Oracle 11g on Dec 11 2015 18:46:50
Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.
Starting at 2017-04-19 10:47:14
***********************************************************************
Operating System Version:
Microsoft Windows Server 2008 R2 , on x64
Version 6.1 (Build 7601: Service Pack 1)
Process id: 5780
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2017-04-19 10:47:14 INFO OGG-03059 Operating system character set identifie
d as GBK.
2017-04-19 10:47:14 INFO OGG-02695 ANSI SQL parameter syntax is used for pa
rameter parsing.
2017-04-19 10:47:14 INFO OGG-02095 Successfully set environment variable OR
ACLE_SID=orcl.
2017-04-19 10:47:14 WARNING OGG-10173 (EORA.prm) line 2: Parsing error, [dynam
icresolution] is deprecated.
extract eora
dynamicresolution
userid ggs,password ***
2017-04-19 10:47:15 INFO OGG-03522 Setting session time zone to source data
base time zone 'GMT'.
setenv(ORACLE_SID=orcl)
2017-04-19 10:47:15 INFO OGG-02095 Successfully set environment variable OR
ACLE_SID=orcl.
exttrail .\dirdat\et
table scott.demo;
2017-04-19 10:47:15 INFO OGG-01635 BOUNDED RECOVERY: reset to initial or al
tered checkpoint.
2017-04-19 10:47:15 INFO OGG-01815 Virtual Memory Facilities for: BR
anon alloc: MapViewOfFile anon free: UnmapViewOfFile
file alloc: MapViewOfFile file free: UnmapViewOfFile
target directories:
C:\gg\BR\EORA.
Bounded Recovery Parameter:
BRINTERVAL = 4HOURS
BRDIR = C:\gg
uj5u.com熱心網友回復：
不懂 gg，樓主可以考慮去itpub發貼子問問，那邊的運維人員比較多。轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/97813.html
標籤：高級技術
上一篇：貸款賬戶類的表怎么設計合適