Potential Lost Writes: RAC on NAS using NFS may not use DIRECTIO or HP on NFS
Last updated on MAY 13, 2013
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206 to 10.2.0.4
- When RAC is used, O_DIRECT is the default option to open files in NFS. However, there are some cases where O_DIRECT is not used and the database may lose a write. For this case the NFS mount point options are in accordance with <
- There is another case that is specific to HP when NFS is used without the forcedirectio IO option where the database may end up losing IO.
- Lost IO may cause different errors like:
ORA-600  in a media recovery
ORA-1499 on "analyze table validate structure cascade"
ORA-8102 on delete/update
- Some of these errors are signs of logical corruptions on undo segments, redo log files and inconsistencies between tables and indexes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms