Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

[goldengate] official document notes 4 Oracle GoldenGate real-time data distribution

2025-01-28 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

Data distribution configuration is an one-to-many configuration scheme. OGG supports synchronizing source libraries to multiple target systems.

Considerations for data distribution configuration:

If the delivery process (data pump) finds a failure in the network connection of the target library during the data transmission, the captured data will continue to be sent like other targets. On the source side, an initial extraction group (extractgroup) and a delivery group (data pump extractgroup) are used to correspond to multiple target databases.

Create a data distribution structure

Source-end system

Configuration management process

1. Configure the management process on the source side. See [goldengate] official documentation Note 1.

Http://blog.itpub.net/29047826/viewspace-1249506/

2. In the management process parameter file, use the PURGEOLDEXTRACTS parameter to control the cleanup of the local trail file.

Configure the primary extraction process

3. On the source side, use the ADD EXTRACT command to create a primary extraction group. Here we call it ext.

ADD EXTRACT, {TRANLOG | INTEGRATED TRANLOG}, BEGIN, [, THREADS]

4, on the source side, use the ADD EXTTRAIL command to create a local trail

ADD EXTTRAIL, EXTRACT

Use the parameter EXTRACT to link the extraction group ext and trail. The extraction group writes the information to the trail, and the delivery group reads from the trail.

5. On the source side, use the EDIT PARAMS command to create a parameter file for the primary extraction group.

-- Identify the Extract group:EXTRACT

-- Specify database login information as needed for the database:

[SOURCEDB] [, USERID] [, PASSWORD []]

-- Specify the local trail that this Extract writes to

-

-and encryption options:

ENCRYPTTRAIL EXTTRAIL

-- Specify tables to be captured:

TABLE.

EXTTRAIL is used to specify the local trail configuration data pump delivery group

On the source side, use the ADD EXTRACT command to create a data pump for each target system. Here we call it pump_1,pump2.

ADD EXTRACT, EXTTRAILSOURCE, BEGIN

ADD EXTRACT, EXTTRAILSOURCE, BEGIN

The EXTRACT parameter is used to connect the remote trail to different delivery groups. The specified delivery group writes the information to the corresponding trail file.

8. On the source side, use the EDIT PARAMS command to create a parameter file for each data pump extraction group.

Data pump_1

-- Identify the data pump group:

EXTRACT

-- Specify database login information if using NOPASSTHRU:

[SOURCEDB] [, USERID] [, PASSWORD []]

-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL

-- Specify the name or IP address of the first target system

-- and optional encryption of data over TCP/IP:

RMTHOST, MGRPORT, ENCRYPT

-- Specify remote trail and encryption options on first target system:

ENCRYPTTRAIL

RMTTRAIL

-Allow mapping, filtering, conversion or pass data through as-is:

[PASSTHRU | NOPASSTHRU]

-- Specify tables to be captured:

TABLE.

Data pump_2

-- Identify the data pump group:

EXTRACT-Specify database login information if using NOPASSTHRU:

[SOURCEDB] [, USERID] [, PASSWORD []]

-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL

-- Specify the name or IP address of the second target system

-- and optional encryption of data over TCP/IP:

RMTHOST, MGRPORT, ENCRYPT

-- Specify remote trail and encryption options on second target system:

ENCRYPTTRAIL RMTTRAIL

-Allow mapping, filtering, conversion or pass data through as-is:

[PASSTHRU | NOPASSTHRU]

-- Specify tables to be captured:

TABLE.

Target system

Configuration management process

9. Configure the management process on the source side. See [goldengate] official documentation Note 1.

Http://blog.itpub.net/29047826/viewspace-1249506/

10. In the management process parameter file, use the PURGEOLDEXTRACTS parameter to control the cleanup of the local trail file.

Configure replication group

11, create a replication checkpoint table (Replicat checkpoint table) separately on each target system

12. On each target system, use the ADD REPLICAT command to create a replication group (Replicat group) for trail on each remote system. Here we call it rep_1,rep_2.

Target_1

ADD REPLICAT, EXTTRAIL, BEGIN

Target_2

ADD REPLICAT, EXTTRAIL, BEGIN

The EXTTRAIL parameter is used to connect the replication group to the correct trail. 13. On each target system, use the EDIT PARMAS command to create an extraction group parameter file.

Target_1

-- Identify the Replicat group:

REPLICAT

-- State whether or not source and target definitions are identical:

SOURCEDEFS | ASSUMETARGETDEFS

-- Specify database login information as needed for the database:

[TARGETDB] [, USERID] [, PASSWORD []]

-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL

-- Specify error handling rules:

REPERROR (,)

-- Specify tables for delivery:

MAP., TARGET. [, DEF]

Target_2

-- Identify the Replicat group:

REPLICAT

-- State whether or not source and target definitions are identical:

SOURCEDEFS | ASSUMETARGETDEFS

-- Specify database login information as needed for the database:

[TARGETDB] [, USERID] [, PASSWORD []]

-- Specify decryption options if input trail is encrypted.DECRYPTTRAIL

-Specify error handling rules:REPERROR (,)

-- Specify tables for delivery:

MAP., TARGET. [, DEF]

You can use multiple MAP statements for replication groups. These MAP statements must specify the objects contained in the same trail connected to the group.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report