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

This article introduces the methods of dealing with OGG problems, the content is very detailed, interested friends can refer to, I hope it can be helpful to you.

A customer reported an OGG error in the morning.

2021-02-11 10:26:20 ERROR OGG-01416 Oracle GoldenGate Capture for Oracle, P_HYDEE.prm: File d:\ ogg\ dirdat\ et007149, with format RELEASE 9.0 take 9.5, does not match current format specification of RELEASE 11.2. Modify the parameter file to specify format RELEASE 9.0/9.5 or issue ETROLLOVER prior to restart.

2021-02-11 10:26:20 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, P_HYDEE.prm: PROCESS ABENDING.

It's easy to solve this error, alter extract xxx etrollover.

A new problem arises after the execution of the order:

2021-02-11 10:31:20 ERROR OGG-01033 Oracle GoldenGate Capture for Oracle, P_HYDEE.prm: There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is d:\ ogg\ dirdat\ et007150, reply received is Input rba past EOF for d:\ ogg\ dirdat\ et007150; input rba: 99998104; EOF rba: 98832384).

2021-02-11 10:31:20 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, P_HYDEE.prm: PROCESS ABENDING.

It took me a lot of time to check.

Finally, the operating system on the target side sees that disk D has been fully occupied and there is no disk space.

At the same time, there are a large number of warning in the ggserr.log on the target side:

2021-02-11 10:31:10 INFO OGG-01228 Oracle GoldenGate Collector for Oracle: Timeout in 300 seconds.

2021-02-110 INFO OGG-01229 Oracle GoldenGate Collector for Oracle 31 INFO OGG-01229 Oracle GoldenGate Collector for Oracle: Connected to WIN-O97S9H5BGRD:49780.

2021-02-11 10:31:15 INFO OGG-01669 Oracle GoldenGate Collector for Oracle: Opening d:\ ogg\ dirdat\ et007150 (byte-1, current EOF 0).

2021-02-11 10:31:21 WARNING OGG-01223 Oracle GoldenGate Collector for Oracle: fwrite () error 112 (insufficient disk space.) Writing to d:\ ogg\ dirdat\ et007150.

So this is understood. It is also relatively simple to clean up the target disk and free up some space.

The whole fault is roughly as follows:

On February 11th, it crashed due to a problem with the structure of the table, and then no one from the customer checked and noticed.

2021-02-11 17:15:43 ERROR OGG-01161 Oracle GoldenGate Delivery for Oracle, R_*.prm: Bad column index (124) specified for table *, max columns = 124.

2021-02-11 17:15:43 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, R_HYDEE.prm: PROCESS ABENDING.

This in turn causes the target trail file to be deleted consistently (the mgr process is configured as follows)

Port 7500

AUTOSTART ER *

AUTORESTART EXTRACT *, RETRIES 3 Magic WAITMINUTES 5 Jet RESETMINUTES 60

Dynamicportlist 7501-7505

Autorestart extract *, waitminutes 2 dint retries 5

Purgeoldextracts.\ dirdat\ et*,usecheckpoints,minkeepdays 2

The trail file cannot be deleted, resulting in insufficient disk space, resulting in an error when the pump process on the source side writes the trail file to the destination side, causing the pump process to crash

On the OGG problem handling methods to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can 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.