goldengate ALO模式,抽取进程running,就是不抽取数据 - Oracle...

来自 : ITPUB 发布时间：2021-03-25

我的OGG ALO模式运行，指定日志序列号抽取，抽取进程running，一直停在这，没有生成trail文件，不抽取数据。
源库：两节点10.2.0.5RAC（AIX）
两节点的归档日志以NFS挂载至另一台linux主机，在此主机上安装oracle10.2.0.5、goldengate11.2 for 10g
GGSCI (zysc) 8 info all
Program Status Group Lag at ChkptTime Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTRM 01:26:51 00:41:27
GGSCI (zysc) 9 view param extrm
extract extrm
userid ggs@rmdb1,password ggsitsp
tranlogoptions archivedlogonly
tranlogoptions altarchivelogdest primary instance rm1 /rmdb1_arch, altarchivelogdest instance rm1 /rmdb1_arch, altarchivelogdest instance rm2 /rmdb2_arch
tranlogoptions altarchivedlogformat instance rm1 rm1_%s_%t_%r.arc
tranlogoptions altarchivedlogformat instance rm2 rm2_%s_%t_%r.arc
exttrail /data1/oggrm/app/dirdat/ra
discardfile ./dirrpt/exta.dsc,append, megabytes 500
table rm.oggrmtest;
obey ./dirprm/rmtables
GGSCI (zysc) 10 info extrm,detail
EXTRACT EXTRM Initialized 2014-06-12 17:56 Status RUNNING
Checkpoint Lag 01:26:51 (updated 00:42:40 ago)
Log Read CheckpointOracle Redo Logs
2014-06-12 16:30:00Thread 1, Seqno 60788, RBA 0
SCN 0.0 (0)
Log Read CheckpointOracle Redo Logs
2014-06-12 16:30:00Thread 2, Seqno 59502, RBA 0
SCN 0.0 (0)
Target Extract Trails:
Remote Trail Name Seqno RBA Max MB
/data1/oggrm/app/dirdat/ra 0 0 100
Extract Source Begin End
Not Available * Initialized * 2014-06-12 16:30
Not Available * Initialized * 2014-06-12 16:30
Not Available * Initialized * 2014-06-12 16:30
Current directory /data1/oggrm/app
Report file /data1/oggrm/app/dirrpt/EXTRM.rpt
Parameter file /data1/oggrm/app/dirprm/extrm.prm
Checkpoint file /data1/oggrm/app/dirchk/EXTRM.cpe
Process file /data1/oggrm/app/dirpcs/EXTRM.pce
Stdout file /data1/oggrm/app/dirout/EXTRM.out
Error log /data1/oggrm/app/ggserr.log
oggrm@zysc:[/data1/oggrm/app/dirrpt]tail -20 EXTRM.rpt
CACHESIZEMAX (strict force to disk): 96G
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.5.0 - Productio
NLSRTL Version 10.2.0.5.0 - Production
Database Language and Character Set:
NLS_LANG = AMERICAN_AMERICA.ZHS16GBK
NLS_LANGUAGE = AMERICAN
NLS_TERRITORY = AMERICA
NLS_CHARACTERSET = ZHS16GBK
2014-06-12 17:57:26WARNING OGG-01830LOGRETENTION is disabled by default in ARCHIVEDLOGONLY mode.
2014-06-12 17:57:26INFO OGG-00546Default thread stack size: 10485760.
2014-06-12 17:57:26INFO OGG-01513Positioning to (Thread 1) Sequence 60788, RBA 0, SCN 0.0.
oggrm@zysc:[/data1/oggrm/app]tail -20f ggserr.log
2014-06-12 17:56:51INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oggrm): alter extract extrm extseqno 59502 thread 2.
2014-06-12 17:57:24INFO OGG-00987Oracle GoldenGate Command Interpreter for Oracle:GGSCI command (oggrm): start extrm.
2014-06-12 17:57:24INFO OGG-00963Oracle GoldenGate Manager for Oracle, mgr.prm:Command received from GGSCI on host zysc (START EXTRACT EXTRM ).
2014-06-12 17:57:24INFO OGG-00975Oracle GoldenGate Manager for Oracle, mgr.prm:EXTRACT EXTRM starting.
2014-06-12 17:57:24INFO OGG-00992Oracle GoldenGate Capture for Oracle, extrm.prm:EXTRACT EXTRM starting.
2014-06-12 17:57:24INFO OGG-03035Oracle GoldenGate Capture for Oracle, extrm.prm:Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2014-06-12 17:57:25INFO OGG-01635Oracle GoldenGate Capture for Oracle, extrm.prm:BOUNDED RECOVERY: reset to initial or altered checkpoint.
2014-06-12 17:57:25INFO OGG-01815Oracle GoldenGate Capture for Oracle, extrm.prm:Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/data1/oggrm/app/BR/EXTRM.
2014-06-12 17:57:25INFO OGG-01815Oracle GoldenGate Capture for Oracle, extrm.prm:Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON)anon free: munmap
file alloc: mmap(MAP_SHARED)file free: munmap
target directories:
/data1/oggrm/app/dirtmp.
2014-06-12 17:57:26WARNING OGG-01830Oracle GoldenGate Capture for Oracle, extrm.prm:LOGRETENTION is disabled by default in ARCHIVEDLOGONLY mode.
2014-06-12 17:57:26INFO OGG-00546Oracle GoldenGate Capture for Oracle, extrm.prm:Default thread stack size: 10485760.
2014-06-12 17:57:26INFO OGG-01513Oracle GoldenGate Capture for Oracle, extrm.prm:Positioning to (Thread 1) Sequence 60788, RBA 0, SCN 0.0.