SPARC: Requirements for Using the Sun StorEdge QFS Shared File System (Sun Cluster Data Service for Oracle Real Application Clusters Guide for Solaris OS)

Sun Cluster Data Service for Oracle Real Application Clusters Guide for Solaris OS

SPARC: Requirements for Using the Sun StorEdge QFS Shared File System

You can store all of the files that are associated with Oracle Real Application Clusters on the Sun StorEdge QFS shared file system.

For information about how to create a Sun StorEdge QFS shared file system, see the following documentation for Sun StorEdge QFS:

Sun StorEdge QFS and Sun StorEdge SAM-FS Software Installation and Configuration Guide
Sun StorEdge QFS and Sun StorEdge SAM-FS File System Administration Guide

Distribute these files among several file systems as explained in the subsections that follow.

Sun StorEdge QFS File Systems for RDBMS Binary Files and Related Files

For RDBMS binary files and related files, create one file system in the cluster to store the files.

The RDBMS binary files and related files are as follows:

Oracle relational database management system (RDBMS) binary files
Oracle 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)
Oracle Cluster Ready Services (CRS) binary files

Sun StorEdge QFS File Systems for Database Files and Related Files

For database files and related files, determine whether you require one file system for each database or multiple file systems for each database.

For simplicity of configuration and maintenance, create one file system to store these files for all Oracle Real Application Clusters instances of the database.
To facilitate future expansion, create multiple file systems to store these files for all Oracle Real Application Clusters instances of the database.

Note –

If you are adding storage for an existing database, you must create additional file systems for the storage that you are adding. In this situation, distribute the database files and related files among the file systems that you will use for the database.

Each file system that you create for database files and related files must have its own metadata server. For information about the resources that are required for the metadata servers, see SPARC: Resources for the Sun StorEdge QFS Shared File System.

The database files and related files are as follows:

Data files
Control files
Online redo log files
Archived redo log files
Flashback log files
Recovery files
Oracle cluster registry (OCR) files
Oracle CRS voting disk