Go to main content

Oracle® Solaris Cluster Data Service for Oracle Real Application Clusters Guide

Exit Print View

Updated: April 2016
 
 

Using a Cluster File System

Support for Oracle RAC is supported on two types of cluster file systems:

For information that is specific to the use of cluster file systems with Support for Oracle RAC, see the subsections that follow.

Types of Oracle Database Files That You Can Store on a PxFS-Based Cluster File System

You can store only these files that are associated with Support for Oracle RAC on a PxFS-based cluster file system:


Note -  Oracle Grid Infrastructure binaries cannot reside on a cluster file system.
  • Oracle Database RDBMS binary files

  • Oracle Database configuration files (for example, init.ora, tnsnames.ora, listener.ora, and sqlnet.ora)

  • System parameter file (SPFILE)

  • Alert files (for example, alert_sid.log)

  • Trace files (*.trc)

  • Archived redo log files

  • Flashback log files

  • Oracle Grid Infrastructure cluster registry (OCR) files

  • Oracle Grid Infrastructure voting disk


Note -  You must not store data files, control files, online redo log files, or Oracle Database recovery files on a PxFS-based cluster file system.

Types of Oracle Database Files That You Can Store on an Oracle ACFS File System

You can store only these files that are associated with Support for Oracle RAC on the Oracle ACFS file system:

  • Oracle Database RDBMS binary files

  • Oracle Database configuration files (for example, init.ora, tnsnames.ora, listener.ora, and sqlnet.ora)

  • Alert files (for example, alert_sid.log)

  • Trace files (*.trc)

  • (Starting with Oracle Database 12c) Data files

  • (Starting with Oracle Database 12c) Control files

  • (Starting with Oracle Database 12c) Online redo log files

  • (Starting with Oracle Database 12c) Archived redo log files

  • (Starting with Oracle Database 12c) Flashback log files

  • (Starting with Oracle Database 12c) Recovery files


Note -  You must not store Oracle Grid Infrastructure binary files, cluster registry (OCR) files, or voting disks on an Oracle ACFS file system. In addition, if you are using Oracle Database version 11g release 2, you also must not store data files, control files, online redo log files, archived redo log files, flashback log files, or Oracle Database recovery files on an Oracle ACFS file system.

Optimizing Performance and Availability When Using a PxFS-Based Cluster File System

The I/O performance during the writing of archived redo log files is affected by the location of the device group for archived redo log files. For optimum performance, ensure that the primary of the device group for archived redo log files is located on the same node as the Oracle RAC database instance. This device group contains the file system that holds archived redo log files of the database instance.

To improve the availability of your cluster, consider increasing the desired number of secondary nodes for device groups. However, increasing the desired number of secondary nodes for device groups might also impair performance. To increase the desired number of secondary nodes for device groups, change the numsecondaries property. For more information, see Device Group Ownership in Oracle Solaris Cluster 4.3 Concepts Guide .

How to Use a PxFS-Based Cluster File System

  1. Create and mount the cluster file system.

    See Creating Cluster File Systems in Oracle Solaris Cluster 4.3 Software Installation Guide for information about how to create and mount the cluster file system.


    Note -  Oracle Grid Infrastructure binaries cannot reside on a cluster file system.
  2. If you are using the UNIX file system (UFS), ensure that you specify the correct mount options for various types of Oracle Database files.

    For the correct options, see the table that follows. You set these options when you add an entry to the /etc/vfstab file for the mount point.

    Oracle Database File Type
    Options
    Oracle Database RDBMS binary files
    global, logging
    Oracle Database configuration files
    global, logging
    System parameter file (SPFILE)
    global, logging
    Alert files
    global, logging
    Trace files
    global, logging
    Archived redo log files
    global, logging, forcedirectio
    Flashback log files
    global, logging, forcedirectio
    Oracle Grid Infrastructure OCR files
    global, logging, forcedirectio
    Oracle Grid Infrastructure voting disk
    global, logging, forcedirectio

Next Steps

Ensure that all other storage management schemes that you are using for Oracle Database files are installed. After all storage management schemes that you are using for Oracle Database files are installed, go to Chapter 3, Registering and Configuring the Resource Groups.

How to Use an Oracle ACFS File System

Next Steps

Go to Chapter 3, Registering and Configuring the Resource Groups.