灌溉梦想,记录脚步
« »
2013 年 03 月 19 日技术合集

GoldenGate 11g 简要配置步骤

描述:源端和目标端为Oracle 10gR2数据库,将scott数据库导出,在源端与目标端新增test用户,并导入scott的逻辑备份,来实现两个数据库之间test下数据同步。两个数据库的实例均为db01。

— scott 资源导入导出命令
expdp scott/tiger schemas=scott dumpfile=scott.dmp directory=backup;
impdp scott/tiger schemas=scott dumpfile=scott.dmp directory=backup;

— 创建GoldenGate用户并授权(S&T)
CREATE USER ogg IDENTIFIED BY ogg
DEFAULT TABLESPACE “USERS”
TEMPORARY TABLESPACE “TEMP”;

GRANT “DBA” TO ogg ;

— 创建数据库用户并授权(S&T)
CREATE USER test IDENTIFIED BY welcome
DEFAULT TABLESPACE “EXAMPLE”
TEMPORARY TABLESPACE “TEMP”;

GRANT “DBA” TO test ;

— 导入scott到test中(S&T)
impdp test/welcome remap_schema=scott:test dumpfile=scott.dmp directory=backup;

— 检查附加日志并打开(S&T)

SQL> archive log list;
SQL> alter database add supplemental log data;
SQL> alter system archive log current;
SQL> alter database force logging;
SQL> select log_mode,supplemental_log_data_min,force_logging from v$database;

LOG_MODE SUPPLEME FOR
———— ——– —
ARCHIVELOG YES YES

— 环境变量 (S&T)
export GG_HOME=/opt/ggs

— 创建目录(S&T)

GGSCI > create subdirs

Creating subdirectories under current directory /opt/ggs

Parameter files /opt/ggs/dirprm: already exists
Report files /opt/ggs/dirrpt: created
Checkpoint files /opt/ggs/dirchk: created
Process status files /opt/ggs/dirpcs: created
SQL script files /opt/ggs/dirsql: created
Database definitions files /opt/ggs/dirdef: created
Extract data files /opt/ggs/dirdat: created
Temporary files /opt/ggs/dirtmp: created
Stdout files /opt/ggs/dirout: created

— 配置并启动MGR
GGSCI > view params mgr

port 7809

GGSCI > start mgr

— 创建抽取进程(S)
GGSCI > dblogin userid ogg,password ogg
GGSCI > add extract ext1,tranlog,begin now
GGSCI > add exttrail /opt/ggs/dirdat/ke, extract ext1 
GGSCI > view params ext1

extract ext1
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
userid ogg@db01,password ogg
exttrail /opt/ggs/dirdat/ke
dynamicresolution
table test.*;

— 创建投递进程(S)
GGSCI > dblogin userid ogg,password ogg
GGSCI > add extract exp1,exttrailsource /opt/ggs/dirdat/ke, begin now 
GGSCI > add rmttrail /opt/ggs/dirdat/ke, extract exp1 
GGSCI > view params exp1

extract exp1
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
rmthost 192.168.56.13, mgrport 7809
rmttrail /opt/ggs/dirdat/ke
passthru
table test.*;

— 创建写入进程(T)
GGSCI > dblogin userid ogg,password ogg
GGSCI > add checkpointtable ogg.checkpointtable
GGSCI > add replicat rep1,exttrail /opt/ggs/dirdat/ke,checkpointtable ogg.CHECKPOINTTABLE
GGSCI > view params rep1

replicat rep1
setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)
assumetargetdefs
userid ogg@db01,password ogg
discardfile ./dirrpt/rep1.dsc,purge
map test.*, target test.*;

— 启动各进程
GGSCI > start ext1
GGSCI > start exp1
GGSCI > start rep1

日志信息 »

该日志于2013-03-19 16:15由 kevin 发表在技术合集分类下, 你可以发表评论。除了可以将这个日志以保留源地址及作者的情况下引用到你的网站或博客,还可以通过RSS 2.0订阅这个日志的所有评论。

没有评论

发表评论 »

要发表评论,您必须先登录