hi các bác em cái Oracle GoldenGate Version 10.4.0.46 Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
OS Redhat 4u7. dũ liệu nó chưa đồng bộ. em post một số thông số mong các cao thủ chỉ bảo
source
- Code: Select all
info manager
Manager is running (IP port Master1.7809).
info extract e_gt
EXTRACT E_GT Last Started 2010-05-20 15:24 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:06 ago)
Log Read Checkpoint Oracle Redo Logs
2010-05-20 16:42:17 Seqno 11, RBA 327680
GGSCI (Master1) 10> view report e_gt
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 10.4.0.46 Build 003
Linux, x86, 32bit (optimized), Oracle 9 on Feb 26 2010 13:38:31
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2010-05-20 15:24:55
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Jul 9 15:39:47 EDT 2008, Release 2.6.9-78.ELsmp
Node: Master1
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: 6302
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
-- Specify extract group
EXTRACT e_gt
-- Used to login db
USERID gg_src, PASSWORD ********
-- Specify extract trail file
EXTTRAIL /u01/oracle/ggs/dirdat/gt
-- Specify tables to extract
TABLE gg_src.gg_test;
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.93G
CACHESIZEMAX (strict force to disk): 2.68G
Database Version:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.VN8VN3"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "VN8VN3"
2010-05-20 15:24:56 GGS INFO 112 Recovery initialization completed for target file /u01/oracle/ggs/dirdat/gt000000, at RBA 1435.
2010-05-20 15:24:56 GGS INFO Z0-05M Output file /u01/oracle/ggs/dirdat/gt is using format RELEASE 10.4.
2010-05-20 15:24:56 GGS INFO 224 Rolling over remote file /u01/oracle/ggs/dirdat/gt000000.
2010-05-20 15:24:56 GGS INFO 112 Recovery completed for target file /u01/oracle/ggs/dirdat/gt000001, at RBA 964.
2010-05-20 15:24:56 GGS INFO 112 Recovery completed for all targets.
***********************************************************************
** Run Time Messages **
***********************************************************************
TABLE resolved (entry GG_SRC.GG_TEST):
TABLE GG_SRC.GG_TEST;
Using the following key columns for source table GG_SRC.GG_TEST: ID.
ở con target
- Code: Select all
info manager
Manager is running (IP port Master2.7809)
info REPLICAT r_gt
REPLICAT R_GT Last Started 2010-05-20 14:48 Status RUNNING
Checkpoint Lag 00:00:00 (updated 00:00:01 ago)
Log Read Checkpoint File /u01/oracle/ggs/dirdat/gt000000
2010-05-20 14:40:36.000000 RBA 0
view report r_gt
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 10.4.0.46 Build 003
Linux, x86, 32bit (optimized), Oracle 9 on Feb 26 2010 13:39:49
Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.
Starting at 2010-05-20 14:48:22
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Jul 9 15:39:47 EDT 2008, Release 2.6.9-78.ELsmp
Node: Master2
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: 6070
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
REPLICAT r_gt
-- Target table has identical structure as source
ASSUMETARGETDEFS
USERID gg_tgt, PASSWORD ********
-- Map tables
MAP gg_src.gg_test, TARGET gg_tgt.gg_test;
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:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Linux: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
Database Language and Character Set:
NLS_LANG = "AMERICAN_AMERICA.VN8VN3"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET = "VN8VN3"
For further information on character set settings, please refer to user manual.
***********************************************************************
** Run Time Messages **
***********************************************************************
cần post các thông số ghì các bác cứ bảo
Thu May 20, 2010 4:53 pm
Site map
SitemapIndex
RSS Feed