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将在后续发布。
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
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;
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
mkdir -p trail/hr
GGSCI (dbhouse) 2> create subdirs
ggsci>edit params ./GLOBALS
GGSCHEMA ggs
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
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.
Successfully logged into database.
GGSCI (oggmiddle) 4>
add EXTRACT s_ex_mid, tranlog, begin now
EXTRACT added.
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.*;
-- 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.
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.*;
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;
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
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;
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
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.
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
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.
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博客 ” ,链接:http://blog.itpub.net/21266384/viewspace-757592/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21266384/viewspace-757592/