Redo Corruption Errors During Redo Transport (Doc ID 386417.1)

Symptoms

When shipping redo to a standby database, the following errors are reported in the primary alert.log:

Tue Aug 1 13:01:11 2006
ARC0: I/O error 272 archiving log 3 to 'STANDBY'
Tue Aug 1 13:01:11 2006
Errors in file /<PATH>/<FILE_NAME>.trc:
ORA-00272: error writing archive log
Tue Aug 1 13:01:25 2006
ARC0: Completed archiving log 3 thread 1 sequence 11333
Tue Aug 1 13:06:46 2006
ARC1: Begin FAL archive (thread 1 sequence 11327 destination STANDBY
Creating archive destination LOG_ARCHIVE_DEST_2: 'STANDBY'
Tue Aug 1 13:06:47 2006
Errors in file /<PATH>/<FILE_NAME>.trc:
ORA-03114: not connected to ORACLE
ARC1: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing

 

The ORA-272 occurs whether using ARCH or LGWR mode of redo transport and during FAL service requests.

On the standby side, one or both of the following types of errors may be reported by RFS:

Error #1:
--------------
Tue Aug 1 13:00:44 2006
Errors in file /<PATH>/<FILE_NAME>.trc:
ORA-00600: internal error code, arguments: [kcrrrfswda.6], [4], [], [], [], [] , [], []
< snip text >
Tue Aug 1 13:00:46 2006
Errors in file /<PATH>/<FILE_NAME>.trc:
ORA-00367: checksum error in log file header
ORA-00311: cannot read header from archived log
ORA-00334: archived log: '/<PATH>/<FILE_NAME>.arch'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
SVR4 Error: 2: No such file or directory
Additional information: 1



Error #2:
-----------------
Tue Aug 1 13:00:46 2006
Errors in file /<PATH>/<FILE_NAME>.trc:
RFS: Possible network disconnect with primary database
< snip text >
Tue Aug 1 13:00:46 2006
Errors in file /<PATH>/<FILE_NAME>.trc:
ORA-00367: checksum error in log file header
ORA-00311: cannot read header from archived log
ORA-00334: archived log: '/<PATH>/<FILE_NAME>.arch'
ORA-27091: skgfqio: unable to queue I/O
ORA-27072: skgfdisp: I/O error
SVR4 Error: 2: No such file or directory
Additional information: 1
ORA-12592: TNS:bad packet

 

Changes

A firewall has been added to the network between the primary and standby sites or already exists.  The firewall may be Cisco-based and have a feature called 'fixup' enabled which may or may not be configured fully.

Database auditing may have also been enabled or is currently in use per the initialization parameter AUDIT_TRAIL.

Cause

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