1.121 PARTIALBLOCKRETRYSECS

Valid For

Extract and Replicat

Description

This parameter allows Oracle GoldenGate to go back and re-read a block in the event that the first time it reads the block it is bad or partial data. These types of issues are typically encountered when the incorrect NFS settings are used for trail files or redo logs.

Refer to MOS note 1232303.1 for recommended NFS settings with Oracle GoldenGate.

The default is 20 seconds, the minimum is 1 second, and this works for Extract and Replicat.

Default

PARTIALBLOCKRETRYSECS 20

Syntax

PARTIALBLOCKRETRYSECS seconds

In case of TRANLOG Extract, the seconds value applies when reading the redo logs. This applies for classic Extract only. In case of an Extract pump or Replicat, its used when reading trail files written by a TRANLOG Extract.