Shulou(Shulou.com)05/31 Report--

This article will explain in detail how to split the extract in ogg. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

The split method of extract of ogg

0. Background

After the deployment of OGG, with the increase of business pressure, it may be necessary to add multiple group to handle data synchronization. In this case, it is necessary to split the original OGG process without causing data synchronization problems.

1. Stop the extract process

GGSCI (ogg1) 2 request; stop ext1

two。 Stop the datapump process

Here, the delivery process can not be stopped until the delivery process is completed. If the delivery process is not completed, the data will be lost.

GGSCI (ogg1) 4 collect; info dpump

EXTRACT DPUMP Last Started 2014-03-27 20:00 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:02 ago)

Process ID 20746

Log Read Checkpoint File / u01/ggs/dirdat/lt000009

2014-03-27 20 01 RBA 36.000000 000

Execute the command multiple times to check whether the rba is consistent. If the same indicates that the delivery is complete, then you can stop it.

GGSCI (ogg1) 7 collect; stop dpump

3. Record extract checkpoint

Extract checkpoints include: Recovery Checkpoint: Sequence and RBA

Current Checkpoint: Sequence and RBA

Current Checkpoint Detail:

Read Checkpoint # 1

Oracle Redo Log

Startup Checkpoint (starting position in the data source):

Thread #: 1

Sequence #: 53

RBA: 25012752

Timestamp: 2014-03-27 1914 594 0000000

SCN: 0.2085381 (2085381)

Redo File: / u01/app/oracle/oradata/dave/redo02.log

Recovery Checkpoint (position of oldest unprocessed transaction in the data source):

Thread #: 1

Sequence #: 53

RBA: 28138512

Timestamp: 2014-03-27 20 purl 10purl 52.000000

SCN: 0.2086075 (2086075)

Redo File: / u01/app/oracle/oradata/dave/redo02.log

Current Checkpoint (position of last record read in the data source):

Thread #: 1

Sequence #: 53

RBA: 28141568

Timestamp: 2014-03-27 20 purl 10purl 55.000000

SCN: 0.2086077 (2086077)

Redo File: / u01/app/oracle/oradata/dave/redo02.log

4. Modify the original corresponding parameter file and delete the split table from the parameter file

Ext1 process

Before

GGSCI (ogg1) 12 minutes; view param ext1

Extract ext1

Userid ggs@ogg1, password ggs

Exttrail / u01/ggs/dirdat/lt

Ddl include mapped objname sender.*

Table sender.*

Modified

GGSCI (ogg1) 18 install; view param ext1

Extract ext1

Userid ggs@ogg1, password ggs

Exttrail / u01/ggs/dirdat/lt

Ddl include mapped objname sender.*

Table sender.dave1

Dpump process

Before

GGSCI (ogg1) 13 get; view param dpump

Extract dpump

Userid ggs@ogg1, password ggs

Rmthost 192.168.2.62, mgrport 7809

Rmttrail / u01/ggs/dirdat/rt

Passthru

Table sender.*

Dynamicresolution

Modified

GGSCI (ogg1) 19 get; view param dpump

Extract dpump

Userid ggs@ogg1, password ggs

Rmthost 192.168.2.62, mgrport 7809

Rmttrail / u01/ggs/dirdat/rt

Passthru

Table sender.dave1

Dynamicresolution

5. Add new extract,datapump

5.1 add Extract process

GGSCI (ogg1) 22 collect; add extract ext3,tranlog, begin now

EXTRACT added.

GGSCI (ogg1) 23 install; add exttrail / u01/ggs/dirdat/E3, extract ext3

EXTTRAIL added.

5.2 modify the ext3 parameters of the extraction process:

GGSCI (ogg1) 26 collect; view param ext3

Extract ext3

Userid ggs@ogg1, password ggs

Exttrail / u01/ggs/dirdat/E3

Ddl include mapped objname sender.*

Table sender.dave2

5.3 add a Pump process

GGSCI (ogg1) 28 collect; add extract pump3,exttrailsource / u01/ggs/dirdat/E3

EXTRACT added.

GGSCI (ogg1) 29 install; add rmttrail / u01/ggs/dirdat/E3, extract pump3,megabytes 10

RMTTRAIL added.

5.4.Configuring Data Pump parameters:

GGSCI (gg1) 56 install; view params dpump

Extract pump3

Userid ggs@ogg1, password ggs

Rmthost 192.168.2.62, mgrport 7809

Rmttrail / u01/ggs/dirdat/E3

Passthru

Table sender.dave2

Dynamicresolution

6. Modify the checkpoint of a new extract process

Checkpoints are the two checkpoints recorded above: current read checkpoint and recovery checkpoint

6.1 modify current read checkpoint

GGSCI (ogg1) 34 collect; alter ext3 extseqno 53, extrba 28141568 [, thread n]

Here's the point.

EXTRACT altered.

6.2 modify recovery checkpoint

GGSCI (ogg1) 35 collect; alter ext3 ioextseqno 53, ioextrba 28138512 [, thread n]

7. Confirm that all parameter files are correct and start the process.

GGSCI (ogg1) 37 collect; start *

This is the end of the article on "how to split extract in ogg". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.

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.