- 浏览: 4370118 次
- 性别:
- 来自: 厦门
文章分类
- 全部博客 (634)
- Oracle日常管理 (142)
- Oracle体系架构 (45)
- Oracle Tuning (52)
- Oracle故障诊断 (35)
- RAC/DG/OGG (64)
- Oracle11g New Features (48)
- DataWarehouse (15)
- SQL, PL/SQL (14)
- DB2日常管理 (9)
- Weblogic (11)
- Shell (19)
- AIX (12)
- Linux/Unix高可用性 (11)
- Linux/Unix日常管理 (66)
- Linux桌面应用 (37)
- Windows (2)
- 生活和工作 (13)
- 私人记事 (0)
- Python (9)
- CBO (15)
- Cognos (2)
- ORACLE 12c New Feature (2)
- PL/SQL (2)
- SQL (1)
- C++ (2)
- Hadoop大数据 (5)
- 机器学习 (3)
- 非技术 (1)
最新评论
-
di1984HIT:
xuexilee!!!
Oracle 11g R2 RAC高可用连接特性 – SCAN详解 -
aneyes123:
谢谢非常有用那
PL/SQL的存储过程和函数(原创) -
jcjcjc:
写的很详细
Oracle中Hint深入理解(原创) -
di1984HIT:
学习了,学习了
Linux NTP配置详解 (Network Time Protocol) -
avalonzst:
大写的赞..
AIX内存概述(原创)
系统环境
源端:
OS: Oracle Linux 5.4 32-bit
DB: Oracle Database 10gR2(10.2.0.1)
IP: 192.168.0.111
同步表名: scott.tcustmer,scott.tcustord
目标端:
OS: Oracle Linux 5.4 32-bit
DB: Oracle Database 10gR2(10.2.0.1)
IP: 192.168.0.113
同步表: scott.gg_test
复制架构图
安装GoldenGate
源端:将数据库设为Archive Mode,安装之前需要打开Oracle的supplemental log。目标端不需要此操作
SQL> archive log list
DATABASE log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log SEQUENCE 7
NEXT log SEQUENCE TO archive 9
CURRENT log SEQUENCE 9
SQL> ALTER DATABASE ADD supplemental log DATA;
DATABASE altered.
SQL> ALTER system switch logfile;
System altered.
SQL> select SUPPLEMENTAL_LOG_DATA_MIN from v$database
SUPPLEME
--------
YES
注:SUPPLEMENTAL_LOG_DATA_MIN值为implicit亦可
查看源端ogg版本
$ ggsci -v
Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:06:02
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
源端和目标端安装goldengate。
创建源端和目标端ogg目录
GGSCI (rac) 1> CREATE SUBDIRS
Creating subdirectories under current directory /home/oracle/ggs
Parameter files /home/oracle/ggs/dirprm: created
Report files /home/oracle/ggs/dirrpt: created
Checkpoint files /home/oracle/ggs/dirchk: created
Process status files /home/oracle/ggs/dirpcs: created
SQL script. files /home/oracle/ggs/dirsql: created
Database definitions files /home/oracle/ggs/dirdef: created
Extract data files /home/oracle/ggs/dirdat: created
Temporary files /home/oracle/ggs/dirtmp: created
Veridata files /home/oracle/ggs/dirver: created
Veridata Lock files /home/oracle/ggs/dirver/lock: created
Veridata Out-Of-Sync files /home/oracle/ggs/dirver/oos: created
Veridata Out-Of-Sync XML files /home/oracle/ggs/dirver/oosxml: created
Veridata Parameter files /home/oracle/ggs/dirver/params: created
Veridata Report files /home/oracle/ggs/dirver/report: created
Veridata Status files /home/oracle/ggs/dirver/status: created
Veridata Trace files /home/oracle/ggs/dirver/trace: created
Stdout files /home/oracle/ggs/dirout: created
配置goldengate
创建goldengate管理用户
源端:创建goldengate管理用户,并赋予适当权限
SQL>Create user ggs identified by ggs;
SQL>GRANT CONNECT TO ggs;
SQL>GRANT ALTER ANY TABLE TO ggs;
SQL>GRANT ALTER SESSION TO ggs;
SQL>GRANT CREATE SESSION TO ggs;
SQL>GRANT FLASHBACK ANY TABLE TO ggs;
SQL>GRANT SELECT ANY DICTIONARY TO ggs;
SQL>GRANT SELECT ANY TABLE TO ggs;
SQL>GRANT RESOURCE TO ggs;
SQL>GRANT drop ANY TABLE TO ggs;
SQL>GRANT delete any table TO ggs;
SQL>GRANT execute on utl_fileE TO ggs;
SQL>GRANT execute on dbms_flashback TO ggs;
SQL>GRANT unlimited tablespace TO ggs;
SQL>Create user ggs identified by ggs;
SQL>GRANT CONNECT TO ggs;
SQL>GRANT ALTER ANY TABLE TO ggs;
SQL>GRANT ALTER SESSION TO ggs;
SQL>GRANT CREATE SESSION TO ggs;
SQL>GRANT update any table TO ggs;
SQL>GRANT SELECT ANY DICTIONARY TO ggs;
SQL>GRANT SELECT ANY TABLE TO ggs;
SQL>GRANT RESOURCE TO ggs;
SQL>GRANT drop ANY TABLE TO ggs;
SQL>GRANT delete any table TO ggs;
SQL>GRANT execute on utl_fileE TO ggs;
SQL>GRANT insert any table TO ggs;
SQL>GRANT unlimited tablespace TO ggs;
配置mgr
源端:创建编辑manager参数文件,PORT为7500,保存退出。
$ ggsci
Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct 4 2011 23:54:06
Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.
GGSCI (rac1) 1> EDIT PARAMS MGR
GGSCI (rac1) 6> view params mgr
port 7500
dynamicportlist 7500-7505
autorestart extract *,waitminutes 2 ,retries 5
GGSCI (rac1) 4> START MGR
Manager started.
其中port参数标示mgr进程通信的端口,是配置mgr进程必须的。dynamicportlist(可选),表示manager进程可以为源端和目标端的动态通信时采用的动态端口。autorestart(可选),表示如果extract进程失败,则每隔2分钟尝试重启一次,最多重启5次。默认为2分钟重启一次。
查看manager进程
$ ps -ef|grep mgr|grep -v grep
oracle 5277 1 0 10:12 ? 00:00:56 ./mgr PARAMFILE /home/oracle/ggs/dirprm/mgr.prm REPORTFILE /home/oracle/ggs/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
目标端:创建编辑manager参数文件,PORT为7500,保存退出。$ ggsci
Oracle GoldenGate Command Interpreter FOR Oracle
Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100
Solaris, x64, 64bit (optimized), Oracle 11g ON Oct 4 2011 23:54:06
Copyright (C) 1995, 2011, Oracle AND/OR its affiliates. ALL rights reserved.
GGSCI (rac1) 1> EDIT PARAMS MGR
GGSCI (rac1) 6> view params mgr
port 7500
dynamicportlist 7500-7505
autorestart extract *,waitminutes 2 ,retries 5
GGSCI (rac1) 4> START MGR
Manager started.
查看manager进程
$ ps -ef|grep mgr|grep -v grep
oracle 5277 1 0 10:12 ? 00:00:56 ./mgr PARAMFILE /home/oracle/ggs/dirprm/mgr.prm REPORTFILE /home/oracle/ggs/dirrpt/MGR.rpt PROCESSID MGR PORT 7809
源端:
配置extract进程
源端:
启动extract进程
源端:
passthru
目标端:
GGSCI (rac2) 146> edit params ./GLOBALS
GGSCI (rac2) 147> view params ./GLOBALS
checkpointtable scott.checkczm
GGSCI (rac2) 149> add checkpointtable
No checkpoint table specified, using GLOBALS specification (ggs.checkczm)...
Successfully created checkpoint table ggs.checkczm.
配置复制进程
目标端
配置复制进程
启动复制进程
源端:
目标端:
参考至:《GoldenGate Windows and UNIX Reference Guide 11g Release 2 Patch Set 1》
http://www.code365.org/?p=1594
如有错误,欢迎指正
邮箱:czmcj@163.com
发表评论
-
Duplicate a Database Using RMAN in Oracle Database 11g Release 2
2016-11-03 15:38 936Duplicate a Database Using RMA ... -
grid control 安装总结 (三)之EMD upload error: uploadXMLFiles skipped或忘记OMS密码
2014-11-17 17:16 2767[oracle@anbob agent10g]$ bin/e ... -
Grid Control服务端看不到Agent相关信息,同时OMS状态为unknown处理
2014-11-17 17:14 2145一次Grid Control的agent是启动的,但是在GC ... -
给11gR2 RAC添加LISTENER监听器并静态注册
2014-10-22 17:52 3152之前有同学想要给11gR2的RAC添加LISTENER监听器 ... -
HOW TO REMOVE CRS AUTO START AND RESTART FOR A RAC INSTANCE
2014-10-12 20:08 1460Subject: HOW TO REMOVE CRS AU ... -
How To Enable Archive Logging In RAC Environment [ID 1186764.1]
2014-10-12 19:45 1010How To Enable Archive Logging ... -
Oracle 11g RAC使用Manual和Policy Managed方法配置
2014-10-12 17:25 8853软件环境: 操作系统:Red Hat Enterpris ... -
Moving OCR and Voting Disk to Oracle ASM Online
2014-10-12 16:35 2625Prior Oracle 11gR2, it was only ... -
Oracle 11g R2的启动与关闭(原创)
2014-10-10 15:04 27181概述 Oracle 11gR2 中对CRSD资源进行了重新 ... -
重新配置与卸载11gR2 Grid Infrastructure
2014-10-10 08:24 2288概述Oracle 11g R2 Grid Infrastru ... -
Data Guard Broker Properties
2014-10-07 16:15 961Data Guard Broker Properties ... -
Data Guard - Snapshot Standby Database配置
2014-10-07 07:39 932概述一般情况下,物理standby数据库处于mount状态 ... -
Active Data Guard
2014-10-06 19:27 866Oracle Active Data Guard is a ... -
Data Guard Broker系列之六:Fast-Start Failover
2014-10-06 18:29 3063Fast-Start Failover 基本概念 Fa ... -
Data Guard Broker系列之五:数据库角色转换
2014-10-06 18:28 1226数据库转换的基本概 ... -
Data Guard Broker系列之四:数据库管理
2014-10-06 18:27 1190数据库状态管理 数据 ... -
Data Guard Broker系列之三:Data Guard Broker配置管理
2014-10-06 16:56 1257配置data guard broker配置文件基本参数 ... -
Data Guard Broker系列之二:Data Guard Broker配置实战
2014-10-05 16:16 1570配置之前DG环境状态 测试的DG环境安装在同一个机器上, ... -
Data Guard broker系列之一:Data Guard Broker基础
2014-10-05 16:13 2266Data Guard broker概览 Data ... -
Dataguard切换保护模式(从MAXIMUM PERFORMANCE 到 maximize availability)
2014-10-05 14:52 12361. 首先查看主库当前保护模式(主库操作)SQL> s ...
相关推荐
GoldenGate安装与配置 让你轻松安装和配置GoldenGate
goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置goldengate安装配置
GoldenGate安装与配置 DB2同步到Oracle;GoldenGate安装与配置 DB2同步到Oracle;
Oracle GoldenGate 安装配置详细手册
介绍了ogg的单向,双向,复制传输,DML DDL的安装配置以及排错。 主要是介绍的windows平台。
Goldengate安装配置详细说明,,GoldenGate软件提供了一个单一的平台,这个平台可以为任何企业环境实现秒一级的灾难备份。GoldenGate是一种基于日志的结构化数据复制方式,它通过解析源数据库在线日志或归档日志获得...
Oracle-GoldenGate安装、配置、管理!Oracle-GoldenGate安装、配置、管理 (1
Goldengate_安装配置,双向复制
oracle goldengate安装配置
GoldenGate安装和进程讲解-2GoldenGate安装和进程讲解-
Goldengate Director安装配置指南
GoldenGate安装配置两小时教程,对于初级入门来说应该有用。 GoldenGate安装配置 –软件下载 –操作系统准备 –数据库准备 –软件安装 –源端OGG配置 –目标端OGG配置
基于实时数据库的GoldenGate数据同步,包括GoldenGate安装配置等
GoldenGate19.1微服务版本的安装和配置,自己的实验过程。 1. 管理服务(Administration Server):配置抽取进程和复制进程。 2. 分发服务(Distribution Server):配置传输进程。 3. 接收服务(Receiver Server):接收...
详细的goldengate安装配置说明,喜欢技术的朋友可以看一看
Oracle Goldengate 11g Install and Setup Guide(Oracle Goldengate 10g 安装、配置指南 英文版)
Oracle GoldenGate安装配置.doc
Goldengate安装配置文档.pdf
测试环境中GoldenGate19.1微服务版本的安装和配置,自己的实验过程。 1. 管理服务(Administration Server):配置抽取进程和复制进程。 2. 分发服务(Distribution Server):配置传输进程。 3. 接收服务(Receiver ...
Oracle GoldenGate软件安装、配置、运维、运维管理 整理版,按照你们的要求已经降分了!