IBM IIDR V for oracle demo

1、CDC概述

2、测试环境概述

3、数据库日志模式开启

4、创建安装IDR软件用户

5、安装ACCESSSERVER软件

6、安装CDC软件

7、创建CDC用户及表空间

8、启动ACCESSSERVER并创建管理用户

9、配置CDC实例

10、启动CDC实例

11、安装IIDR_ManagementConsole

12、源端数据库创建示例OE

13、目标端创建OE用户

14、登录控制台,创建数据库

15、创建预订,同步数据表

1、CDC概述

InfoSphere Data Replication近乎实时地在异构数据存储之间复制信息。它提供可保持信息完整性的复制,以支持数据库迁移、应用程序整合、仓储、主数据管理、业务分析和数据质量流程。

InfoSphere Data Replication功能特性:

更加快捷的数据复制

交付确保事务完整性的可扩展低延迟复制。

提供双主机(active-active)数据库数据复制功能和高可用性。

提供IBM DB2®数据定义语言(DDL)(如创建和删除表、改变数据类型和添加列)的自动化复制。

提供冲突检测和解决,以支持对多个数据库所做的数据变更。

通过在目标系统中连续交付变更数据来减少批处理窗口。

集中式易于使用的平台

提供一个GUI,帮助更快地部署数据集成流程。

支持零下载数据库迁移和应用程序升级。

提供完整的监控功能,以提高复制环境的运行状况和性能的可视性。

支持灵活实施,以实现单向、双向、多到一和一到多的数据交付。

异构数据支持

支持多种异构源和目标数据库,包括DB2 for Linux、UNIX和Windows。

与IBM InfoSphere DataStage®集成,提供变更数据订阅源,进而抽取、变换和装入(ETL)流程。

将数据事务打包到XML文档或限定的格式,与IBM WebSphere® MQ之类的消息传递中间件一起使用,从而支持面向服务架构(SOA)。

与IBM InfoSphere Data Replication for DB2 for z/OS®结合使用,与IBM DB2 for z/OS相互复制异构数据。

关键组件:

Access Server-控制所有以非命令行方式对复制环境进行的访问。当您登录到Management Console时,就是连接到Access Server。您可以在客户机工作站上关闭Access Server,而不会影响源服务器与目标服务器之间正在进行的数据复制活动。

管理API-以基于Java的可选编程接口形式运行。您可以使用此API对操作配置或交互进行脚本编制。

应用代理程序-充当目标上的代理程序,用于处理源所发送的更改。

命令行界面-允许您独立于Management Console来管理数据存储器和用户帐户,以及执行管理脚本编制。

通信层(TCP/IP)-充当源与目标之间的专用网络连接。

源和目标数据存储器-表示数据复制所需的数据文件和CDC Replication实例。每个数据存储器都表示您要连接到的数据库,并且充当表的容器。被设为可供复制的表包含在数据存储器中。

Management Console-允许您配置、监视和管理各种服务器上的复制,指定复制参数以及从客户机工作站启动刷新和镜像操作。另外,Management Console还允许您监视复制操作、等待时间、事件消息以及源或目标数据存储器所支持的其他统计信息。Management Console中的监视器旨在用于需要持续分析数据移动的时间关键型工作环境。在设置复制之后,您可以在客户机工作站上关闭Management Console,而不会影响源服务器与目标服务器之间正在进行的数据复制活动。

元数据-表示相关表、映射、预订、通知、事件以及您设置的数据复制实例的其他细节的相关信息。

镜像-将更改复制到目标表或者积累源表更改并在以后将其复制到目标表。如果在环境中实施了双向复制,那么可以在源表与目标表之间来回进行镜像。

刷新-将表从源数据库初始同步到目标。这会由刷新阅读器进行读取。

复制引擎-用于发送和接收数据。用于发送所复制数据的进程是源捕获引擎,而用于接收所复制数据的进程是目标引擎。CDC Replication实例可以同时作为源捕获引擎和目标引擎运行。

单次提取-充当仅用于源的日志阅读器和日志解析器组件。它会检查并分析所选数据存储器上所有预订的源数据库日志。

源变换引擎-处理行过滤、关键列、列过滤、编码转换以及要传播到目标数据存储器引擎的其他数据。

源数据库日志-由源数据库维护以用于其自身的恢复。CDC Replication日志阅读器会在镜像过程中检查这些日志,并过滤掉不在复制范围内的表。

目标变换引擎-处理数据和值转换、编码转换、用户出口、冲突检测以及目标数据存储器引擎上的其他数据。

有两种仅用于目标的复制目的地(并不是数据库):

JMS消息-充当JMS消息目标(队列或主题),用于创建为XML文档的行级别操作。

InfoSphere DataStage-处理从CDC Replication传递的更改,这些更改可由InfoSphere DataStage作业使用。

2、测试环境概述

3、数据库日志模式开启

ORACLE数据库开启归档,归档路径不指的情况下,默认放在闪回空间,请确认闪回空间大小或开启归档之前指定好归档路径

SQL>shutdown immediate;

SQL>alter database archivelog;

SQL>alter database open;

ORACLE数据库开启最小补充日志

SQL> alter database addsupplemental log data ;

Database altered.

SQL> SELECTsupplemental_log_data_min FROM v$database;

SUPPLEME

--------

YES

SQL> selectsupplemental_log_data_min min from v$database ;

MIN

--------

YES

4、创建安装IDR软件用户

在192.168.100.100创建安装用户

groupadd cdc

useradd -g cdc -G oinstall,dba cdc1

passwd cdc1

在192.168.100.101创建安装用户

groupadd cdc

useradd -g cdc -G oinstall,dba cdc2

passwd cdc2

5、安装ACCESSSERVER软件

上传ACCESSSERVER软件及CDC_ORACLE软件到两台主机的/tmp目录下

[root@db1tmp]# ls -l

total 12

drwxr-xr-x 2 root root 4096 Nov 29 14:26IIDR_AccessServer

drwxr-xr-x 2 root root 4096 Nov 29 14:26IIDR_Oracle

drwx------.2 oracle oinstall 4096 Nov 27 12:25 pulse-ykGa2TZ84DLW

在192.168.100.101上创建软件安装目录

[root@db2 ~]# mkdir -p/opt/accessserver

[root@db2 ~]# chown -R cdc2:cdc/opt/accessserver/

[root@db2 ~]# cd /opt/

[root@db2 opt]# ls -l

total 28

drwxrwxrwx 12 cdc2 cdc 4096 Nov 29 14:35 accessserver

drwx------ 2 root root 16384 Nov 29 13:26 lost+found

drwxr-xr-x. 3 root root 4096 Nov 27 12:21 ORCLfmap

drwxr-xr-x. 2 root root 4096 May 17 2013 rh

切换到cdc2用户,在192.168.100.101上安装accessserver

[root@db2 ~]# cd/tmp/IIDR_AccessServer/

[root@db2 IIDR_AccessServer]# chmod+x iidraccess-11.3.3-4288-linux-x86-setup.bin

[root@db2 IIDR_AccessServer]# su -cdc2

[cdc2@db2 ~]$ cd/tmp/IIDR_AccessServer/

[cdc2@db2 IIDR_AccessServer]$ ls

iidraccess-11.3.3-4288-linux-x86-setup.bin InfoSphere_Data_Replication_Release_Notes_11_3_3.html

[cdc2@db2 IIDR_AccessServer]$./iidraccess-11.3.3-4288-linux-x86-setup.bin

Preparing to install...

Extracting the JRE from the installerarchive...

Unpacking the JRE...

Extracting the installation resourcesfrom the installer archive...

Configuring the installer for thissystem's environment...

Launching installer...

===============================================================================

Choose Locale...

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

1- Deutsch

->2- English

3- Español

4- Italiano

5- Português (Brasil)

CHOOSE LOCALE BY NUMBER:

===============================================================================

IBM InfoSphere Data ReplicationAccess Server (created withInstallAnywhere)

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

Preparing CONSOLE ModeInstallation...

===============================================================================

Introduction

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

InstallAnywhere will guide youthrough the installation of IBM InfoSphere Data

Replication Access Server.

It is strongly recommended that youquit all programs before continuing with

this installation.

Respond to each prompt to proceed tothe next step in the installation. Ifyou

want to change something on aprevious step, type 'back'.

You may cancel this installation atany time by typing 'quit'.

PRESS TO CONTINUE:

===============================================================================

International Program License Agreement

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, CLICKING ON AN

"ACCEPT" BUTTON, OR OTHERWISE USING THE PROGRAM, LICENSEEAGREES TO

THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON

BEHALF OF LICENSEE, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL

AUTHORITY TO BIND LICENSEE TO THESE TERMS. IF YOU DO NOT AGREE TO

THESE TERMS,

* DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, CLICK ON AN "ACCEPT"BUTTON,

OR USE THE PROGRAM; AND

* PROMPTLY RETURN THE UNUSED MEDIA, DOCUMENTATION, AND PROOF OF

ENTITLEMENT TO THE PARTY FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE

AMOUNT PAID. IF THE PROGRAM WAS DOWNLOADED, DESTROY ALL COPIES OF THE

PROGRAM.

Press Enter to continue viewing thelicense agreement, or enter "1" to

accept the agreement, "2" to decline it, "3" toprint it, or "99" to go back

to the previous screen.: 1

===============================================================================

Enter the TCP/IP port for AccessServer.

Port Number: (DEFAULT: 10101):

===============================================================================

Choose Install Folder

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

Where would you like to install?

Default Install Folder: /opt/IBM/InfoSphereDataReplication/AccessServer

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT

: /opt/accessserver

INSTALL FOLDER IS: /opt/accessserver

IS THIS CORRECT? (Y/N): y

===============================================================================

Configure User Data Folder

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

Access Server requires a folder tostore logs, configuration information and

user data. Specify a folder wherethis information should be stored.

Where would you like your user datafolder?

Default User Data Folder:/opt/accessserver

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT:

===============================================================================

Pre-Installation Summary

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

Please Review the Following BeforeContinuing:

Product Name:

IBM InfoSphere Data Replication Access Server

Install Folder:

/opt/accessserver

Link Folder:

/home/cdc2

User Data Folder:

/opt/accessserver

Disk Space Information (forInstallation Target):

Required: 288,069,645 Bytes

Available: 501,388,230,656 Bytes

PRESS TO CONTINUE:

===============================================================================

Installing...

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

[==================|==================|==================|==================]

[------------------|------------------|------------------|------------------]

===============================================================================

Installation Complete

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

Congratulations. IBM InfoSphere DataReplication Access Server has been

successfully installed to:

/opt/accessserver

Before you connect to this AccessServer installation, you must start Access

Server and create the administrationuser account. See the installation guide

for more information. You should alsoinstall the equivalent version of IBM

InfoSphere Data ReplicationManagement Console, if you haven't already done so,

before connecting to Access Server.

PRESS TO EXIT THEINSTALLER:

6、安装CDC软件

192.168.100.100上创建安装目录

[root@db1 opt]# mkdir -p /opt/cdc

[root@db1 opt]# chown cdc1:cdc/opt/cdc/

[root@db1 opt]# ls -l

total 28

drwxr-xr-x 2 cdc1 cdc 4096 Nov 29 14:41 cdc

drwx------ 2 root root 16384 Nov 29 13:26 lost+found

drwxr-xr-x. 3 root root 4096 Nov 27 12:21 ORCLfmap

drwxr-xr-x. 2 root root 4096 May 17 2013 rh

192.168.100.101上创建安装目录

[root@db2 opt]# mkdir -p /opt/cdc

[root@db2 opt]# chown cdc2:cdc/opt/cdc/

[root@db2 opt]# ls -l

total 32

drwxrwxrwx 12 cdc2 cdc 4096 Nov 29 14:35 accessserver

drwxr-xr-x 2 cdc2 cdc 4096 Nov 29 14:40 cdc

drwx------ 2 root root 16384 Nov 29 13:26 lost+found

drwxr-xr-x. 3 root root 4096 Nov 27 12:21 ORCLfmap

drwxr-xr-x. 2 root root 4096 May 17 2013 rh

开始在192.168.100.100上安装CDC

[root@db1 opt]# cd /tmp/IIDR_Oracle/

[root@db1 IIDR_Oracle]# chmod +xsetup-iidr-linux-x86-oracleredo.bin

[root@db1 IIDR_Oracle]# ls -l

total 190528

-rw-r--r-- 1 root root 19540 Nov 29 14:26

InfoSphere_Data_Replication_Release_Notes_11_3_3.html

[root@db1 IIDR_Oracle]# su - cdc1

[cdc1@db1 ~]$ cd /tmp/IIDR_Oracle/

[cdc1@db1 IIDR_Oracle]$./setup-iidr-linux-x86-oracleredo.bin

Preparing to install...

Extracting the JRE from the installerarchive...

Unpacking the JRE...

Extracting the installation resourcesfrom the installer archive...

Configuring the installer for thissystem's environment...

Launching installer...

===============================================================================

Choose Locale...

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

1- Deutsch

->2- English

3- Español

4- Italiano

5- Português (Brasil)

CHOOSE LOCALE BY NUMBER:

===============================================================================

Installer (created with InstallAnywhere)

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

Preparing CONSOLE ModeInstallation...

===============================================================================

Introduction

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

InstallAnywhere will guide youthrough the installation of IBM InfoSphere Data

Replication (Oracle) 11.3.3

Respond to each prompt to proceed tothe next step in the installation. Ifyou

want to change something on aprevious step, type 'back'.

You may cancel this installation atany time by typing 'quit'.

PRESS TO CONTINUE:

===============================================================================

International Program License Agreement

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, CLICKING ON AN

"ACCEPT" BUTTON, OR OTHERWISE USING THE PROGRAM, LICENSEEAGREES TO

THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON

BEHALF OF LICENSEE, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL

AUTHORITY TO BIND LICENSEE TO THESE TERMS. IF YOU DO NOT AGREE TO

THESE TERMS,

* DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, CLICK ON AN "ACCEPT"BUTTON,

OR USE THE PROGRAM; AND

* PROMPTLY RETURN THE UNUSED MEDIA, DOCUMENTATION, AND PROOF OF

ENTITLEMENT TO THE PARTY FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE

AMOUNT PAID. IF THE PROGRAM WAS DOWNLOADED, DESTROY ALL COPIES OF THE

PROGRAM.

Press Enter to continue viewing thelicense agreement, or enter "1" to

accept the agreement, "2" to decline it, "3" toprint it, or "99" to go back

to the previous screen.: 1

===============================================================================

Choose Install Folder

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

Where would you like to install?

Default Install Folder:/opt/IBM/InfoSphereDataReplication/ReplicationEngineforOracle

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT

: /opt/cdc

INSTALL FOLDER IS: /opt/cdc

IS THIS CORRECT? (Y/N): y

===============================================================================

Choose Instance Folder

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

Where would you like your instancesand product logs created?

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT

Instance Folder: (DEFAULT: /opt/cdc):

===============================================================================

Pre-Installation Summary

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

Please Review the Following BeforeContinuing:

Product Name:

IBM InfoSphere Data Replication (Oracle)

Install Folder:

/opt/cdc

Instance Folder:

"/opt/cdc"

Disk Space Information (forInstallation Target):

Required: 306,430,251 Bytes

Available: 501,388,234,752 Bytes

PRESS TO CONTINUE:

===============================================================================

Installing...

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

[==================|==================|==================|==================]

[------------------|------------------|------------------|------------------]

===============================================================================

Install Complete

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

Congratulations. IBM InfoSphere DataReplication (Oracle) has been successfully

installed to:

/opt/cdc

You can launch the Configuration Toolat any time by running

/opt/cdc/bin/dmconfigurets

Launch Configuration Tool? (1=Yes,2=No) (DEFAULT: 1): 2

开始在192.168.100.101上安装CDC

[root@db2 opt]# cd /tmp/IIDR_Oracle/

[root@db2 IIDR_Oracle]# chmod +xsetup-iidr-linux-x86-oracleredo.bin

[root@db2 IIDR_Oracle]# su - cdc2

[cdc2@db2 ~]$ cd /tmp/IIDR_Oracle/

[cdc2@db2 IIDR_Oracle]$./setup-iidr-linux-x86-oracleredo.bin

Preparing to install...

Extracting the JRE from the installerarchive...

Unpacking the JRE...

Extracting the installation resourcesfrom the installer archive...

Configuring the installer for thissystem's environment...

Launching installer...

===============================================================================

Choose Locale...

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

1- Deutsch

->2- English

3- Español

4- Italiano

5- Português (Brasil)

CHOOSE LOCALE BY NUMBER:

===============================================================================

Installer (created with InstallAnywhere)

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

Preparing CONSOLE ModeInstallation...

===============================================================================

Introduction

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

InstallAnywhere will guide youthrough the installation of IBM InfoSphere Data

Replication (Oracle) 11.3.3

Respond to each prompt to proceed tothe next step in the installation. Ifyou

want to change something on aprevious step, type 'back'.

You may cancel this installation atany time by typing 'quit'.

PRESS TO CONTINUE:

===============================================================================

International Program License Agreement

Part 1 - General Terms

BY DOWNLOADING, INSTALLING, COPYING, ACCESSING, CLICKING ON AN

"ACCEPT" BUTTON, OR OTHERWISE USING THE PROGRAM, LICENSEEAGREES TO

THE TERMS OF THIS AGREEMENT. IF YOU ARE ACCEPTING THESE TERMS ON

BEHALF OF LICENSEE, YOU REPRESENT AND WARRANT THAT YOU HAVE FULL

AUTHORITY TO BIND LICENSEE TO THESE TERMS. IF YOU DO NOT AGREE TO

THESE TERMS,

* DO NOT DOWNLOAD, INSTALL, COPY, ACCESS, CLICK ON AN "ACCEPT"BUTTON,

OR USE THE PROGRAM; AND

* PROMPTLY RETURN THE UNUSEDMEDIA, DOCUMENTATION, AND PROOF OF

ENTITLEMENT TO THE PARTY FROM WHOM IT WAS OBTAINED FOR A REFUND OF THE

AMOUNT PAID. IF THE PROGRAM WAS DOWNLOADED, DESTROY ALL COPIES OF THE

PROGRAM.

Press Enter to continue viewing thelicense agreement, or enter "1" to

accept the agreement, "2" to decline it, "3" toprint it, or "99" to go back

to the previous screen.: 1

===============================================================================

Choose Install Folder

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

Where would you like to install?

Default Install Folder:/opt/IBM/InfoSphereDataReplication/ReplicationEngineforOracle

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT

: /opt/cdc

INSTALL FOLDER IS: /opt/cdc

IS THIS CORRECT? (Y/N): y

===============================================================================

Choose Instance Folder

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

Where would you like your instancesand product logs created?

ENTER AN ABSOLUTE PATH, OR PRESS TO ACCEPT THE DEFAULT

Instance Folder: (DEFAULT: /opt/cdc):

===============================================================================

Pre-Installation Summary

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

Please Review the Following Before Continuing:

Product Name:

IBM InfoSphere Data Replication (Oracle)

Install Folder:

/opt/cdc

Instance Folder:

"/opt/cdc"

Disk Space Information (forInstallation Target):

Required: 306,430,251 Bytes

Available: 501,102,718,976 Bytes

PRESS TO CONTINUE:

===============================================================================

Installing...

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

[==================|==================|==================|==================]

[------------------|------------------|------------------|------------------]

===============================================================================

Install Complete

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

Congratulations. IBM InfoSphere DataReplication (Oracle) has been successfully

installed to:

/opt/cdc

You can launch the Configuration Toolat any time by running

/opt/cdc/bin/dmconfigurets

Launch Configuration Tool? (1=Yes,2=No) (DEFAULT: 1): 2

7、创建CDC用户及表空间

创建CDC用户使用的表空间

create tablespace cdc datafile'/u01/app/oracle/oradata/orcl/cdc.dbf' size 1G autoextend on;

参照/opt/cdc/samples/目录下的createuser-ora-nodba.sql脚本创建CDC用户

-- create user

CREATE user cdc identified by cdc123

default tablespace cdc temporarytablespace temp;

-- Grant basic roles

grant connect to cdc;

grant resource to cdc;

grant select_catalog_role to cdc;

-- Table DDL permissions

grant create any table to cdc;

grant alter any table to cdc;

grant drop any table to cdc;

grant lock any table to cdc;

-- Table DML permissions

grant select any table to cdc;

grant flashback any table to cdc;

grant insert any table to cdc;

grant update any table to cdc;

grant delete any table to cdc;

-- Index and view DDL permissions

grant create any index to cdc;

grant alter any index to cdc;

grant drop any index to cdc;

grant create any view to cdc;

grant drop any view to cdc;

-- Trigger DDL and DML permissions(only required for CDC Trigger-based)

grant create any trigger to cdc;

grant alter any trigger to cdc;

grant drop any trigger to cdc;

-- Sequence DDL and DML permissions (onlyrequired for CDC Trigger-based)

grant create any sequence to cdc;

grant select any sequence to cdc;

-- Procedure permissions

grant create any procedure to cdc;

grant execute any procedure to cdc;

-- Permission to perform select onthe v_$ tables

grant select any dictionary to cdc;

-- General system views

grant select on sys.v_$database tocdc;

grant select on sys.v_$controlfile tocdc;

grant select on sys.v_$version tocdc;

grant select onsys.nls_database_parameters to cdc;

-- Archive and redo logs

grant select on sys.v_$log to cdc;

grant select on sys.v_$logfile tocdc;

grant select on sys.v_$archived_logto cdc;

grant select on sys.v_$log_history tocdc;

-- Sessions and transactions

grant alter session to cdc;

grant select on sys.v_$session tocdc;

grant select on sys.gv_$session tocdc;

grant select on sys.v_$transaction tocdc;

grant select on sys.v_$mystat to cdc;

-- Tables, indexes, columns andrelated views

grant select on sys.all_coll_types tocdc;

grant select on sys.all_type_attrs tocdc;

grant select on sys.dba_tables tocdc;

grant select on sys.dba_tab_commentsto cdc;

grant select on sys.dba_tab_columnsto cdc;

grant select on sys.dba_col_commentsto cdc;

grant select on sys.dba_indexes tocdc;

grant select on sys.dba_ind_columnsto cdc;

grant select on sys.all_constraintsto cdc;

grant select on sys.dba_constraintsto cdc;

grant select on sys.all_cons_columnsto cdc;

grant select on sys.dba_cons_columnsto cdc;

grant select on sys.tab$ to cdc;

grant select on sys.ind$ to cdc;

grant select on sys.lob$ to cdc;

grant select on sys.col$ to cdc;

grant select on sys.icol$ to cdc;

grant select on sys.coltype$ to cdc;

grant select on sys.attrcol$ to cdc;

grant select on sys.ccol$ to cdc;

grant select on sys.cdef$ to cdc;

-- Miscellaneous other objects

grant select on sys.obj$ to cdc;

grant select on sys.dba_mviews tocdc;

grant select on sys.dba_objects tocdc;

grant select on sys.dba_sequences tocdc;

grant select on sys.hist_head$ tocdc;

grant select on sys.resource_cost tocdc;

-- Storage

grant select on sys.dba_tablespacesto cdc;

grant select on sys.dba_rollback_segsto cdc;

-- Permissions

grant select on sys.dba_users to cdc;

grant select on sys.dba_sys_privs tocdc;

grant select on sys.dba_tab_privs tocdc;

grant select on sys.dba_profiles tocdc;

grant select on sys.dba_roles to cdc;

grant select on sys.user$ to cdc;

grant select on user_role_privs tocdc;

配置两台数据库服务器的

/u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# tnsnames.ora Network ConfigurationFile:u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configurationtools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = db1)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

# tnsnames.ora Network ConfigurationFile:u01/app/oracle/product/11.2.0/dbhome_1/network/admin/tnsnames.ora

# Generated by Oracle configurationtools.

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = db2)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

8、启动ACCESSSERVER并创建管理用户

在192.168.100.101节点启动accessserver服务,并创建管理员用户admin

[root@db2 ~]# su - cdc2

[cdc2@db2 ~]$ cd/opt/accessserver/bin/

[cdc2@db2 bin]$ nohup ./dmaccessserver&

[1] 32556

[cdc2@db2 bin]$ nohup: ignoring inputand appending output to `nohup.out'

[cdc2@db2 bin]$ ps -ef|grep java

cdc2 32556 32537 5 15:30 pts/0 00:00:00/opt/accessserver/jre64/jre/bin/dmaccessserver-java -Duser.folder=/opt/accessserver-server -Xmx512m -jar lib/server.jar

cdc2 32569 32537 0 15:30 pts/0 00:00:00 grep java

[cdc2@db2 bin]$ ./dmcreateuser adminadmin admin admin1234 SYSADMIN TRUE FALSE FALSE

9、配置CDC实例

配置192.168.100.100端CDC实例

[cdc1@db1 ~]$ cd /opt/cdc/bin/

[cdc1@db1 bin]$ ./dmconfigurets

[cdc1@db1 ~]$ cd /opt/cdc/bin/

[cdc1@db1 bin]$ ./dmconfigurets

Welcome to the configuration tool forIBM InfoSphere Data Replication (Oracle). Use this tool to create instances ofIBM InfoSphere Data Replication (Oracle).

Press ENTER to continue...

Initializing. Please wait...

CONFIGURATION TOOL - CREATING A NEWINSTANCE

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

Enter the name of the new instance:orcl

Enter the server port number [11001]:

Enter the auto-discovery port numberor type 'DISABLE' [DISABLE]:

Staging Store Disk Quota is used tolimit the disk space used by IBM InfoSphere Data Replication staging Store. Ifthis space is exhausted, this instance may run at a lower speed. The minimumvalue allowed is 1 GB.

Enter the Staging Store Disk Quotafor this instance (GB) [100]:

Enter the Maximum Memory Allowed forthis instance (MB) [1024]:

Use read-only connection to database(y/n) [n]:

Use archive-only mode (y/n) [n]:

Select y to use JMS or TCP/IP enginecommunication connection, select n to use TCP only engine communicationconnection (y/n) [n]:

Enter the path for ORACLE_HOME:/u01/app/oracle/product/11.2.0/dbhome_1

TNS Name:

1. ORCL

2. Other...

Select a TNS Name: 1

Would you like to configure advancedparameters (y/n) [n]:

Enter the username: cdc

Enter the password:

Retrieving schema list...

Metadata schema:

Enter a database schema for metadatatables or press ENTER to list schemas:

1. ANONYMOUS

2. APEX_030200

3. APEX_PUBLIC_USER

4. APPQOSSYS

5. CDC

6. CTXSYS

7. DBSNMP

8. DIP

9. EXFSYS

10. FLOWS_FILES

11. MDDATA

12. MDSYS

13. MGMT_VIEW

14. OLAPSYS

Press ENTER to continue...

15. ORACLE_OCM

16. ORDDATA

17. ORDPLUGINS

18. ORDSYS

19. OUTLN

20. OWBSYS

21. OWBSYS_AUDIT

22. SCOTT

23. SI_INFORMTN_SCHEMA

24. SPATIAL_CSW_ADMIN_USR

25. SPATIAL_WFS_ADMIN_USR

26. SYS

27. SYSMAN

28. SYSTEM

29. WMSYS

Press ENTER to continue...

30. XDB

31. XS$NULL

Select a database schema for metadatatables: 5

NEW INSTANCE: orcl >>Configuration mode

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

1. Local log reading

2. Remote log reading

3. Manual log shipping

4. Log shipping with Data Guard

Enter your selection:1

Validating database support. Pleasewait...

Retrieving ASM info. Please wait...

Creating a new instance. Please wait...

Instance orcl was successfullycreated.

Would you like to START instance orclnow (y/n)?n

MAIN MENU

---------

1. List Current Instances

2. Add an Instance

3. Edit an Instance

4. Delete an Instance

5. Exit

Enter your selection:5

Exiting...

同样方法配置192.168.100.101的CDC实例。

10、启动CDC实例

192.168.100.100节点启动CDC实例

[cdc1@db1 bin]$ pwd

/opt/cdc/bin

[cdc1@db1 bin]$ nohup ./dmts64 -Iorcl &

[1] 29600

[cdc1@db1 bin]$ nohup: ignoring inputand appending output to `nohup.out'

[cdc1@db1 bin]$ ps -ef|grep java

cdc1 29600 29069 64 15:46 pts/0 00:00:12/opt/cdc/jre64/jre/bin/dmts64-java -cplib:lib/ts.jar:lib/activation.jar:lib/mail.jar:lib/pbembedded.jar:lib/pbclient.jar:lib/pbtools.jar:lib/cpci.jar:lib/commons-cli.jar:lib/asm-all-3.1.jar:lib/jlog.jar:lib/icu4j/icu4j-53_1.jar:lib/icu4j/icu4j-charset-53_1.jar:lib/icu4j/icu4j-localespi-53_1.jar:lib/CIoracle.jar-Xmx1024M -Xms704M -Xmine64M -XX:NewRatio=1 -Xgcpolicy:gencon-Dcom.sun.management.jmxremote -Duser.folder="/opt/cdc"-Djava.ext.dirs=lib/user:jre64/jre/lib/ext -Dcom.datamirror.ts.instance=orclcom.datamirror.ts.commandlinetools.script.Startup -I orcl

cdc1 29859 29069 0 15:46 pts/0 00:00:00 grep java

192.168.100.101节点启动CDC实例

[cdc2@db2 bin]$ pwd

/opt/cdc/bin

[cdc2@db2 bin]$ nohup ./dmts64 -I orcl &

[1] 33261

[cdc2@db2 bin]$ nohup: ignoring inputand appending output to `nohup.out'

[cdc2@db2 bin]$

[cdc2@db2 bin]$ ps -ef|grep java

cdc2 32556 1 0 15:30 pts/0 00:00:01/opt/accessserver/jre64/jre/bin/dmaccessserver-java -Duser.folder=/opt/accessserver-server -Xmx512m -jar lib/server.jar

cdc2 33261 32627 99 15:46 pts/0 00:00:07/opt/cdc/jre64/jre/bin/dmts64-java -cplib:lib/ts.jar:lib/activation.jar:lib/mail.jar:lib/pbembedded.jar:lib/pbclient.jar:lib/pbtools.jar:lib/cpci.jar:lib/commons-cli.jar:lib/asm-all-3.1.jar:lib/jlog.jar:lib/icu4j/icu4j-53_1.jar:lib/icu4j/icu4j-charset-53_1.jar:lib/icu4j/icu4j-localespi-53_1.jar:lib/CIoracle.jar-Xmx1024M -Xms704M -Xmine64M -XX:NewRatio=1 -Xgcpolicy:gencon-Dcom.sun.management.jmxremote -Duser.folder="/opt/cdc"-Djava.ext.dirs=lib/user:jre64/jre/lib/ext -Dcom.datamirror.ts.instance=orclcom.datamirror.ts.commandlinetools.script.Startup -I orcl

cdc2 33321 32627 0 15:46 pts/0 00:00:00 grep java

11、安装IIDR_ManagementConsole

运行iidrmc-11.3.3-4288-setup进行安装

12、源端数据库创建示例OE

拷贝OE创建脚本到192.168.100.100服务上

[root@db1 ~]# cd /home/oracle/oe/

[root@db1 oe]# pwd

/home/oracle/oe

[root@db1 oe]# ll

total 240

-rw-r--r-- 1 oracle oinstall 9845 Nov 29 15:58 oe_cre.sql

-rw-r--r-- 1 oracle oinstall 2338 Nov 29 15:58 oe_main.sql

-rw-r--r-- 1 oracle oinstall 2508 Nov 29 15:58 oe_p_cat.sql

-rw-r--r-- 1 oracle oinstall 67741Nov 29 15:58 oe_p_cus.sql

-rw-r--r-- 1 oracle oinstall 42411Nov 29 15:58 oe_p_itm.sql

-rw-r--r-- 1 oracle oinstall 21860Nov 29 15:58 oe_p_ord.sql

-rw-r--r-- 1 oracle oinstall 85879Nov 29 15:58 oe_p_pi.sql

登录sqlplus执行创建脚本@oe_main.sql

[root@db1 oe]# su - oracle

[oracle@db1 ~]$ cd oe/

[oracle@db1 oe]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0Production on Thu Nov 29 16:02:29 2018

Copyright (c) 1982, 2013,Oracle. All rights reserved.

Connected to:

Oracle Database 11g EnterpriseEdition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, DataMining and Real Application Testing options

SQL> @oe_main.sql

13、目标端创建OE用户

在192.168.10.101库里创建OE用户,与源端一样使用默认表空间users

CREATE USER OE IDENTIFIED BY OEDEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP;

ALTER USER "OE" QUOTAUNLIMITED ON USERS;

GRANT RESOURCE,CONNECT TO OE;

14、登录控制台,创建数据库

运行,启动控制台。输入创建的用户名密码admin/admin1234

选择access manager,点击创建数据库按钮

输入源端数据库数信息,点击PING后,再点击连接参数

输入CDC用户及密码,确定

同样方式添加目标端orcl-target

右键数据库,选择分配用户

同样方式分配orcl-target给admin用户

15、创建预订,同步数据表

点击“配置”,选择创建预订按钮

查192.168.100.101节点查看OE用户下创建出与192.168.100.100中OE相同的表结构

点击“监控”,选择创建的预订,右键选择“开始制作镜像”

点击确定后,开始进行数据同步

更多有用的实战内容请关注我的公众号

  • 发表于:
  • 原文链接https://kuaibao.qq.com/s/20181206G0O86P00?refer=cp_1026
  • 腾讯「云+社区」是腾讯内容开放平台帐号(企鹅号)传播渠道之一,根据《腾讯内容开放平台服务协议》转载发布内容。
  • 如有侵权,请联系 yunjia_community@tencent.com 删除。

扫码关注云+社区

领取腾讯云代金券