- 最后登录
- 2015-3-16
- 在线时间
- 28 小时
- 威望
- 0
- 金钱
- 490
- 注册时间
- 2013-10-18
- 阅读权限
- 10
- 帖子
- 26
- 精华
- 0
- 积分
- 0
- UID
- 1322
|
1#
发表于 2014-7-16 10:26:51
|
查看: 4310 |
回复: 1
DB Version :10.20.0.4
OGG Version: 11.2.1.0.1
描述:同步为RAC-单机。
之前一切运行正常,在15号凌晨4点过,rep进程突然absent。源端extract,pump正常。未对链路配置做任何修改。
REPORT:
GGSCI (p770a) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
REPLICAT RUNNING R_CDLD21 00:00:00 00:00:05
REPLICAT ABENDED R_CDLD22 62:39:40 03:51:06
REPLICAT RUNNING R_CDLD23 08:19:10 00:00:14
GGSCI (p770a) 2> view report r_cdld22
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230
AIX 5L, ppc, 64bit (optimized), Oracle 10.2 on Apr 23 2012 08:13:30
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-07-15 15:57:19
***********************************************************************
Operating System Version:
AIX
Version 6, Release 1
Node: p770a
Machine: 00F671634C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 9962432
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2014-07-15 15:57:19 INFO OGG-03035 Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
REPLICAT r_cdld22
SETENV (NLS_LANG=AMERICAN_CHINA.ZHS16GBK)
Set environment variable (NLS_LANG=AMERICAN_CHINA.ZHS16GBK)
userid ggmgr, password ******
obey ./direnv/db.oby
SETENV (ORACLE_SID = "ylogg")
Set environment variable (ORACLE_SID=ylogg)
SOURCEDEFS ./dirdef/cdld2.def
2014-07-15 15:57:20 WARNING OGG-01187 Duplicate entry encountered for CDSI2.KB12K3, Reloading definition.
2014-07-15 15:57:20 WARNING OGG-01187 Duplicate entry encountered for CDSI2.KB30K3, Reloading definition.
2014-07-15 15:57:20 WARNING OGG-01187 Duplicate entry encountered for CDSI2.KB40K4, Reloading definition.
HANDLECOLLISIONS
CHECKPOINTSECS 30
GROUPTRANSOPS 20000
MAXTRANSOPS 30000
REPERROR DEFAULT, ABEND
DISCARDROLLOVER AT 05:30 ON friday
REPORTCOUNT EVERY 10000 RECORDS, RATE
WILDCARDRESOLVE DYNAMIC
ALLOWDUPTARGETMAP
ASSUMETARGETDEFS
--list the tables
MAP CDSI2.AC01, TARGET CDYLJK.AC01, COLMAP (USEDEFAULTS);
MAP CDSI2.AC01A2, TARGET CDYLJK.AC01A2;
MAP CDSI2.AC02, TARGET CDYLJK.AC02, COLMAP (USEDEFAULTS);
MAP CDSI2.AC02K2, TARGET CDYLJK.AC02K2, COLMAP (USEDEFAULTS);
MAP CDSI2.AC05, TARGET CDYLJK.AC05;
MAP CDSI2.KC03, TARGET CDYLJK.KC03;
MAP CDSI2.KC03K1, TARGET CDYLJK.KC03K1;
MAP CDSI2.KC03K3, TARGET CDYLJK.KC03K3;
MAP CDSI2.KC04, TARGET CDYLJK.KC04;
MAP CDSI2.KC05, TARGET CDYLJK.KC05;
MAP CDSI2.KC08, TARGET CDYLJK.KC08;
MAP CDSI2.KC82, TARGET CDYLJK.KC82;
MAP CDSI2.KC82K1, TARGET CDYLJK.KC82K1;
MAP CDSI2.KC82K3, TARGET CDYLJK.KC82K3;
MAP CDSI2.LC01, TARGET CDYLJK.LC01;
MAP CDSI2.LC03L1, TARGET CDYLJK.LC03L1;
MAP CDSI2.LC05, TARGET CDYLJK.LC05;
MAP CDSI2.LC07, TARGET CDYLJK.LC07;
MAP CDSI2.LC20, TARGET CDYLJK.LC20;
MAP CDSI2.LC24K1, TARGET CDYLJK.LC24K1;
MAP CDSI2.LC28, TARGET CDYLJK.LC28;
MAP CDSI2.LC32K1, TARGET CDYLJK.LC32K1;
MAP CDSI2.LC50K1, TARGET CDYLJK.LC50K1;
MAP CDSI2.MC01, TARGET CDYLJK.MC01;
MAP CDSI2.MC02, TARGET CDYLJK.MC02;
MAP CDSI2.MC05, TARGET CDYLJK.MC05;
MAP CDSI2.MC07, TARGET CDYLJK.MC07;
MAP CDSI2.MC08, TARGET CDYLJK.MC08;
MAP CDSI2.KC42, TARGET CDYLJK.KC42;
MAP CDSI2.KC43, TARGET CDYLJK.KC43;
MAP CDSI2.KC45, TARGET CDYLJK.KC45;
MAP CDSI2.KC60, TARGET CDYLJK.KC60;
MAP CDSI2.KC61, TARGET CDYLJK.KC61;
MAP CDSI2.KC62K1, TARGET CDYLJK.KC62K1;
2014-07-15 15:57:20 INFO OGG-01815 Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
CACHEMGR virtual memory values (may have been adjusted)
CACHESIZE: 2G
CACHEPAGEOUTSIZE (normal): 8M
PROCESS VM AVAIL FROM OS (min): 4G
CACHESIZEMAX (strict force to disk): 3.41G
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_CHINA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "ZHS16GBK"
GGSERR(一次start 进程时,ggserr.log里的记录)
2014-07-15 10:38:42 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start R_CDLD22.
2014-07-15 10:38:42 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host p770a (START REPLICAT R_CDLD22 ).
2014-07-15 10:38:42 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT R_CDLD22 starting.
2014-07-15 10:38:42 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, r_cdld22.prm: REPLICAT R_CDLD22 starting.
2014-07-15 10:38:42 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, r_cdld22.prm: Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
2014-07-15 10:38:43 WARNING OGG-01187 Oracle GoldenGate Delivery for Oracle, r_cdld22.prm: Duplicate entry encountered for CDSI2.KB12K3, Reloading definition.
2014-07-15 10:38:43 WARNING OGG-01187 Oracle GoldenGate Delivery for Oracle, r_cdld22.prm: Duplicate entry encountered for CDSI2.KB30K3, Reloading definition.
2014-07-15 10:38:43 WARNING OGG-01187 Oracle GoldenGate Delivery for Oracle, r_cdld22.prm: Duplicate entry encountered for CDSI2.KB40K4, Reloading definition.
2014-07-15 10:38:43 INFO OGG-01815 Oracle GoldenGate Delivery for Oracle, r_cdld22.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/ogg/dirtmp.
接着看进程r_cdld22状态,依然absent。启动过程中,ogg未记录为什从start命令后——>absent的原因。 |
|