Oracle文件系统加dg,在ORACLE 12C RAC 的DG库上搭建OGG

一.创建共享磁盘

1. 查看rac节点是否有ASM的监听注册(双节点)

su – oracle

lsnrctl services

sqlplus sys/woailyoo@ORCL as sysdba

select instance_name from gv$instance;

5.检查

lsmod | grep oracle

7. 创建acfs挂载目录，在两个节点都要创建相同目录

su – root

mkdir -p /acfsload-503

8. 用mkfs创建文件系统(格式化磁盘)

su – root

mkfs -t acfs -n acfs01 /dev/asm/acfsload-503

三.安装 DG OGG

跟RAC安装类似，这里略过

四.配置 RAC OGG

1.检查归档、最小附加日志、强制日志是否开启

select log_mode,supplemental_log_data_min,force_logging from v$database;

① 开启最小附加日志

alter database add supplemental log data;

② 开启强制日志

alter database force logging;

2. OGG 创建文件夹

su – oracle

cd $OGG_HOME

./ggsci

create subdirs

3.配置mgr进程

edit params mgr

PORT 7809

DYNAMICPORTLIST 7840-7939

–AUTOSTART ER *

–AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3

PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 7

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

start mgr

4.创建用户

CREATE USER goldengate   IDENTIFIED BY goldengate ;

GRANT CONNECT TO goldengate;

GRANT ALTER ANY  TABLE TO goldengate;

GRANT ALTER SESSION TO goldengate;

GRANT CREATE SESSION TO goldengate;

GRANT FLASHBACK ANY TABLE TO goldengate;

GRANT SELECT ANY DICTIONARY TO goldengate;

GRANT SELECT ANY TABLE TO goldengate;

GRANT RESOURCE TO goldengate;

GRANT drop ANY TABLE TO goldengate;

grant create any table to goldengate;

grant insert any table to goldengate;

grant update any table to goldengate;

grant delete any table to goldengate;

grant select any transaction to goldengate;

BEGIN

dbms_goldengate_auth.grant_admin_privilege(grantee => ‘goldengate’,

privilege_type => ‘CAPTURE’,grant_select_privileges => TRUE,do_grants => TRUE);

END;

/

5.启用  enable_goldengate_replication

alter system set enable_goldengate_replication=true scope=both;

6.添加表级附加日志

ggsci > dblogin userid goldengate password goldengate

ggsci> add trandata WOAILYOO.OGG_TEST

7.生成def文件

ggsci> eidt params defgen

userid goldengate,password goldengate

defsfile ./dirdef/sql.def

table   WOAILYOO.OGG_TEST;

cd $OGG_HOME

./defgen  paramfile  dirprm/ defgen.prm

五.配置 DG OGG

1.检查归档、最小附加日志、强制日志是否开启

select log_mode,supplemental_log_data_min,force_logging from v$database;

2.检查 enable_goldengate_replication 是否启用

show parameter enable_goldengate_replication;

3.检查 临时文件 是否本地文件

select * from v$tempfile;

①开启最小附加日志

alter database add supplemental log data;

②开启强制日志

alter database force logging;

③启用enable_goldengate_replication

alter system set enable_goldengate_replication=true scope=both;

④创建本地临时文件

alter tablespace temp add tempfile ‘/u01/app/oracle/oradata/dg/ogg_temp01.dbf’ size 100M reuse autoextend on next 50M maxsize 20G;

4.配置mgr参数

edit params mgr

PORT 7809

DYNAMICPORTLIST 7840-7939

–AUTOSTART ER *

–AUTORESTART EXTRACT *,RETRIES 5,WAITMINUTES 3

PURGEOLDEXTRACTS ./dirdat/*,usecheckpoints, minkeepdays 7

LAGREPORTHOURS 1

LAGINFOMINUTES 30

LAGCRITICALMINUTES 45

5.增加抽取进程和指定队列文件

GGSCI>add extract extpdb , tranlog,begin now, threads 2

GGSCI> add exttrail ./dirdat/pd, extract extpdb, megabytes 200

edit params extpdb

EXTRACT extpdb

setenv (NLS_LANG=”AMERICAN_AMERICA.ZHS16GBK”)

SETENV (ORACLE_SID=dg)

userid goldengate,password goldengate

tranlogoptions DBLOGREADER

REPORTCOUNT EVERY 1 MINUTES, RATE

WARNLONGTRANS 2h,CHECKINTERVAL 600s

FETCHOPTIONS NOUSESNAPSHOT

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

EXTTRAIL ./dirdat/pd

DBOPTIONS ALLOWUNUSEDCOLUMN

TRANLOGOPTIONS MINEFROMACTIVEDG

TRANLOGOPTIONS ALTARCHIVEDLOGFORMAT %t_%s_%r.arc

TRANLOGOPTIONS ALTARCHIVELOGDEST /u01/arch

STATOPTIONS REPORTFETCH

table WOAILYOO.OGG;

6.增加传输进程和指定队列文件

GGSCI> add extract dpepdb, exttrailsource ./dirdat/pd

GGSCI>add RMTTRAIL ./dirdat/pd, EXTRACT dpepdb, MEGABYTES 200

EXTRACT dpepdb

PASSTHRU

RMTHOST 192.168.247.16, MGRPORT 7809, compress

RMTTRAIL ./dirdat/pd

table WOAILYOO.OGG;

六.配置目标端OGG

aaa

ORA-16000: database or pluggable database open for read-only access

可以看到虽然DG库是单实例的，但依然继承群集的架构(双节点)

未完成，明日再写。

相关资源：阿P软件之划词复制v1.20绿色版-其它代码类资源-CSDN文库