1. Oracle Solaris Cluster 4.4 Release Notes
  2. Data Services Notes
  3. Data Services Issues
  4. ORA-00742: Log Read Detects Lost Write (21186724)

ORA-00742: Log Read Detects Lost Write (21186724)

Problem Summary: When using Oracle Solaris Cluster HA for Oracle with Solaris Volume Manger (SVM) or UFS filesystem devices in an x64 cluster environment, Oracle Database log corruption might occur.

Workaround: To avoid data corruption when using SVM or UFS based file systems with HA for Oracle database, place the Oracle binaries and Oracle data on separate file systems. In Oracle data file systems, set forcedirectio in /etc/vfstab to avoid the bug. You must use forcedirectio only for the Oracle data file system, thus requiring separate file systems for Oracle binaries and Oracle data.