Oracle 11g 单实例到单实例OGG同步实施文档-OGG initial load

2022-11-03 13:15:09

Oracle 11g 单实例到单实例OGG同步实施文档-OGG initial load

2018-06-07 00:514730原创GoldenGate

作者： leo

本文链接：https://www.cndba.cn/leo1990/article/2837

1.环境介绍

类别	源端	目标端
数据库类型	单实例	单实例
数据库版本	11.2.0.4	11.2.0.4
ORACLE_SID	cndba	cndba
DB_NAME	cndba	cndba
主机IP地址	192.168.1.85	192.168.1.86
OS版本	RedHat 6.7	RedHat 6.7
OGG版本	11.2.1.0.1 64位	11.2.1.0.1 64位
主机名	cndba	cndba

2.安装前的准备工作

2.1.源端创建GoldenGate用户表空间

create tablespace ogg_data datafile '/u01/app/oracle/oradata/cndba/ogg01.dbf' size 100m autoextend off;

2.2.源端创建GoldenGate用户

create user ogg identified by ogg default tablespace ogg_data;

grant connect,resource,dba,create table,create sequence to ogg;

2.3.目标端创建GoldenGate用户表空间

create tablespace ogg_data datafile '/u01/app/oracle/oradata/cndba/ogg01.dbf' size 100m autoextend off;

2.4.目标端创建GoldenGate用户表空间

create user ogg identified by ogg default tablespace ogg_data;

grant connect,resource,dba,create table,create sequence to ogg;

2.5.源端创建测试用户及测试数据

SQL> create user test identified by test;

User created.

SQL> grant connect,resource to test;

Grant succeeded.

SQL> conn test/test

Connected.

SQL> create table test (id number(10) primary key ,name varchar(8));

Table created.

SQL> insert into test values(1,'zhangsan');

1 row created.

SQL> insert into test values(2,'lisi');

1 row created.

SQL> commit;

2.6.目标端创建测试用户及测试数据

SQL> create user test identified by test;

User created.

SQL> grant connect,resource to test;

Grant succeeded.

SQL> conn test/test

Connected.

SQL> create table test (id number(10) primary key ,name varchar(8));

Table created.

目标端不需要插入数据

2.7.源端开启归档模式、强制日志、附加日志

2.7.1.查看是否开启归档模式、强制日志、附加日志

SQL> select LOG_MODE, SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING from v$database;

LOG_MODE     SUPPLEME FOR

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

NOARCHIVELOG NO       NO

2.7.2.开启归档

[root@www.cndba.cn cndba]# mkdir -p /u01/archive

[root@www.cndba.cn cndba]# chown -R oracle:oinstall /u01/archive/

SQL> archive log list

Database log mode       No Archive Mode

Automatic archival       Disabled

Archive destination       /u01/app/oracle/product/11.2.0/db_1/dbs/arch

Oldest online log sequence     5

Current log sequence       7

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup mount

ORACLE instance started.

Total System Global Area 1060585472 bytes

Fixed Size    2260000 bytes

Variable Size  905970656 bytes

Database Buffers  146800640 bytes

Redo Buffers    5554176 bytes

Database mounted.

SQL> alter database archivelog;

Database altered.

SQL> alter database open;

Database altered.

SQL> alter system set log_archive_dest_1='location=/u01/archive';

System altered.

SQL> archive log liset

SP2-0718: illegal ARCHIVE LOG option

SQL> archive log list

Database log mode       Archive Mode

Automatic archival       Enabled

Archive destination       /u01/archive

Oldest online log sequence     5

Next log sequence to archive   7

Current log sequence       7

2.7.3.开启强制日志

SQL> alter database force logging;

Database altered.

2.7.4.开启附加日志

SQL> alter database add supplemental log data; 

Database altered.

2.7.5.查看是否开启归档模式、强制日志、附加日志

SQL> select LOG_MODE, SUPPLEMENTAL_LOG_DATA_MIN,FORCE_LOGGING from v$database;

LOG_MODE     SUPPLEME FOR

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

ARCHIVELOG     YES      YES

2.7.6.查看回收站是否关闭

SQL> show parameter recycle

NAME     TYPE VALUE

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

buffer_pool_recycle     string

db_recycle_cache_size     big integer 0

recyclebin     string on

SQL> alter system set recyclebin=off scope=spfile; 

System altered.

--重启数据库查看

SQL> show parameter recycle

NAME     TYPE VALUE

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

buffer_pool_recycle     string

db_recycle_cache_size     big integer 0

recyclebin     string OFF

3.GoldenGate安装

3.1.源端安装OGG

3.1.1.创建软件安装目录并赋权

[root@www.cndba.cn software]# mkdir -p /u01/app/oracle/ogg

[root@www.cndba.cn software]# chown -R oracle:oinstall /u01/app/oracle/ogg

3.1.2.配置oracle用户环境变量

[oracle@www.cndba.cn ~]$ vi .bash_profile

设置Library 路径

假设OGG的安装目录是/u01/app/oracle/ogg，那么在/home/oracle/.bash_profile文件里添加如下内容：

export OGG_HOME=$ORACLE_BASE/ogg

export PATH=$ORACLE_HOME/bin:$PATH:$OGG_HOME

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$OGG_HOME:/lib:/usr/lib

--source 使修改生效：

[oracle@www.cndba.cn ~]$ source .bash_profile

3.1.3.解压ogg文件

[root@www.cndba.cn software]# cd /software/

[root@www.cndba.cn software]# unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[root@www.cndba.cn software]# tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/oracle/ogg

[root@www.cndba.cn ogg]# chown -R oracle:oinstall /u01/app/oracle/ogg

注意：/u01/app/oracle/ogg 是$OGG_HOME

3.1.4.运行ogg并创建目录

[oracle@www.cndba.cn ~]$ cd $OGG_HOME

[oracle@www.cndba.cn ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (cndba) 1> create subdirs

Creating subdirectories under current directory /u01/app/oracle/ogg

Parameter files                /u01/app/oracle/ogg/dirprm: already exists

Report files                   /u01/app/oracle/ogg/dirrpt: created

Checkpoint files               /u01/app/oracle/ogg/dirchk: created

Process status files           /u01/app/oracle/ogg/dirpcs: created

SQL script files               /u01/app/oracle/ogg/dirsql: created

Database definitions files     /u01/app/oracle/ogg/dirdef: created

Extract data files             /u01/app/oracle/ogg/dirdat: created

Temporary files                /u01/app/oracle/ogg/dirtmp: created

Stdout files                   /u01/app/oracle/ogg/dirout: created

3.2.目标端安装OGG

3.2.1.创建软件安装目录并赋权

[root@www.cndba.cn software]# mkdir -p /u01/app/oracle/ogg

[root@www.cndba.cn software]# chown -R oracle:oinstall /u01/app/oracle/ogg

3.2.2.配置oracle用户环境变量

[oracle@www.cndba.cn ~]$ vi .bash_profile

设置Library 路径

假设OGG的安装目录是/u01/app/oracle/ogg，那么在/home/oracle/.bash_profile文件里添加如下内容：

export OGG_HOME=$ORACLE_BASE/ogg

export PATH=$ORACLE_HOME/bin:$PATH:$OGG_HOME

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$OGG_HOME:/lib:/usr/lib

--source 使修改生效：

[oracle@www.cndba.cn ~]$ source .bash_profile

3.2.3.解压ogg文件

[root@www.cndba.cn software]# cd /software/

[root@www.cndba.cn software]# unzip ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip

[root@www.cndba.cn software]# tar -xvf fbo_ggs_Linux_x64_ora11g_64bit.tar -C /u01/app/oracle/ogg

[root@www.cndba.cn ogg]# chown -R oracle:oinstall /u01/app/oracle/ogg

注意：/u01/app/oracle/ogg 是$OGG_HOME

3.2.4.运行ogg并创建目录

[oracle@www.cndba.cn ~]$ cd $OGG_HOME

[oracle@www.cndba.cn ogg]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (cndba) 1> create subdirs

Creating subdirectories under current directory /u01/app/oracle/ogg

Parameter files                /u01/app/oracle/ogg/dirprm: already exists

Report files                   /u01/app/oracle/ogg/dirrpt: created

Checkpoint files               /u01/app/oracle/ogg/dirchk: created

Process status files           /u01/app/oracle/ogg/dirpcs: created

SQL script files               /u01/app/oracle/ogg/dirsql: created

Database definitions files     /u01/app/oracle/ogg/dirdef: created

Extract data files             /u01/app/oracle/ogg/dirdat: created

Temporary files                /u01/app/oracle/ogg/dirtmp: created

Stdout files                   /u01/app/oracle/ogg/dirout: created

4.GoldenGate配置

4.1.OGG源端配置

4.1.1.配置mgr进程

GGSCI (cndba) 3> edit params mgr

GGSCI (cndba) 4> view params mgr

port 7809

GGSCI (cndba) 5> start mgr

Manager started.

GGSCI (cndba) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

GGSCI (cndba) 7> sh netstat -ntpl |grep 7809  --查看7809端口是否启用

(Not all processes could be identified, non-owned process info

 will not be shown, you would have to be root to see it all.)

tcp        0      0 :::7809                     :::*                        LISTEN      14176/./mgr         

GGSCI (cndba) 8>  sh ps -ef|grep mgr  --查看mgr进程是否存在

root        14     2  0 13:24 ?        00:00:00 [async/mgr]

postfix   1867  1860  0 13:26 ?        00:00:00 qmgr -l -t fifo -u

oracle   14176 14114  0 15:43 ?        00:00:00 ./mgr PARAMFILE /u01/app/oracle/ogg/dirprm/mgr.p

oracle   14185 14114  0 15:44 pts/0    00:00:00 sh -c ps -ef|grep mgr

oracle   14187 14185  0 15:44 pts/0    00:00:00 grep mgr

4.1.2.添加表级transdata

GGSCI (cndba) 10> dblogin userid ogg,password ogg

Successfully logged into database.

查看是否开启

GGSCI (cndba) 11>  info trandata test.test

GGSCI (cndba) 11>  add trandata test.*

Logging of supplemental redo data enabled for table TEST.TEST.

注意：为了方便这里直接添加整个用户下表级transdata，如果只是同步部分表的，请批量

执行add trandata test.tablename

4.1.3.配置extract抽取进程

GGSCI (cndba) 13>  dblogin userid ogg,password ogg

Successfully logged into database.

GGSCI (cndba) 14> add extract ext1, tranlog, begin now, threads 1

EXTRACT added.

GGSCI (cndba) 15> add exttrail ./dirdat/et, extract ext1

EXTTRAIL added.

GGSCI (cndba) 16>  edit params ext1

GGSCI (cndba) 17> view params ext1

EXTRACT ext1

SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK") --此处数据库字符集设为一致

--SETENV (ORACLE_SID = "cndba")

SETENV (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

USERID ogg, PASSWORD ogg

THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000

EXTTRAIL ./dirdat/et

DYNAMICRESOLUTION

--DDL INCLUDE ALL

TABLE test.*;

4.1.4.配置pump传输进程

GGSCI (cndba) 18> add extract pump1,exttrailsource ./dirdat/et,begin now

EXTRACT added.

GGSCI (cndba) 19> add rmttrail ./dirdat/et,extract pump1

RMTTRAIL added.

GGSCI (cndba) 20> edit params pump1

GGSCI (cndba) 21> view params pump1

EXTRACT pump1

RMTHOST 192.168.1.86, MGRPORT 7809

RMTTRAIL ./dirdat/et

PASSTHRU

DYNAMICRESOLUTION

TABLE test.*;

GGSCI (cndba) 22> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     EXT1        00:00:00      00:18:00

EXTRACT     STOPPED     PUMP1       00:00:00      00:04:07

4.2.OGG目标端配置

4.2.1.添加GLOBALS参数文件，创新检查点表

GGSCI (cndba) 7> edit params ./GLOBALS

GGSCI (cndba) 8> view params ./GLOBALS

--添加以下内容：

GGSCHEMA ogg

checkpointtable ogg.checkpoint

GGSCI (cndba) 9> dblogin userid ogg,password ogg

Successfully logged into database.

GGSCI (cndba) 10> add checkpointtable ogg.checkpoint   

Successfully created checkpoint table ogg.checkpoint.

4.2.2.配置mgr进程

GGSCI (cndba) 3> edit params mgr

GGSCI (cndba) 4> view params mgr

port 7809

GGSCI (cndba) 5> start mgr

Manager started.

GGSCI (cndba) 6> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

GGSCI (cndba) 7> sh netstat -ntpl |grep 7809  --查看7809端口是否启用

(Not all processes could be identified, non-owned process info

 will not be shown, you would have to be root to see it all.)

tcp        0      0 :::7809                     :::*                        LISTEN      14176/./mgr         

GGSCI (cndba) 8>  sh ps -ef|grep mgr  --查看mgr进程是否存在

root        14     2  0 13:24 ?        00:00:00 [async/mgr]

postfix   1867  1860  0 13:26 ?        00:00:00 qmgr -l -t fifo -u

oracle   14176 14114  0 15:43 ?        00:00:00 ./mgr PARAMFILE /u01/app/oracle/ogg/dirprm/mgr.p

oracle   14185 14114  0 15:44 pts/0    00:00:00 sh -c ps -ef|grep mgr

oracle   14187 14185  0 15:44 pts/0    00:00:00 grep mgr

4.2.3.配置replicat复制进程

GGSCI (cndba) 11> add replicat rep1, exttrail ./dirdat/et, checkpointtable ogg.checkpoint

REPLICAT added.

GGSCI (cndba) 12> edit params rep1

GGSCI (cndba) 13> view params rep1

REPLICAT rep1

setenv (ORACLE_SID=cndba)

SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_1")

USERID ogg,PASSWORD ogg

ASSUMETARGETDEFS

HANDLECOLLISIONS

REPERROR (DEFAULT, DISCARD)

DDLERROR DEFAULT DISCARD

DDLOPTIONS REPORT

DISCARDFILE ./dirrpt/repr1.dsc,append,megabytes 100

MAP test.*, TARGET test.*;

5.初始化数据-initial load

5.1.启动生产端和容灾端的管理进程

--源端

[oracle@cndba ogg]$ cd /u01/app/oracle/ogg

[oracle@cndba ogg]$ ./ggsci

GGSCI (cndba) 1> start mgr

Manager started.

GGSCI (cndba) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     STOPPED     EXT1        00:00:00      00:40:35

EXTRACT     STOPPED     PUMP1       00:00:00      00:26:42

--目标端

[oracle@host1 ~]$ cd /u01/app/oracle/ogg

[oracle@host1 ogg]$ ./ggsci

GGSCI (host1) 1> start mgr

Manager started.

GGSCI (cndba) 14> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    STOPPED     REP1        00:00:00      00:11:22

5.2.源端初始化抽取的配置

GGSCI (cndba) 6> edit params extinit

添加以下内容：

EXTRACT extinit

userid ogg , password ogg

RMTHOST 192.168.1.86 , MGRPORT 7809

RMTTASK replicat,GROUP repinit --目标端replicat

TABLE test.* ;

---------添加初始化Extract 进程---------------

ADD EXTRACT extinit, SOURCEISTABLE

5.3.目标端初始化复制的配置

GGSCI (host1) 11> edit params repinit

添加以下内容：

REPLICAT repinit

USERID ogg, PASSWORD ogg

ASSUMETARGETDEFS

MAP test.* , target test.* ;

---------添加初始化Replicat 进程---------------

ADD REPLICAT repinit, SPECIALRUN

5.4.启动源端的EXTRACT进程

GGSCI (cndba) 2> start ext1

Sending START request to MANAGER ...

EXTRACT EXT1 starting

GGSCI (cndba) 4> start pump1

Sending START request to MANAGER ...

EXTRACT PUMP1 starting

GGSCI (cndba) 5> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

EXTRACT     RUNNING     EXT1        00:00:00      00:00:03

EXTRACT     RUNNING     PUMP1       00:00:00      00:28:57

5.5.启动生产端的抽取进程

启动生产端的批量抽取进程start extinit，不需要启动repinit 进程，

MGR 会自动启动它，等同步结束，他会自动关闭：

启动生产端的抽取进程start extinit：

GGSCI (cndba) 31> start extinit

Sending START request to MANAGER ...

EXTRACT EXTINIT starting

5.6.在源端view report extinit 直到load 结束，然后做下一步

源端查看日志

[root@cndba ogg]# tail -f ggserr.log

2018-06-06 23:06:12  INFO    OGG-00963  Oracle GoldenGate Manager for Oracle, mgr.prm:  Command received from GGSCI on host cndba (START EXTRACT EXTINIT ).

2018-06-06 23:06:12  INFO    OGG-00975  Oracle GoldenGate Manager for Oracle, mgr.prm:  EXTRACT EXTINIT starting.

2018-06-06 23:06:12  INFO    OGG-01017  Oracle GoldenGate Capture for Oracle, extinit.prm:  Wildcard resolution set to IMMEDIATE because SOURCEISTABLE is used.

2018-06-06 23:06:12  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, extinit.prm:  EXTRACT EXTINIT starting.

2018-06-06 23:06:12  INFO    OGG-03035  Oracle GoldenGate Capture for Oracle, extinit.prm:  Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.

2018-06-06 23:06:13  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, extinit.prm:  Virtual Memory Facilities for: COM

    anon alloc: mmap(MAP_ANON)  anon free: munmap

    file alloc: mmap(MAP_SHARED)  file free: munmap

    target directories:

    /u01/app/oracle/ogg/dirtmp.

2018-06-06 23:06:13  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, extinit.prm:  EXTRACT EXTINIT started.

2018-06-06 23:06:41  INFO    OGG-00991  Oracle GoldenGate Capture for Oracle, extinit.prm:  EXTRACT EXTINIT stopped normally.

目标端查看数据已经初始化

SQL> select * from test;

ID NAME

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

 1 zhangsan

 2 lisi

5.7.在容灾端启动投递进程start rep1

GGSCI (cndba) 7> start rep1

Sending START request to MANAGER ...

REPLICAT REP1 starting

GGSCI (cndba) 8> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     REP1        00:00:00      00:00:01

GGSCI (cndba) 9>  info rep1

REPLICAT   REP1      Last Started 2018-06-06 23:10   Status RUNNING

Checkpoint Lag       00:00:00 (updated 00:00:07 ago)

Log Read Checkpoint  File ./dirdat/et000001

                     2018-06-06 22:45:16.054664  RBA 1209

5.8.关掉冲突检查选项SEND REPLICAT rep1, NOHANDLECOLLISIONS

GGSCI (cndba) 10>  SEND REPLICAT rep1, NOHANDLECOLLISIONS

Sending NOHANDLECOLLISIONS request to REPLICAT REP1 ...

REP1 No tables found matching * to set NOHANDLECOLLISIONS

.

5.9.去掉rep1 文件中的HANDLECOLLISIONS 参数

GGSCI (host1) 58> view params rep1

--HANDLECOLLISIONS

6.检查同步是否正常

6.1.DML测试

--检查目标端数据是否正常

GGSCI (cndba) 4> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING

REPLICAT    RUNNING     REP1        00:00:00      00:00:06

SQL> select * from test;

ID NAME

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

 1 zhangsan

 2 lisi

--源端表中添加数据

SQL> insert into test values(3,'wanger');

1 row created.

SQL> commit;

Commit complete.

SQL> select * from test;

ID NAME

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

 1 zhangsan

 2 lisi

 3 wanger

--目标端查看

SQL> select * from test;

ID NAME

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

 1 zhangsan

 2 lisi

 3 wanger

可以看到可以同步过来的。

7.开启DDL

7.1.添加参数

GGSCI (cndba) 8> edit params ./GLOBALS

GGSCI (cndba) 9> view params ./GLOBALS

GGSCHEMA ogg

7.2.在源端执行与DDL同步相关的SQL脚本

切记@marker_setup.sql 一定要在cd $OGG_HOME目录下执行否则会卡主。执行脚本时要输入ogg管理用户，本实例是ogg。

cd /u01/app/oracle/ogg

sqlplus / as sysdba

grant execute on utl_file to ogg;

@marker_setup.sql

@ddl_setup.sql

@role_setup.sql

grant GGS_GGSUSER_ROLE to ogg;

@ddl_enable.sql

@ddl_pin ogg

@marker_status

7.3.源端extract 配置

GGSCI (cndba) 12> edit params ext1

GGSCI (cndba) 16> view params ext1

EXTRACT ext1

SETENV (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK") --此处数据库字符集设为一致

--SETENV (ORACLE_SID = "cndba")

SETENV (ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

USERID ogg, PASSWORD ogg

THREADOPTIONS MAXCOMMITPROPAGATIONDELAY 20000

EXTTRAIL ./dirdat/et

DYNAMICRESOLUTION

DDL INCLUDE ALL

TABLE test.*;

重启extract进程

GGSCI (cndba) 13> stop ext1 

Sending STOP request to EXTRACT EXT1 ...

Request processed.

GGSCI (cndba) 14> start ext1

Sending START request to MANAGER ...

EXTRACT EXT1 starting

7.4.目标端replicat 配置

GGSCI (cndba) 8> edit params rep1

GGSCI (cndba) 9> view params rep1

REPLICAT rep1

setenv (ORACLE_SID=cndba)

SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_1")

USERID ogg,PASSWORD ogg

ASSUMETARGETDEFS

HANDLECOLLISIONS

REPERROR (DEFAULT, DISCARD)

DDLERROR DEFAULT DISCARD

DDLOPTIONS REPORT

DISCARDFILE ./dirrpt/repr1.dsc,append,megabytes 100

MAP test.*, TARGET test.*;

ddl include all

ddlerror default ignore retryop maxretries 3 retrydelay 5

重启replicat进程

GGSCI (cndba) 10> stop rep1

Sending STOP request to REPLICAT REP1 ...

Request processed.

GGSCI (cndba) 11> start rep1

Sending START request to MANAGER ...

REPLICAT REP1 starting

7.5.DDL测试

--源端：

SQL> create table test1 (id number(10) primary key ,name varchar(8));

Table created.

SQL> insert into test1 values(1,'zhangsan');

1 row created.

SQL> commit;

Commit complete.

--目标端：

SQL> desc test1

 Name   Null?    Type

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

 ID   NOT NULL NUMBER(10)

 NAME    VARCHAR2(8)

SQL> select * from test1;

ID NAME

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

 1 zhangsan

码农公寓

Oracle 11g 单实例到单实例OGG同步实施文档-OGG initial load

1.环境介绍

2.安装前的准备工作

2.1.源端创建GoldenGate用户表空间

2.2.源端创建GoldenGate用户

2.3.目标端创建GoldenGate用户表空间

2.4.目标端创建GoldenGate用户表空间

2.5.源端创建测试用户及测试数据

2.6.目标端创建测试用户及测试数据

2.7.源端开启归档模式、强制日志、附加日志

2.7.1.查看是否开启归档模式、强制日志、附加日志

2.7.2.开启归档

2.7.3.开启强制日志

2.7.4.开启附加日志

2.7.5.查看是否开启归档模式、强制日志、附加日志

2.7.6.查看回收站是否关闭

3.GoldenGate安装

3.1.源端安装OGG

3.1.1.创建软件安装目录并赋权

3.1.2.配置oracle用户环境变量

3.1.3.解压ogg文件

3.1.4.运行ogg并创建目录

3.2.目标端安装OGG

3.2.1.创建软件安装目录并赋权

3.2.2.配置oracle用户环境变量

3.2.3.解压ogg文件

3.2.4.运行ogg并创建目录

4.GoldenGate配置

4.1.OGG源端配置

4.1.1.配置mgr进程

4.1.2.添加表级transdata

4.1.3.配置extract抽取进程

4.1.4.配置pump传输进程

4.2.OGG目标端配置

4.2.1.添加GLOBALS参数文件，创新检查点表

4.2.2.配置mgr进程

4.2.3.配置replicat复制进程

5.初始化数据-initial load

5.1.启动生产端和容灾端的管理进程

5.2.源端初始化抽取的配置

5.3.目标端初始化复制的配置

5.4.启动源端的EXTRACT进程

5.5.启动生产端的抽取进程

5.6.在源端view report extinit 直到load 结束，然后做下一步

5.7.在容灾端启动投递进程start rep1

5.8.关掉冲突检查选项SEND REPLICAT rep1, NOHANDLECOLLISIONS

5.9.去掉rep1 文件中的HANDLECOLLISIONS 参数

6.检查同步是否正常

6.1.DML测试

7.开启DDL

7.1.添加参数

7.2.在源端执行与DDL同步相关的SQL脚本

7.3.源端extract 配置

7.4.目标端replicat 配置

7.5.DDL测试

相关文章