Question

Capture is getting the following error intermittently on the Oracle ASM environment:

F_JT0400: Log scanning error F_JZ1517. Non-Terminal page at block 7919201 in Redo Logfile with sequence 144748 failed CRC test. This happens at page 0 out of 1 in total.

Environment

Local Data Processing: Oracle with ASM on source

Answer

To resolve this error, please add the environment action, HVR_VASM_MODE=Batch, for the source group and run Local Data Processing initialize or activation with scripts and jobs.

Cause

Local Data Processing queries the ASM system. The queries sometimes return corrupted data. It happens when capturing stays on the boundary of the latest online redo log. It happens almost always (99% of cases) when Local Data Processing queries data for RACs node 2.

It is because node 2 is less active than node 1. Why ASM returns corrupted data is not yet known. After getting data, Local Data Processing caches it. HVR_VASM_MODE=Batch disables data caching received through the VASM interface.