Item |
Source System |
Target System |
Platform |
OEL5.4 |
OEL5.4 |
Hostname |
gc1 |
oraclelinux54.cuug.net |
Database |
Oracle 10.2.0.5 |
Oracle 11.2.0.3 |
Character Set |
Zhs16gbk |
Zhs16gbk |
ORACLE_SID |
PROD |
TDB112 |
Listener Name/Port |
LISTENER/1521 |
LISTENER/1521 |
Goldengate User |
ogg |
ogg |
确保两个数据库的字符集一致,防止传输出现乱码
Install Goldengate 11g on
Linux--------------------------------------------------------------------
1.1Create install directory and unzip downloaded file on both system
For source system(gc2):
[oracle@gc1:/home/oracle]$mkdir
-p /u01/app/ogg
[oracle@gc1:/home/oracle]$cp
V18156-01-linux.zip /u01/app/ogg
[oracle@gc1:/home/oracle]$cd
/u01/app/ogg
[oracle@gc1:/u01/app/ogg]$unzip
V18156-01-linux.zip
[oracle@gc1:/u01/app/ogg]$tar
-xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar
For target
system(oraclelinux54.cuug.net):
[oracle@oraclelinux54.cuug.net:/u01]$mkdir
-p /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/home/oracle]$cp
V18156-01-linux.zip /u01/app/ogg
[oracle@oraclelinux54.cuug.net:/home/oracle]$cd
/u01/app/ogg
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$unzip
V18156-01-linux.zip
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$tar
-xvf ggs_redhatAS40_x86_ora10g_32bit_v10.4.0.19_002.tar
1.2Create sub working directories for Goldengate
For both Source system and Target
system:
[oracle@~]$ vi .bash_profile
export
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oracle@oraclelinux54.cuug.net:/home/oracle]$cd
/u01/app/ogg
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci
./ggsci: error
while loading shared libraries: libnnz10.so: cannot open shared object file:
No such file or directory
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$cd
$ORACLE_HOME/lib
[oracle@oraclelinux54.cuug.net:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$
ln -s libnnz11.so libnnz10.so //建立一个链接,让 libnnz10.so指向libnnz11.so
[oracle@oraclelinux54.cuug.net:/u01/app/oracle/product/11.2.0/dbhome_1/lib]$cd
/u01/app/ogg
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci
Oracle GoldenGate
Command Interpreter for Oracle
Version 10.4.0.19
Build 002
Linux, x86, 32bit
(optimized), Oracle 10 on Sep 17 2009 23:49:42
Copyright (C) 1995,
2009, Oracle and/or its affiliates. All
rights reserved.
GGSCI (oraclelinux54.cuug.net) 1> create subdirs //在当前路径下创建
Creating
subdirectories under current directory /u01/app/ogg
Parameter files
/u01/app/ogg/dirprm: created //参数文件
Report files /u01/app/ogg/dirrpt:
created
Checkpoint files
/u01/app/ogg/dirchk: created //检查点文件,支持断点续传,知道哪些文件被传输,哪些没有
Process status
files /u01/app/ogg/dirpcs:
created
SQL script
files /u01/app/ogg/dirsql:
created
Database
definitions files
/u01/app/ogg/dirdef: created
Extract data
files /u01/app/ogg/dirdat:
created
Temporary
files
/u01/app/ogg/dirtmp: created
Veridata files /u01/app/ogg/dirver: created
Veridata Lock
files
/u01/app/ogg/dirver/lock: created
Veridata
Out-Of-Sync files
/u01/app/ogg/dirver/oos: created
Veridata
Out-Of-Sync XML files /u01/app/ogg/dirver/oosxml: created
Veridata Parameter
files /u01/app/ogg/dirver/params:
created
Veridata Report
files
/u01/app/ogg/dirver/report: created
Veridata Status
files
/u01/app/ogg/dirver/status: created
Veridata Trace
files
/u01/app/ogg/dirver/trace: created
Stdout files /u01/app/ogg/dirout:
created
Above directories are created for following purpose:
Name |
Purpose |
dirchk |
Checkpoint files |
dirdat |
GoldenGate trails |
dirdef |
Data definition files |
dirprm |
Parameter files |
dirpcs |
Process status files |
dirrpt |
Report files |
dirsql |
SQL script files |
dirtmp |
Temporary files |
Introduction to the Command
Interface---------------------------------------------------------
View HELP summary for all
commands
GGSCI> HELP
GGSCI> HELP ALL
View HELP summary for a
COMMAND/ENTITY
GGSCI> HELP ADD EXTRACT
GGSCI> HELP ADD EXTTRAIL
View your command history
GGSCI> HISTORY
View a brief informational
summary of all processes
GGSCI> INFO ALL
Configure Oracle Database for
Goldengate------------------------------------------------------
Create Goldengate user
Create user ogg
for both source system and target system, and grant
appropriate privileges.
For Source System:
SQL> create
tablespace tbs_gguser datafile '/u01/app/oracle/oradata/EMREP/gguser.dbf' size
50M autoextend on;
SQL> create user
ogg identified by ogg default tablespace tbs_gguser temporary tablespace TEMP
quota unlimited on tbs_gguser;
SQL> col
property_value for a30
SQL> select property_name,property_value from
database_properties where property_name='DEFAULT_TEMP_TABLESPACE';
PROPERTY_NAME PROPERTY_VALUE
------------------------------
------------------------------
DEFAULT_TEMP_TABLESPACE TEMP
grant CONNECT, RESOURCE to ogg;
grant CREATE SESSION, ALTER SESSION to ogg;
grant SELECT ANY DICTIONARY, SELECT ANY TABLE to
ogg;
grant ALTER ANY TABLE to ogg;
grant FLASHBACK ANY TABLE to ogg;
grant EXECUTE on DBMS_FLASHBACK to ogg;
Insert test
table and data for Source System:
[oracle@node1 oradata]$ cd
/u01/app/ogg
[oracle@node1 ogg]$ !sql
SQL> conn
scott/tiger
SQL> @demo_ora_create
SQL>
@demo_ora_insert
SQL> select *
from tcustmer;
CUST NAME CITY ST
----
------------------------------ -------------------- --
WILL BG SOFTWARE
CO. SEATTLE WA
JANE ROCKY FLYER
INC. DENVER CO
SQL> select *
from tcustord;
CUST ORDER_DAT
PRODUCT_ ORDER_ID PRODUCT_PRICE
PRODUCT_AMOUNT TRANSACTION_ID
---- ---------
-------- ---------- ------------- -------------- --------------
WILL 30-SEP-94
CAR 144 17520 3 100
JANE 11-NOV-95
PLANE 256 133300 1 100
For Target System:
sys@TDB112>select tablespace_name from dba_tablespaces; //11g数据库临时表空间不叫temp,我们查看下
TABLESPACE_NAME
------------------------------------------------------------------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMPTS1
USERS
LXTBS1
LXTBS2
LXTBS3
LXSP
UNDO_SMALL
TOOLS
TBS_GGUSER
sys@TDB112>create
user ogg identified by ogg default tablespace tbs_gguser temporary tablespace
TEMPTS1 quota unlimited on tbs_gguser;
grant CONNECT, RESOURCE to ogg;
grant CREATE SESSION, ALTER SESSION to ogg;
grant SELECT ANY DICTIONARY, SELECT ANY TABLE to
ogg;
grant CREATE TABLE to ogg;
Create empty test table and
grant DML privilege to Goldengate user:
在目标数据库创建表,但不插入数据,即一个空表
SQL> conn scott/tiger
SQL> @demo_ora_create
SQL>
grant INSERT, UPDATE, DELETE on scott.tcustmer to ogg; // 将要同步表的DML操作授权给OGG用户
SQL>
grant INSERT, UPDATE, DELETE on scott.tcustord to ogg; //将要同步表的DML操作授权给OGG用户
Enable supplemental log mode in source system
打开补充 日志,除了redo log以外的log
Check supplemental log mode
is enabled or not by following query:
SQL> select
SUPPLEMENTAL_LOG_DATA_MIN from v$database;
SUPPLEMENTAL_LOG_DATA_MI
------------------------
NO
If not, enable it:
SQL> alter
database add supplemental log data;
SQL>
alter system switch logfile; //这步很重要,因为当前的日志是没有补充日志的,所以要马上切换下日志,从新的日志开始就有补充日志
Enable archive log mode in
source system
一定要打开归档模式,当发生延迟比较厉害的时候传输还没有传完,这时候redo 已经切换了,就需要到归档里面找
Enable
archive log mode:
[oracle@cdcjp63vm1
ogg] sqlplus / as sysdba
SQL>
alter system set log_archive_dest=' /u01/app/oracle/oradata/soraeuc/arch';
ORA-02097: parameter cannot be modified because
specified value is invalid
ORA-16019: cannot use
db_recovery_file_dest with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST 这里报错,因为log_archive_dest和DB_RECOVERY_FILE_DEST冲突进而形成死锁
解决方案,清除db_recovery_file_dest和log_archive_dest_n。
SQL> alter system set db_recovery_file_dest='';
SQL> alter system set log_archive_dest_1='';重新执行原语句即可
SQL> alter system set
log_archive_dest='/u01/app/oracle/oradata/soraeuc/arch';
System altered.
SQL> shutdown
immediate
SQL> startup
mount
SQL> alter
database archivelog;
SQL> alter
database open;
Check database
archive log information:
SQL> alter
system archive log current;
SQL> archive log list;
Database log
mode Archive Mode
Automatic
archival Enabled
Archive
destination
/u01/app/oracle/oradata/soraeuc/arch
Oldest online log
sequence 6
Next log sequence
to archive 8
Current log
sequence 8
Enable force logging mode in source
system------------------------------------------
设置了force loging 即使使用nologing 也将无效,还是会产生大量日志
Check
force logging mode is enabled or not by following query:
SQL> SELECT
force_logging FROM v$database;
FOR
---
NO
Enable force logging mode:
SQL> alter
database force logging;
Enable transaction data change capture for these two tables in Source system:
把要同步的表打开日志补充
GGSCI
(cdcjp63vm1.cn.oracle.com) 3> DBLOGIN USERID ogg, PASSWORD ogg 登入到源数据库
Successfully
logged into database.
GGSCI
(cdcjp63vm1.cn.oracle.com) 5> ADD TRANDATA scott.TCUSTMER 为要传送scott用户的TCUSTMER 表打开日志补充,使其
可以传送,在此操作前要先切换日志
Logging of
supplemental redo data enabled for table SCOTT.TCUSTMER.
GGSCI
(cdcjp63vm1.cn.oracle.com) 6> ADD TRANDATA scott.TCUSTORD 为要传送scott用户的TCUSTORD 表打开日志补充
Logging of
supplemental redo data enabled for table SCOTT.TCUSTORD.
Verify that supplemental
logging has been turned on for these tables.
GGSCI
(cdcjp63vm3.cn.oracle.com) 7> INFO TRANDATA scott.TCUST* 查看scott下TCUST开头的表设置了TRANDATA,即可以传送
Logging of
supplemental redo log data is enabled
for table SCOTT.TCUSTMER
Logging of
supplemental redo log data is enabled
for table SCOTT.TCUSTORD
GGSCI (node1)
3> INFO TRANDATA scott.*
Logging of
supplemental redo log data is disabled
for table SCOTT.BONUS.
Logging of
supplemental redo log data is disabled
for table SCOTT.DEPT.
Logging of
supplemental redo log data is disabled
for table SCOTT.EMP.
Logging of
supplemental redo log data is disabled
for table SCOTT.EMP2.
Logging of
supplemental redo log data is disabled for table SCOTT.EMP3.
Logging of
supplemental redo log data is disabled for table SCOTT.SALGRADE.
Logging of
supplemental redo log data is enabled
for table SCOTT.TCUSTMER
Logging of
supplemental redo log data is enabled
for table SCOTT.TCUSTORD
enabled 表示可以同步的表
disabled 表示不能同步的表
Configure Goldengate Manager Process
------------------------------------------------------
管理进程,系统关闭后要手动启动
Configure MGR in source system
Create the Manager parameter
file.
[oracle@gc2
ogg]$ ./ggsci ./表示当前路径下面
GGSCI
(gc2) 1> EDIT PARAMS MGR
Use the editor to
assign a port.
PORT
7809 意思是这个管理进程启动后就监听这个端口,最好用1024以上的端口,最好不要和其他的端口冲突
PURGEOLDEXTRACTS
/u01/app/ogg/dirdat, USECHECKPOINTS 要跟踪的文件放在
/u01/app/ogg/dirdat这个目录下面
Start the
Manager.
GGSCI
(gc2) 2> START MGR 启动管理进程
Verify that the
Manager has started.
GGSCI
(cdcjp63vm1.cn.oracle.com) 3> INFO MGR
Manager is
running (IP port gc2.7809).
[oracle@gc2 ogg]$ ps -ef | grep ogg
[oracle@gc2 ogg]$
ps -ef | grep ogg
oracle 3554
3539 0 17:29 ? 00:00:00 ./mgr PARAMFILE
/u01/app/ogg/dirprm/mgr.prm REPORTFILE /u01/app/ogg/dirrpt/MGR.rpt PROCESSID
MGR PORT 7809
Configure MGR in target system
Create the Manager parameter
file.
[oracle@oraclelinux54.cuug.net:/u01/app/ogg]$./ggsci
GGSCI
(oraclelinux54.cuug.net) 2> EDIT PARAMS MGR
Use the editor to assign a
port.
PORT 7809
PURGEOLDEXTRACTS /u01/app/ogg/dirdat, USECHECKPOINTS
Start
the Manager.
GGSCI (oraclelinux54.cuug.net) 3> START MGR
Verify that the Manager has
started.
GGSCI
(oraclelinux54.cuug.net) 4> INFO MGR
Manager is running
(IP port oraclelinux54.cuug.net.7809).
Load Initial Data by Direct Load
method----------------------------------------------------------------
第一次初始化加载步骤,只做一次就可以,目的是要让源数据库中的表和目标数据库中的表初始化同步,初步变成一样后就不需要在初始化了,再次初始化会出错
第一次同步源数据库和目标数据库中要同步的表,源数据中表的结构和目标数据库中表的结构要一样,可以用IMP导入表到目标数据库
Configure Extract process in source system
Add an Extract process called
EINI_1:
GGSCI
(cdcjp63vm1.cn.oracle.com) 1> ADD EXTRACT
EINI_1, SOURCEISTABLE
EXTRACT added.
Verify Extract process:
EINI_1 是为EXTRACT(提取)取的一个名字
SOURCEISTABLE 表示第一次加载不是从redo 而是直接从表中加载数据
GGSCI (gc2) 9> INFO EXTRACT *, TASKS
EXTRACT EINI_1
Initialized 2014-08-11
17:43 Status STOPPED
Checkpoint Lag Not Available
Log Read
Checkpoint Not Available
First Record Record 0
Task SOURCEISTABLE
Edit EINI_1:
GGSCI
(cdcjp63vm1.cn.oracle.com) 3> EDIT PARAMS EINI_1 编辑参数
Add:
--
GoldenGate Initial Data Capture(捕获)
-- for TCUSTMER
and TCUSTORD
--
EXTRACT EINI_1
SETENV (NLS_LANG=AMERICAN_AMERICA.WE8MSWIN1252)
USERID ogg,
PASSWORD ogg
RMTHOST oraclelinux54.cuug.net,
MGRPORT 7809
oraclelinux54.cuug.net是目标数据库的主机名,监听端口7809里的内容
RMTTASK REPLICAT,
GROUP RINI_1
任务是replicat 复制,GROUP RINI_1 表示在目标端也要配置一个 REPLICAT名字叫做RINI_1
TABLE scott.TCUSTMER; //要同步的表
TABLE scott.TCUSTORD;
For Japanese support, we
should set environment variable “NLS_LANG” in Extract/Pump/Replicat process
parameters.
Configure replicat(复制)
process in target
system
Add initial load delivery
process
GGSCI
(oraclelinux54.cuug.net) 5> ADD REPLICAT RINI_1, SPECIALRUN
SPECIALRUN:表示只为初始化运行一次,运行一次以后就不运行了,停止
REPLICAT added.
Verify result:
GGSCI
(oraclelinux54.cuug.net) 6> INFO REPLICAT *,
TASKS
REPLICAT RINI_1
Initialized 2014-08-11
05:55 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:00:36 ago)
Log Read
Checkpoint Not Available
Task SPECIALRUN
Edit initial
load delivery process RINI_1:.
GGSCI
(cdcjp63vm2.cn.oracle.com) 3> EDIT PARAMS RINI_1
Add:
-- -- REPLICAT SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK) ASSUMETARGETDEFS 意思是这是一个接收方 USERID ogg,PASSWORD DISCARDFILE ./dirrpt/RINIaa.dsc, PURGE 不要的信息放到这个目录下 MAP |
Note: In
the MAP statement, the first owner/schema is for the source and the second for
the target.
MAP
scott.*: 是源数据库的scott用户下的表
TARGET scott.*: 是目标数据库scott用户下的表,和源数据库中的用户名可以不一样
如果还有其他用户的表同时输入多个用户的表
MAP 其他用户.*, TARGET 其他用户.*;
Accomplish Initial Load
Start Initial
Load process EINI_1 in source system, then RINI_1
process in target system will be started automatically:
source system
GGSCI (gc2) 18>> START EXTRACT EINI_1 测试第一次初始化同步,启动EXTRACT进程,如果etc/hosts文件没配置会失败
注:
127.0.0.1 localhost.localdomain localhost
::1
localhost6.localdomain6 localhost6
192.168.8.47
gc2
192.168.8.48
oraclelinux54.cuug.net
Sending
START request to MANAGER ...
EXTRACT
EINI_1 starting
GGSCI (gc2)
19> VIEW
REPORT EINI_1
2014-08-11
18:31:21 GGS INFO 414
Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.
***********************************************************************
Oracle GoldenGate Capture for
Oracle
Version 10.4.0.19 Build
002
Linux, x86, 32bit (optimized), Oracle 10 on
Sep 18 2009 00:01:59
Copyright (C) 1995,
2009, Oracle and/or its affiliates. All
rights reserved.
Starting at 2014-08-11
18:31:21
***********************************************************************
Operating System
Version:
Linux
Version #1 SMP Tue
Aug 18 15:51:54 EDT 2009, Release 2.6.18-164.el5
Node: gc2
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: 3792
Description:
***********************************************************************
** Running with the following
parameters **
***********************************************************************
-- GoldenGate
Initial Data Capture
-- for EMP_OGG and
DEPT_OGG
--
EXTRACT EINI_1
SETENV
(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
Set environment
variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
USERID ogg,
PASSWORD ***
RMTHOST
oraclelinux54.cuug.net, MGRPORT 7809
RMTTASK REPLICAT,
GROUP RINI_1
TABLE
scott.TCUSTMER;
Using the following
key columns for source table SCOTT.TCUSTMER: CUST_CODE.
TABLE
scott.TCUSTORD;
Using the following
key columns for source table SCOTT.TCUSTORD: CUST_CODE, ORDER_DATE,
PRODUCT_CODE, ORDER_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.91G
CACHESIZEMAX
(strict force to disk): 2.67G
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 =
"AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET =
"ZHS16GBK"
Processing table
SCOTT.TCUSTMER
Processing table
SCOTT.TCUSTORD
***********************************************************************
* ** Run Time Statistics
** *
***********************************************************************
Report at
2014-08-11 18:31:28 (activity since 2014-08-11 18:31:21)
Output to RINI_1:
From Table
SCOTT.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table
SCOTT.TCUSTORD:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
You can also
verify the results in target system:
GGSCI
(oraclelinux54.cuug.net) 3> VIEW REPORT RINI_1
***********************************************************************
Oracle GoldenGate Delivery
for Oracle
Version 10.4.0.19 Build
002
Linux, x86, 32bit (optimized), Oracle 10 on
Sep 18 2009 00:08:30
Copyright (C) 1995,
2009, Oracle and/or its affiliates. All
rights reserved.
Starting at 2014-08-11
06:31:21
***********************************************************************
Operating System
Version:
Linux
Version #1 SMP Thu
Sep 3 02:16:47 EDT 2009, Release 2.6.18-164.el5
Node:
oraclelinux54.cuug.net
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: 18941
Description:
***********************************************************************
** Running with the following
parameters **
***********************************************************************
-- GoldenGate
Initial Load Delivery
--
REPLICAT RINI_1
SETENV
(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
Set environment
variable (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
ASSUMETARGETDEFS
USERID ogg,
PASSWORD ***
DISCARDFILE
./dirrpt/RINIaa.dsc, PURGE
MAP scott.*, TARGET
scott.*;
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 11g
Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release
11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux:
Version 11.2.0.3.0 - Production
NLSRTL Version
11.2.0.3.0 - Production
Database Language
and Character Set:
NLS_LANG =
"AMERICAN_AMERICA.ZHS16GBK"
NLS_LANGUAGE = "AMERICAN"
NLS_TERRITORY = "AMERICA"
NLS_CHARACTERSET =
"ZHS16GBK"
For further
information on character set settings, please refer to user manual.
***********************************************************************
** Run Time Messages **
***********************************************************************
Wildcard MAP
resolved (entry SCOTT.*):
MAP SCOTT.TCUSTMER, TARGET scott.TCUSTMER;
Using following
columns in default map by name:
CUST_CODE, NAME, CITY, STATE
Using the following
key columns for target table SCOTT.TCUSTMER: CUST_CODE.
Wildcard MAP
resolved (entry SCOTT.*):
MAP SCOTT.TCUSTORD, TARGET scott.TCUSTORD;
Using following
columns in default map by name:
CUST_CODE, ORDER_DATE, PRODUCT_CODE,
ORDER_ID, PRODUCT_PRICE,
PRODUCT_AMOUNT, TRANSACTION_ID
Using the following
key columns for target table SCOTT.TCUSTORD: CUST_CODE, ORDER_DATE,
PRODUCT_CODE, ORDER_ID.
***********************************************************************
* ** Run Time Statistics
** *
***********************************************************************
Report at
2014-08-11 06:31:33 (activity since 2014-08-11 06:31:27)
From Table
SCOTT.TCUSTMER to SCOTT.TCUSTMER:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
From Table
SCOTT.TCUSTORD to SCOTT.TCUSTORD:
# inserts: 2
# updates: 0
# deletes: 0
# discards: 0
Check the
initial data has been transferred to Target
system:
sys@TDB112>conn
scott/tiger
Connected.
scott@TDB112>select
* from tab;
TNAME
TABTYPE CLUSTERID
------------------------------------------------------------------------------------------
--------------------- ----------
BONUS
TABLE
DEPT
TABLE
EMP
TABLE
EMP2
TABLE
SALGRADE
TABLE
TCUSTMER
TABLE
TCUSTORD
TABLE
After initial
load, extract process EINI_1 and replicat process RINI_1 stop automatically. 自动停止和上面配置的参数 ADD REPLICAT RINI_1,
SPECIALRUN 有关
Source system:
GGSCI (gc2)
20> INFO EXTRACT EINI_1
EXTRACT EINI_1
Last Started 2014-08-11 18:31
Status STOPPED
Checkpoint Lag Not Available
Log Read
Checkpoint Table SCOTT.TCUSTORD
2014-08-11 18:31:28 Record 2
Task SOURCEISTABLE
Target System:
REPLICAT RINI_1
Initialized 2014-08-11
05:55 Status STOPPED
Checkpoint Lag 00:00:00 (updated 00:49:48 ago)
Log Read
Checkpoint Not Available
Task SPECIALRUN