OGG同步流程

OGG同步流程

作为本际云服务器推荐网的小编小本本，我们在数据库中常用到主副库来确保容灾的可能。而OGG是我们用来进行主副库同步的产品。以下是OGG搭建的详细流程。

一、OGG安装及源端配置

1.1 开启源端附加日志与数据库强制日志模式开启：

alter database add supplementallog data;

alter system switch logfile;

alter database force logging;

1.2 查询是否开启归档

select log_mode from v$database;

二、安装OGG

2.1 配置好环境变量（如果是oracle用户安装，则无需配置）

2.2 解压安装包

2.3 创建子目录./ggsci create subdirs

2.4 目标库安装

2.5 编辑oggcore.rsp

cd /OGG/ogg_software/fbo_ggs_AIX_ppc_shiphome/Disk1/response

主要修改如下几个地方：

INSTALL_OPTION=ORA12c——数据库版本；

SOFTWARE_LOCATION=/OGG/ogg_soft——软件安装目，请提前创建个空目录；

START_MANAGER=NO——不启动mgr；

MANAGER_PORT=7809——端口；

UNIX_GROUP_NAME=oinstall——安装属组；

2.6 安装

cd至OGG解压目录：./runInstaller-silent -responseFile/OGG/ogg_software/fbo_ggs_AIX_ppc_shiphome/Disk1/response/oggcore.rsp

2.7 创建子目录cd/OGG/ogg_soft

./ggsci createsubdirs

2.8 配置管理进程netstat-na|grep 7809确认端口没有被占用：

./ggsci editparams mgr

以下为简单配置：

port 7809

DYNAMICPORTLIST 7810-7890

purgeoldextracts ./dirdat/*,usecheckpoints,minkeepdays4

AUTORESTARTEXTRACT*,RETRIES3,WAITMINUTES5,RESETMINUTES60

LAGREPORTHOURS1

LAGINFOMINUTES30

LAGCRITICALMINUTES45

2.9 启动MGR进程

Start mgr

三、OGG同步流程

3.1 创建OGG使用的表空间

CREATE TABLESPACE ogg DATAFILE +DATA SIZE 200M AUTOEXTEND ON NEXT 100M MAXSIZE 5G;

3.2 创建用户两端都要

CREATE USER goldengate IDENTIFIED BY Ogg2022 DEFAULT TABLESPACE ogg;

grant connect,resource,unlimited tablespace to goldengate;

grant CREATE SESSION,ALTER SESSION to goldengate;

grant alter system to goldengate;

grant SELECT on dba_clusters to goldengate;

grant execute on utl_file to goldengate;

grant select any dictionary to goldengate;

grant select any table to goldengate;

grant alter any table to goldengate;

grant flashback any table to goldengate;

grant execute on DBMS_FLASHBACK to goldengate;

grant EXEMPT ACCESS POLICY to goldengate;

grant select any transaction to goldengate;

grant EXP_FULL_DATABASE to goldengate;

3.3 配置环境变量

添加或修改以下行：

export GG_HOME=/oraclelog/OGG/ogg/ogg_insta

export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib:$ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib

export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin:$GG_HOME

3.4 配置源端抽取进程

GGSCI> editparams exttsap1

EXTRACT EXTTSAP1

dynamicresolution

SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

SETENV(ORACLE_HOME=/oracle/app/oracle/product/19.0.0/db)

userid goldengate, password秘钥, encryptkey default

DISCARDFILE ./dirrpt/EXTTSAP1.dsc, APPEND, MEGABYTES 1024

DBOPTIONS LOBBUFSIZE 1048576

TRANLOGOPTIONS ALTARCHIVELOGDEST primary instance amptest1/oraclelog, ALTARCHIVELOGDEST instance amptest2/oraclelog

EXTTRAIL ./dirdat/ap

gettruncates

table *.*

dblogin userid goldengate, password#加密秘钥#, encryptkey default

创建extract抽取进程：

GGSCI (ogg-test)1>dblogin userid goldengate, password Ogg#2022

GGSCI (ogg-test)1>add extract exttsap1, tranlog, begin now—-注明：rac数据库需要加[threads 2]

GGSCI (ogg-test)1>add exttrail ./dirdat/ap, extract exttsap1, megabytes 200

3.5 配置投递进程

edit params dptsap1

EXTRACT dptsap1

PASSTHRU

SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

RMTHOST 134.176.15.135, MGRPORT 7809

RMTTRAIL /oradata/ogg/dirdat/ap

table *.*

增加传输进程组：

GGSCI>add extract dptsap1, exttrail source ./dirdat/ap

建立传输进程和目标端队列文件关联关系：

GGSCI>addrmttrail ./dirdat/ap, extract dptsap1, megabytes 200

start dptsap1

3.6 目标端配置复制进程

edit params retsap1

replicat retsap1

SETENV(NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

userid goldengate, password秘钥, encryptkey default

–sourcedefs ./dirdef/retsap1.def

reperror default, discard discardfile ./dirrpt/retsap1.dsc, append, megabytes 1024

gettruncates

handlecollisions

dynamicresolution

map *.*, target *.*;

注：*.*属主.表名

增加复制进程：

GGSCI>DBLOGIN USERID goldengate, PASSWORD Ogg#2022

GGSCI>add checkpointtable goldengate.checkpoint

GGSCI>add replicat retsap1, exttrail ./dirdat/ap, checkpointtable goldengate.checkpoint

配完后暂时不要启动进程，初始化完成之后在启动：

alter retsap1 extseqno 1,extrba 0

start retsap1,aftercsn XXXXXXXX

以上就是OGG同步流程的详细步骤，希望能对你有所帮助。