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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/31324783/viewspace-2139169/