My Oracle Support Banner

troubleshooting corruption errors ORA-00353 ORA-00354 ORA-00355 ORA-00368 on standby database (Doc ID 2746179.1)

Last updated on FEBRUARY 07, 2021

Applies to:

Oracle Database - Enterprise Edition
Information in this document applies to any platform.

Purpose

When a standby database receives redo that is corrupted or has an invalid checksum, the recovery process or archiver will raise errors similar to the following:   

The most common causes for these errors and of receiving corrupted redo by the standby, are the firewall or a faulty network.   If there is a firewall between the primary and standby databases, make sure the following features are disabled:

              SQLNet fixup protocol
              Deep Packet Inspection (DPI)
              SQLNet packet inspection
              SQL Fixup
              SQL ALG (Juniper firewall)
              Oracle DB-control component DOS

This note will help to determine where the corruption is introduced, weather it is due to the network or somewhere else, and will collect the required diagnostics to identify the cause.  

Troubleshooting Steps

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Troubleshooting Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.