OGG数据仓库以及单向复制（一）-阿里云开发者社区

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

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

------------------------

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

---

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 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:

-- GoldenGate Initial Load Delivery

REPLICAT RINI_1

SETENV (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

ASSUMETARGETDEFS 意思是这是一个接收方

USERID ogg,PASSWORD ogg

DISCARDFILE ./dirrpt/RINIaa.dsc, PURGE 不要的信息放到这个目录下

MAP scott.*, TARGET scott.*;

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

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

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

本文转自 dbapower 51CTO博客，原文链接：http://blog.51cto.com/suifu/1539820，如需转载请自行联系原作者

OGG数据仓库以及单向复制（一）

热门文章

最新文章

相关课程

相关电子书

热门

活动广场

任务中心

开发者评测

高校计划

乘风者计划

训练营

阿里云MVP

话题

直播

下载

镜像站

技术资料

插件

OGG数据仓库以及单向复制（一）

热门文章

最新文章

相关课程

相关电子书