mysql的安装ogg_简单几步安装ogg - Oracle数据库管理 - ITPUB论坛－中国专业的IT技术社区...

简单几步安装ogg

安装ogg

1.解压安装文件

2.设置变量(oracle用户)

PATH=...:/ogg

LD_LIBRARY_PATH=...:/ogg

3.ogg创建目录

$ggsci

1>create subdirs

4.创建ogg用户

$sqlplus / as sysdba

sql>create tablespace ogg_data datafile '/u01/oradata/cheese/ogg_data01.dbf' size 200M;

sql> create user goldengate identified by goldengate

default tablespace ogg_data temporary tablespace TEMP;

SQL> grant connect ,resource to goldengate;

Grant succeeded.

SQL> grant select any dictionary,select any table to goldengate;

Grant succeeded.

SQL> grant create table to goldengate;

Grant succeeded.

SQL> grant flashback any table to goldengate;

Grant succeeded.

SQL> grant execute on dbms_flashback to goldengate;

Grant succeeded.

SQL> grant execute on utl_file to goldengate;

Grant succeeded.

5.登陆ogg

$ggsci

1>dblogin userid goldengate,password goldengate

6.开启supplement

查看supplement信息

select supplemental_log_data_min,

supplemental_log_data_pk,

supplemental_log_data_ui,

supplemental_log_data_fk,

supplemental_log_data_all

from v$database;

sql>alter database add supplemental log data(all) columns;

7.配置Manager进程(源端与备端)

$ggsci

1>dblogin userid goldengate,password goldengate

2>edit params mgr

PORT 7809

USERID goldengate,PASSWORD goldengate

PURGEOLDEXTRACTS /ogg/dirdat/ex,USECHECKPOINTS

：wq

PORT 7809

AUTORESTART E *,RETRIES 5,WAITMINUTES 3

PURGEOLDEXTRACTS /ogg/dirdat/ex,USECHECKPOINTS,MINKEEPDAYS 7

3>start MGR

4>stop MGR

5>start MGR

8.配置Loader进程

源端

$ggsci

1>dblogin userid goldengate,password goldengate

2>add extract extdata,sourceistable

编辑extdata抽取进程参数文件

3>edit params extdata

EXTRACT extdata

USERID goldengate,PASSWORD goldengate

RMTHOST 192.168.75.52,MGRPORT 7809

RMTTASK replicat,GROUP repdata

TABLE cheese.test;

目标端

$ggsci

1>dblogin userid goldengate,password goldengate

2>add replicat repdata,SPECIALRUN

编辑repdata参数文件

3>edit params repdata

REPLICAT repdata

USERID goldengate,PASSWORD goldengate

ASSUMETARGETDEFS

MAP cheese.test,TARGET cheese.test;

再附上一篇比较好的文档