oracle+ogg支持10g,ogg表级复制--10g到12c pdb数据库

ogg 搭建过程

环境

node1:源端

redhat 5.6  Oracle 10.0.2.1  host:192.168.56.56

goldengate: 121200_fbo_ggs_Linux_x64_shiphome.zip

node2:目标端

redhat 6.5  oracle 12.0.2.1  host:192.168.56.33

goldengate: 121200_fbo_ggs_Linux_x64_shiphome.zip

1、安装软件---(图形化安装，静默安装)(源库和目标库)

解压文件

unzip 121200_fbo_ggs_Linux_x64_shiphome.zip

vi oggcore.rsp

INSTALL_OPTION=ORA11g

SOFTWARE_LOCATION=/u01/ogg

START_MANAGER=false

INVENTORY_LOCATION=/u01/app/oraInventory

UNIX_GROUP_NAME=oinstall

./runInstaller -silent -responseFile /home/oracle/fbo_ggs_Linux_x64_shiphome/Disk1/oggcore.rsp

2、

源数据库配置

需要配置环境变量

export LIBPATH=$ORACLE_HOME/lib

SQL> select NAME,LOG_MODE,FORCE_LOGGING,SUPPLEMENTAL_LOG_DATA_MIN from v$database;

开启强制写日志

alter database force logging;

打开附加日志

Alter databaseadd supplemental log data;

SQL> show parameter recy    (oracle10g ogg需要禁用，oracle11g ogg不要求)

alter system set recyclebin=off scope=spfile;

创建ogg用户

CREATE USER ogg IDENTIFIED BY ogg DEFAULT TABLESPACE users;

赋权

GRANT CONNECT TO ogg;

GRANT CREATE SESSION TO ogg;

GRANT ALTER SESSION TO ogg;

GRANT RESOURCE TO ogg;

GRANT SELECT ANY DICTIONARY TO ogg;

GRANT SELECT ANY TABLE TO ogg;

GRANT FLASHBACK ANY TABLE TO ogg;

GRANT ALTER ANY TABLE TO ogg;

创建相关目录

GGSCI (prod) 11> create subdirs

配置mgr管理进程

GGSCI (prod) 11> edit params mgr

---加入

PORT 7809

GGSCI (prod) 11> start mgr

添加表级transdata

GGSCI (prod) 11> dblogin userid ogg,password ogg

GGSCI (prod) 11> add trandata  scott.emp1

配置抽取进程：

add extract ext_demo, tranlog, begin now, threads 1

设置队列

add exttrail ./dirdat/r1,extract EXTNEW,megabytes 10

编辑

GGSCI (prod) 11> edit params ext_demo

--加入

EXTRACT ext_demo

setenv (ORACLE_SID=sqms)

setenv (NLS_LANG=AMERICAN_AMERICA.ZHS16GBK)

userid ogg,password ogg

DISCARDROLLOVER AT 3:00

exttrail ./dirdat/r1,megabytes 10

dynamicresolution

TABLE SCOTT.EMP1;

配置传播进程

add extract dp_demo, exttrailsource ./dirdat/r1, begin now

设置队列

ADD RMTTRAIL ./dirdat/ta, EXTRACT dp_demo, MEGABYTES 10

GGSCI (prod) 11> edit params dp_demo

--加入

EXTRACT dp_demo

PASSTHRU

RMTHOST 192.168.56.33, MGRPORT 7809

RMTTRAIL ./dirdat/ta

TABLE scott.EMP1;

开启相关

GGSCI (prod) 11>start *

查看状态

GGSCI (prod) 11>

3、目标数据库设置

ORA12CR2PDB创建相关表

创建管理用户

create user c##ogg identified by ogg;

赋予相关权限

赋予

grant set container to c##ogg container=all;

grant dba to c##ogg container=all;

alter system set enable_goldengate_replication=true;

exec dbms_goldengate_auth.grant_admin_privilege('C##OGG','APPLY',container=>'ORA12CR2PDB');

查看权限

select privilege from dba_sys_privs where grantee = 'C##OGG';

配置pdb连接

在tns加入

ora12cr2pdb =

(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.33)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = ora12cr2pdb)

)

)

创建相关目录

GGSCI (prod) 11> create subdirs

配置mgr管理进程

GGSCI (prod) 11> edit params mgr

---加入

PORT 7809

GGSCI (prod) 11> start mgr

创新检查点表

GGSCI (prod) 11> dblogin userid c##ogg,password ogg

GGSCI (prod) 11> add checkpointtable c##ogg.checkpoint

------add checkpointtable ora12cr2pdb.c##ogg.checkpoint

添加应用进程

add replicat rep_demo, exttrail ./dirdat/ta,begin now, checkpointtable c##ogg.checkpoint

edit params rep_demo

加入

REPLICAT rep_demo

SETENV(ORACLE_SID='ORA12CR2PDB')

USERID c##ogg@ora12cr2pdb, password ogg

ALLOWNOOPUPDATES

ASSUMETARGETDEFS

MAP scott.emp1, TARGET hr.emp1;

开启相关

GGSCI (prod) 11>start *

查看状态

GGSCI (prod) 11>info all

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/31324783/viewspace-2139169/，如需转载，请注明出处，否则将追究法律责任。