extract eora01
userid gate01, password ******
rmthost 192.168.1.20, mgrport 7809
rmttask replicat, group rora01
table gate01.*;
TABLEWildcard resolved (entry GATE01.*):
table GATE01.TCUSTMER;
Using the following key columns for source table GATE01.TCUSTMER: CUST_CODE.
TABLEWildcard resolved (entry GATE01.*):
table GATE01.TCUSTORD;
Using the following key columns for source table GATE01.TCUSTORD: CUST_CODE, ORDER_DATE, PRODUCT_CODE, O
RDER_ID.
CACHEMGR virtual memory values (may have been adjusted)
CACHEBUFFERSIZE: 64K
CACHESIZE: 2G
CACHEBUFFERSIZE (soft max): 4M
CACHEPAGEOUTSIZE (normal): 4M
PROCESS VM AVAIL FROM OS (min): 2.89G
CACHESIZEMAX (strict force to disk): 2.65G
Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.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 = \
NLS_TERRITORY = \
NLS_CHARACTERSET = \
Warning: your NLS_LANG setting does not match database server language setting.
Please refer to user manual for more information.
Processing table GATE01.TCUSTMER
Processing table GATE01.TCUSTORD
***********************************************************************
* ** Run Time Statistics ** *
***********************************************************************
Report at 2011-02-22 21:13:10 (activity since 2011-02-22 21:12:57)
Output to rora01:
From Table GATE01.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table GATE01.TCUSTORD:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
GGSCI (source) 7>
VIEW REPORT RORA01(在目标数据上查看是否有报错)
GGSCI (target) 11> VIEW REPORT RORA01
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.1.1.0.0 Build 078
Linux, x86, 32bit (optimized), Oracle 10 on Jul 28 2010 16:38:15
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-02-22 21:13:27
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Jul 25 14:41:56 EDT 2008, Release 2.6.9-78.0.0.0.1.ELsmp
Node: target
Machine: i686
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 28268
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
REPLICAT Rora01
ASSUMETARGETDEFS
USERID gate02, PASSWORD \
DISCARDFILE ./dirrpt/Rora01.dsc, PURGE
MAP gate01.*, TARGET gate02.*;
CACHEMGR virtual memory values (may have been adjusted)