没有合适的资源?快使用搜索试试~ 我知道了~
首页Oracle GoldenGate 10.4 实验室:从基础到高级功能
Oracle GoldenGate 10.4 实验室:从基础到高级功能
需积分: 13 1 下载量 95 浏览量
更新于2024-07-28
收藏 245KB PDF 举报
Oracle GoldenGate实验室是一个专注于Oracle数据库间数据复制和同步的强大工具,它在Oracle Version 10.4中得到了广泛的应用。Oracle GoldenGate Fundamentals for Oracle to Oracle, 版本10.4,是该技术的基础文档,由Oracle公司于2009年10月发布。此版本的软件及其相关文档受到严格的版权保护,只能在许可协议规定的范围内使用,包括但不限于使用、复制、翻译、传播等行为。未经明确授权或法律规定,用户不得进行逆向工程、解码或反编译操作。 Oracle GoldenGate的核心功能包括实时数据复制,能够实现实时或准实时的数据传输,确保在多个Oracle数据库之间的一致性和可靠性。这对于企业级应用中的数据集成、灾备恢复、高可用性系统以及全球业务运营具有重要意义。版本10.4可能包含对Oracle数据库架构、数据模型、数据传输技术以及故障处理机制的详细介绍,有助于用户理解和配置GoldenGate服务。 该文档还强调了信息的时效性,指出其中的内容可能随时更改,并且不保证无误。用户在使用过程中如果发现错误,应通过书面方式向Oracle公司报告。对于美国政府用户或代表政府获取并使用该软件的情况,文档中还提到了相关的政府权利条款,表明其在特定法规约束下使用。 Oracle GoldenGate实验室是一个高度专业化的解决方案,旨在帮助企业和政府机构高效、安全地管理跨Oracle数据库的数据流动,确保数据的一致性和业务连续性。学习和掌握这个平台的知识,对于数据库管理员、数据分析师和IT专业人员来说,是提升数据管理能力的关键一步。
资源详情
资源推荐
GoldenGate for Oracle to Oracle
Page 13
source and target tables are created and loaded with initial data. The GoldenGate
Manager processes are also started so that other processes may be configured and
started.
Configure Initial Data Load
To initially load data, there are techniques such as Backup/Restore or
Export/Import, both of which have pros and cons. Alternatively you may use the
GoldenGate application to perform your initial data load while the application
remains active. This lesson demonstrates using Extract to pull data from the
source tables and sending the data directly to the Replicat on the target system.
Configure Change Capture
For log-based Oracle capture, the capture process is configured to capture change
data directly from the Oracle online redo logs or archive logs and store the
changes in queues known as GoldenGate remote trails.
Configure Change Delivery
Once the tables have been initially loaded with data, the delivery process is
configured to deliver the captured change data into the target database.
<source> server
Oracle
<target> server
Oracle
Target
<owner/schema>
Source
<owner/schema>
Network
Initial
Extract
Initial
Replicat
Prepare the Environment
Page 14
Exercise 4.
Prepare the Environment
Objective
The goals of this exercise are to:
Configure and start the Manager processes
Create and load practice data to Oracle tables
Add supplemental logging
Prepare your Oracle source environment
1. Configure the Manager process on the source
On the <source> system, create the Manager parameter file and specify the port it
should use.
Create the Manager parameter file.
Shell> cd <install location>
Shell> ggsci
GGSCI> EDIT PARAMS MGR
Use the editor to assign a port.
--GoldenGate Manager parameter file
PORT <port>
Start the Manager.
GGSCI> START MGR
Verify that the Manager has started.
GGSCI> INFO MGR
2. Create the source tables and load the initial data.
Using SQL*Plus, create and populate the TCUSTMER and TCUSTORD tables by
running the
demo_ora_create.sql and demo_ora_insert.sql files found in the install
directory.
Execute the following commands on the
<source> system.
Shell> cd <install location>
Shell> sqlplus <login>/<password>
SQL> @demo_ora_create
Prepare the Environment
Page 15
SQL> @demo_ora_insert
Verify the results:
SQL> select * from tcustmer;
SQL> select * from tcustord;
SQL> exit
3. Add supplemental logging
Using GGSCI, log in to the database on the <source> and turn on supplemental
logging for the
TCUSTMER and TCUSTORD tables.
Shell> ggsci
GGSCI> DBLOGIN USERID <login>, PASSWORD <password>
GGSCI> ADD TRANDATA <owner/schema>.TCUSTMER
GGSCI> ADD TRANDATA <owner/schema>.TCUSTORD
Verify that supplemental logging has been turned on for these tables.
GGSCI> INFO TRANDATA <owner/schema>.TCUST*
Prepare your target Oracle environment
Configure the Manager
1. Configure the Manager process on the target system
Execute the following commands on the <target> system.
Start the command interface
Shell> cd <install location>
Shell> ggsci
Specify the port that the Manager should use.
GGSCI> EDIT PARAMS MGR
-- GoldenGate Manager Parameter file
PORT <port>
Start Manager
GGSCI> START MANAGER
Verify the results:
GGSCI> INFO MANAGER
Prepare the Environment
Page 16
Create the tables
2. Create target Oracle tables
Execute the following commands on the <target> system to run the script that
creates the tables.
Shell> cd <install location>
Shell> sqlplus <login>/<password>
SQL> @demo_ora_create
Verify the results:
SQL> desc tcustmer;
SQL> desc tcustord;
SQL> exit
剩余76页未读,继续阅读
junecaoic
- 粉丝: 0
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
最新资源
- Hadoop生态系统与MapReduce详解
- MDS系列三相整流桥模块技术规格与特性
- MFC编程:指针与句柄获取全面解析
- LM06:多模4G高速数据模块,支持GSM至TD-LTE
- 使用Gradle与Nexus构建私有仓库
- JAVA编程规范指南:命名规则与文件样式
- EMC VNX5500 存储系统日常维护指南
- 大数据驱动的互联网用户体验深度管理策略
- 改进型Booth算法:32位浮点阵列乘法器的高速设计与算法比较
- H3CNE网络认证重点知识整理
- Linux环境下MongoDB的详细安装教程
- 压缩文法的等价变换与多余规则删除
- BRMS入门指南:JBOSS安装与基础操作详解
- Win7环境下Android开发环境配置全攻略
- SHT10 C语言程序与LCD1602显示实例及精度校准
- 反垃圾邮件技术:现状与前景
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功