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

This article will explain in detail how to use GoldenGate in ORACLE. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

1: data synchronization failed, resulting in multiple files not being copied

Handling method:

GGSCI (dbslave as ogg_owner@lcamdb) 38 > info RLCAM001

REPLICAT RLCAM001 Last Started 2018-09-29 20:40 Status stopped

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

Process ID 12371

Log Read Checkpoint File / u01/ogg/dirdat/ps000000011

2018-09-30 09 RBA 13 purl 28.884577 RBA 3025

Check the currently synchronized extseqno and advance this serial number

Alter rlcam001 extseqno 8 extrba 000

Start rlcam001 nofilterduptransactions

Make sure to start copying again from the first few files.

2: an error caused the OGG R process to fail to start.

An error was reported. A data European synchronization failed.

ON oci Error ora-01843 not a valid month (status = 1843)

Info rlcam001

Status abended

Error ogg-01296 Error mapping for lcam_sc.** to *

Reading / data/xxx/ogg/sz/zc000000087668,current rba 4399875

Can be analyzed, the secondary problem is caused by a piece of data, and you can check out this data, and then synchronize the data manually, and then need to jump this data to synchronize after synchronization.

Here, we need to use the logdump tool for file analysis.

1: go to the installation directory of ogg and execute

Logdump

Logdump 1 > GHDR ON

The record header contains some auxiliary information corresponding to class I, such as operation type, time, etc.

Logdump 2 > DETAIL ON

When this switch is turned on, the field serial number and ASCII value corresponding to the data are displayed.

Logdump 3 > open file_name

Open the current synchronized file path

Open / data/xxx/ogg/sz/zc000000087668

Logdump 4 > N can see the current properties

View the end location of the transaction

Logdump 5 > SCANFORENDTRANS

Jump to the specified RBA location

Logdump 6 > POS RBA-4399875

Logdump 7 > N

You can see the next RBA number. So when synchronizing, directly specify RBA to synchronize.

Alter replicat RLCAM001, extrba *

Or the start process name skiptransaction. This is also possible.

This is the end of the article on "how to use GoldenGate in ORACLE". 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.