|
PLICAT RINIKK Initialized 2014-09-03 23:21 Status STOPPED
Checkpoint Lag 00:00:00 (updated 12:04:39 ago)
Log Read Checkpoint Not Available
Task SPECIALRUN
GGSCI 〉edit params rinikk ---配置进程信息
-- This is replicate parameter file
REPLICAT RINIKK
ASSUMETARGETDEFS
USERID system, PASSWORD oracle
DISCARDFILE ./dirrpt/RINIKK.dsc, PURGE
MAP ggs.*, TARGET ggs.*;
20、查看两个节点的mgr是否启动,并启动源端的extract进程
GGSCI (source) 18> info mgr
Manager is running (IP port source.7809).
GGSCI (source) 16> start extract einikk
Sending START request to MANAGER ...
EXTRACT EINIKK starting
21、查看源端extrace进程详细信息
GGSCI (source) 38> view report einikk
2014-09-04 14:06:13 INFO OGG-01017 Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 11.1.1.0.0 Build 078
Linux, x64, 64bit (optimized), Oracle 11 on Jul 28 2010 14:58:37
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-09-04 14:06:13
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
Node: source
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 3803
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
EXTRACT EINIKK
USERID system , PASSWORD "******"
RMTHOST 192.168.7.21 , MGRPORT 7809
RMTTASK REPLICAT , GROUP RINIKK
TABLE ggs.TCUSTMER;
Using the following key columns for source table GGS.TCUSTMER: CUST_CODE.
TABLE ggs.TCUSTORD;
Using the following key columns for source table GGS.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, ORDER_ID.
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 8G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 16G
CACHESIZEMAX (strict force to disk): 13.99G
Database Version:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG environment variable specified has invalid format, default value will be used.
NLS_LANG environment variable not set, using default value AMERICAN_AMERICA.US7ASCII.
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "AL32UTF8"
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
Processing table GGS.TCUSTMER
Processing table GGS.TCUSTORD
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2014-09-04 14:06:21 (activity since 2014-09-04 14:06:13)
Output to RINIKK:
From Table GGS.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table GGS.TCUSTORD: |