golendgate（27）---使用standby database 创建goldengate extract抽取数据中心

standby database 配置好之后，备库创建成数据归档中心，所有的归档日志存储在这台机器上，该台机器创建成为数据分发中心。

请注意：
1. 该台机器是一台archive log repository的机器，所谓archive log repository就是该
台机器上只有实例和standby controle file，没有数据文件。该机器上创建几组 standby redo log,提供挖掘联机重做日志，不创建也可，只挖掘归档日志。
2. 该standby database是一台单实例，不是RAC,在RAC上配置goldengate将在后续发布。

3. goldengate安装在这台机器上，使用oracle net services访问主库。

4. 版本：goldengate 11.2.0.1 for oracle11g

进行下面goldengate配置：

源端配置：
create tablespace ggs datafile '+DATA/dbking/datafile/ggs01.dbf'
size 100M
autoextend on
maxsize 1024M
extent management local
uniform. size 128k
segment space management auto;
create user ggs identified by ggs default tablespace ggs

grant dba to ggs;####完成配置之后回收.
grant create session,alter session to ggs;
grant resource to ggs;
grant connect to ggs;
grant select any dictionary to ggs;
grant flashback any table to ggs;
grant select any table to ggs;
grant execute on dbms_flashback to ggs;

cd /u01/app/oracle/ggs/dirdat
mkdir -p trail/hr

GGSCI (dbhouse) 2> create subdirs

ggsci>edit params ./GLOBALS
GGSCHEMA ggs

ggsci>edit params mgr

PORT 7809
DYNAMICPORTLIST 7810-7820, 7830
AUTOSTART EXTRACT *
AUTORESTART EXTRACT *, RETRIES 4, WAITMINUTES 4
STARTUPVALIDATIONDELAY 5
PURGEOLDEXTRACTS /u01/app/oracle/ggs/dirdat/trail/hr/tt*, USECHECKPOINTS, MINKEEPHOURS 10

GGSCI (oggmiddle) 3> dblogin userid ggs@dbking, password ggs
Successfully logged into database.

GGSCI (oggmiddle) 4>
add EXTRACT s_ex_mid, tranlog, begin now
EXTRACT added.

GGSCI (oggmiddle) 5> add exttrail /u01/app/oracle/ggs/dirdat/trail/cc, extract s_ex_mid
EXTTRAIL added.

edit params s_ex_mid

EXTRACT s_ex_mid
-- SETENV (NLS_LANG = CHINESE_CHINA.ZHS16GBK)
SETENV (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/dbhome_1")
SETENV (ORACLE_SID = "dbking")
USERID ggs@dbking, PASSWORD ggs
-- TRANLOGOPTIONS ARCHIVEDLOGONLY
-- TRANLOGOPTIONS ASMUSERsys@asm, ASMPASSWORD grid sysdba
TRANLOGOPTIONS DBLOGREADER
TRANLOGOPTIONS DBLOGREADERBUFSIZE 1048576
EXTTRAIL /u01/app/oracle/ggs/dirdat/trail/cc
TABLE gis_test.*;

GGSCI (oggmiddle) 8> add extract pump_mid, EXTTRAILSOURCE /u01/app/oracle/ggs/dirdat/trail/cc
EXTRACT added.

GGSCI (oggmiddle) 9> add RMTTRAIL C:\app\oracle\ggs\dirdat\mid\mm, extract pump_mid
RMTTRAIL added.

edit params pump_mid

EXTRACT pump_mid
USERID ggs@dbking, PASSWORD ggs
RMTHOST 10.23.5.155, MGRPORT 7809
RMTTRAIL C:\app\oracle\ggs\dirdat\mid\mm
PASSTHRU
TABLE gis_test.*;

目标端：
alter database add supplemental log data;
alter system switch logfile;

create tablespace ggs datafile 'C:\APP\ORACLE\ORADATA\WINTEST\GGS01.DBF'
size 100M
autoextend on
maxsize 1024M
extent management local
uniform. size 128k
segment space management auto;
create user ggs identified by ggs default tablespace ggs

grant create session,alter session to ggs;
grant resource to ggs;
grant connect to ggs;
grant select any dictionary to ggs;
grant select any table to ggs;
grant insert any table to ggs;
grant update any table to ggs;
grant delete any table to ggs;
grant create table to ggs;
grant dba to ggs;

c:\app\oracle\ggs\dirdat\win\

GGSCI (primary) 3> create subdirs

PORT 7809
DYNAMICPORTLIST 7810-7820, 7830
AUTOSTART REPLICAT *
AUTORESTART REPLICAT *, RETRIES 4, WAITMINUTES 4
STARTUPVALIDATIONDELAY 5
PURGEOLDEXTRACTS c:\app\oracle\ggs\dirdat\win\ww*, USECHECKPOINTS, MINKEEPDAYS 5

GGSCI (primary) 15> dblogin userid ggs,password ggs
Successfully logged into database.
GGSCI (primary) 16> add CHECKPOINTTABLE ggs.GGS_CHECKPOINT
Successfully created checkpoint table GGS.GGS_CHECKPOINT.

GGSCI (primary) 17> EDIT PARAMS ./GLOBALS
CHECKPOINTTABLE ggs.GGS_CHECKPOINT

GGSCI (pc-ggs) 22> add REPLICAT rep_mid, EXTTRAIL c:\app\oracle\ggs\dirdat\mid\m
m, CHECKPOINTTABLE ggs.GGS_CHECKPOINT
REPLICAT added.

GGSCI (primary) 24> edit params rep_mid
REPLICAT rep_mid
ASSUMETARGETDEFS
DISCARDFILE c:\app\oracle\ggs\dirrpt\discard\rep.dsc, APPEND
USERID ggs, PASSWORD ggs
MAP gis_test.*, TARGET gis_test.*;

ITPub博客

golendgate（27）

最新文章