First, error checking
[Oracle@srtcreen ~]$ Ggsci
Oracle Goldengate Command Interpreter for Oracle
Version 11.1.1.1.1 oggcore_11.1.1.1.1_platforms_110729.1700
Linux, x64, 64bit (optimized), Oracle 10g on June 29 2011 19:43:29
Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.
Ggsci (srtcreen) 1> info All
Program Status Group Lag time Since chkpt
MANAGER RUNNING
Replicat RUNNING r_1 00:00:00 00:00:07
Replicat RUNNING r_2 00:00:00 00:00:05
Replicat abended r_3 19:19:34 00:17:33
Replicat STOPPED r_4 00:00:00 19:44:24
Replicat STOPPED r_5 00:00:00 19:44:13
Ggsci (srtcreen) 2> View r_3
***********************************************************************
Oracle Goldengate Delivery for Oracle
Version 11.1.1.1.1 oggcore_11.1.1.1.1_platforms_110729.1700
Linux, x64, 64bit (optimized), Oracle 10g on Sep 13 2011 21:33:03
Copyright (C) 1995, Oracle and/or its affiliates. All rights reserved.
Starting at 2011-12-02 16:36:58
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Fri Apr 2 14:58:14 EDT, release 2.6.18-194.el5
Node:srtcreen
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:13398
Description:
***********************************************************************
* * Running with the following parameters * *
***********************************************************************
Replicat r_3
Assumetargetdefs
Handlecollisions
Setenv (Nls_lang =american_america. ZHS16GBK)
Set environment variable (nls_lang=american_america. ZHS16GBK)
UserID It1ogg, Password ********
--file for dicarded transaction--
Discardfile/opt/ogg/discard/r_3.txt, append, megabytes 100
Ddl
MAP cscnew. Tab_cs_call_pickup, TARGET Srt_creen. Tab_cs_call_pickup, Keycols (call_id);
Cachemgr virtual memory values (may have been adjusted)
cachebuffersize:64k
cachesize:512m
Cachebuffersize (Soft max): 4M
Cachepageoutsize (normal): 4M
PROCESS VM Avail from OS (min): 1G
Cachesizemax (strict force to disk): 881M
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 Linux:version 10.2.0.4.0-production
Nlsrtl Version 10.2.0.4.0-production
Database Language and Character Set:
Nls_lang = "American_america." ZHS16GBK "
Nls_language = "American"
Nls_territory = "AMERICA"
Nls_characterset = "ZHS16GBK"
For further information in character set settings, please refer to user manual.
***********************************************************************
* * Run Time Messages * *
***********************************************************************
Opened Trail file/opt/ogg/dirdat/u3000000 at 2011-12-02 16:36:58
MAP Resolved (Entry cscnew. Tab_cs_call_pickup):
MAP cscnew. Tab_cs_call_pickup, TARGET Srt_creen. Tab_cs_call_pickup, Keycols (call_id);
More Wonderful content: http://www.bianceng.cn/database/Oracle/