没有合适的资源？快使用搜索试试~ 我知道了~

首页Oracle GoldenGate入门指南：10.4版实战实验详解

Oracle GoldenGate入门指南：10.4版实战实验详解

oracle

goldengate

需积分: 9 4 下载量 107 浏览量更新于2024-07-23 收藏 493KB PDF 举报

身份认证购VIP最低享 7 折!

领优惠券(最高得80元）

试读

77页

Oracle GoldenGate Fundamentals for Oracle to Oracle, Version 10.4 是Oracle公司推出的一份全面的学习手册，旨在帮助初学者理解和掌握Oracle GoldenGate这款数据集成解决方案。作为Oracle的重要工具，它专为在两个Oracle数据库系统之间实时或批量传输数据而设计，支持高可用性和灾备场景。这份文档详细介绍了GoldenGate的基础概念、安装配置、数据复制流程、事务同步、日志处理以及错误管理和监控等方面。对于初学者来说，该指南提供了一种实践导向的学习路径，通过一步步的实验和实例，读者可以深入理解如何设置源端和目标端环境，配置数据传输规则，并确保数据一致性。它涵盖了 GoldenGate 的关键组件，如 GGSCI（GoldenGate Standalone Console Interface）和GGDB（GoldenGate Database），以及高级特性如动态改变的复制策略和故障恢复机制。值得注意的是，该手册强调了版权和许可限制，明确指出未经授权的复制、修改、分发等行为都是禁止的，除非符合用户许可证协议或法律规定。同时，由于软件更新频繁，手册中的信息可能会随时更改，因此读者在使用时应保持最新的版本，并及时报告发现的任何错误。对于那些在美国政府机构或其代理者手中获取此软件的人来说，还应注意美国联邦政府的特定权利条款，这可能涉及到软件使用、分发和维护的额外法规。 Oracle GoldenGate Fundamentals for Oracle to Oracle, Version 10.4 是一个宝贵的资源，无论是用于个人学习还是企业培训，都能为学习者提供强大的工具和技术支持，帮助他们在实际环境中高效地管理和优化数据流。

资源详情

资源推荐

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

Source

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页未读，继续阅读

粉丝: 0
资源: 1

上传资源快速赚钱

我的内容管理展开

我的资源快来上传第一个资源

我的收益

登录查看自己的收益

我的积分登录查看自己的积分

我的C币登录后查看C币余额

我的收藏

我的下载

下载帮助

Oracle GoldenGate入门指南：10.4版实战实验详解

Oracle-GoldenGate技术培训(公司内部培训)

OGG实验文档，百分百成功版本！

oracle ogg在线配置,Oracle OGG配置

ogg同步Kafka到oracle,ORACLE OGG同步到KAFKA

oracle 19c ogg安装布署

oracle11g 安装ogg

ogg mysql 文档

android:mimetype ogg

oracle ogg 丢数据

linux系统中 如何启用ogg进程

oracle ogg同步原理

ogg 触发器 数据同步

如何搭建ogg

ogggit 和 ogg 版本

OGG实现MySQL实时同步

ogg for bigdata csdn

Oracle ogg-00664

ogg big data window

ogg跨平台迁移oracle 11g

qsound播放.ogg

最新资源

linux系统中如何启用ogg进程

ogg 触发器数据同步