Chapter 1 Oracle ZFS Storage Appliance Overview
Chapter 3 Initial Configuration
Chapter 4 Network Configuration
Chapter 5 Storage Configuration
Chapter 6 Storage Area Network Configuration
Chapter 8 Setting ZFSSA Preferences
Chapter 10 Cluster Configuration
Chapter 12 Shares, Projects, and Schema
Chapter 16 Maintenance Workflows
Oracle Exadata Database Machine Backup
Manual Configuration of a Sun ZFS Storage Appliance
Configuring Networks, Pools, and Shares
Configuring Oracle RMAN and the Oracle Database Instance
Configuring Oracle Exadata for a Sun ZFS Storage Appliance
Configure Exadata Configuring Oracle Exadata for a Sun ZFS Storage Appliance
Setting Up the Directory Structure to Mount the Shares on the Host
Updating oranfstab to Access ZFS Storage Appliance Exports
Oracle SPARC SuperCluster Backup
Configuring the ZFS Storage Appliance for Backup
Configuring the ZFS Storage Appliance InfiniBand Datalinks
Configuring the Oracle SPARC SuperCluster InfiniBand Switches to Add the ZFS Storage Appliance
Configuring ZFS Storage Appliance Networking for Single IP Connection
Configuring ZFS Storage Appliance Networking for an Active-Active Configuration
Configuring the ZFS Storage Appliance Storage Pool
Configuring the ZFS Storage Appliance Shares
Configuring the ZFS Storage Appliance DTrace Analytics
Configuring the Client NFS Mount
Tuning the Solaris 11 Network and Kernel
Configuring Oracle Direct NFS (dNFS)
Tuning the Oracle Database Instance for Oracle RMAN Backup and Restore
Creating Dedicated Services for Oracle RMAN Operations
Configuring Oracle SPARC SuperCluster for ZFS Storage Appliance Backup
Configure SSC Configuring Oracle SPARC SuperCluster for ZFS Storage Appliance Backup
Setting Up the Directory Structure to Mount the Shares on the Host
Enabling the NFS Client Service
Updating oranfstab to Access ZFS Storage Appliance Exports
Mounting the Shares on the Host
Setting the Ownership of the Mounted Shares
Oracle Intelligent Storage Protocol
Set the Optimal file record size
Use either ZFS Latency or Throughput write mode for each request
Sun ZFS Storage Appliance Network File System Plug In for Oracle Solaris Cluster
Sun ZFS Storage Appliance Plug-in for Oracle Solaris Cluster Geographic Edition
Sun ZFS Storage Management Plug-In for Oracle Enterprise Manager Grid Controller
Configure for Oracle Enterprise Manager Monitoring
Unconfigure Oracle Enterprise Manager Monitoring
Oracle Virtual Machine Storage Connect Plug-in for the Sun ZFS Storage Appliance
Sun ZFS Storage Appliance Provider For Volume Shadow Copy Service Software
FC support with Symantec's 'DMP' / Storage Foundation
FC support for Symantec's Storage Foundation 5.1RP2 and greater for the following OS versions
Sun ZFS Storage 7000 Storage Replication Adapter for VMware Site Recovery Manager
Topics in this section:
Setting Up the Directory Structure to Mount the Shares on the Host
Updating the /etc/fstab File
Creating an init.d Service
Updating oranfstab to Access ZFS Storage Appliance Exports
Mounting the Shares on the Host
Setting the Ownership of the Mounted Shares
Set up mount points for the shares on the host as shown:
mkdir -p /zfssa/dbname/backup1 mkdir -p /zfssa/dbname/backup2 mkdir -p /zfssa/dbname/backup3 mkdir -p /zfssa/dbname/backup4
To update the /etc/fstab file, use one of the following options.
Note: The UNIX new-line escape character (\) indicates a single line of code has been wrapped to a second line in the listing below. When entering a wrapped line into fstab, remove the \ character and combine the two line segments, separated by a space, into a single line.
For a one-pool configuration:
192.168.36.200:/export/dbname/backup1 /zfssa/dbname/backup1 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0 192.168.36.200:/export/dbname/backup2 /zfssa/dbname/backup2 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0 192.168.36.200:/export/dbname/backup3 /zfssa/dbname/backup3 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0 192.168.36.200:/export/dbname/backup4 /zfssa/dbname/backup4 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0
For a two-pool configuration:
192.168.36.200:/export/dbname/backup1 /zfssa/dbname/backup1 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0 192.168.36.201:/export/dbname/backup2 /zfssa/dbname/backup2 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0 192.168.36.200:/export/dbname/backup3 /zfssa/dbname/backup3 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0 192.168.36.201:/export/dbname/backup4 /zfssa/dbname/backup4 nfs \<br/> rw,bg,hard,nointr,rsize=1048576,wsize=1048576,tcp,nfsvers= \<br/> 3,timeo=600 0 0
Create an init.d service using the appropriate following option.
# !/bin/sh # # zfssa_dbname: Mount ZFSSA project dbname for database dbname # # chkconfig: 345 61 19 # description: mounts ZFS Storage Appliance shares #
start() { mount /zfssa/dbname/backup1 mount /zfssa/dbname/backup2 mount /zfssa/dbname/backup3 mount /zfssa/dbname/backup4 echo "Starting $prog: " }
stop() { umount /zfssa/dbname/backup1 umount /zfssa/dbname/backup2 umount /zfssa/dbname/backup3 umount /zfssa/dbname/backup4 echo "Stopping $prog: " }
case "$1" in start) start ;; stop) stop ;; restart) stop start ;; status) mount ;; *) echo "Usage: $0 {start|stop|restart|status}" exit 1 esac
(Optional) Enable the init.d service for start-on-boot by entering:
# chkconfig zfssa_dbname on
(Optional) Start and stop the service manually using the service commands:
# service zfssa_dbname start<br/># service zfssa_dbname stop
To update the oranfstab file to access ZFS Storage Appliance exports, use the appropriate following option.
Note: If you used the Oracle Exadata Backup Configuration Utility, you may optionally perform this procedure.
For a one-pool configuration:
server: 192.168.36.200 path: 192.168.36.200 export: /export/dbname/backup1 mount: /zfssa/dbname/backup1 export: /export/dbname/backup2 mount: /zfssa/dbname/backup2 export: /export/dbname/backup3 mount: /zfssa/dbname/backup3 export: /export/dbname/backup4 mount: /zfssa/dbname/backup4
For a two-pool configuration:
server: 192.168.36.200 path: 192.168.36.200 export: /export/dbname/backup1 mount: /zfssa/dbname-2pool/backup1 export: /export/dbname/backup3 mount: /zfssa/dbname-2pool/backup3 server: 192.168.36.201 path: 192.168.36.201 export: /export/dbname/backup2 mount: /zfssa/dbname-2pool/backup2 export: /export/dbname/backup4 mount: /zfssa/dbname-2pool/backup4
To mount the shares on the host, enter one of the following two options:
# service mount_dbname start
or
# dcli -l root -g /home/oracle/dbs_group service mount_dbname start
Change the permission settings of the mounted shares to match the permission settings of ORACLE_HOME. In this example, the user and group ownerships are set to oracle:dba.
Note: If you used the Oracle Exadata Backup Configuration Utility, you may optionally perform step 2; step 1 has already been performed for you.
Enter one of the following two options:<br /># chown oracle:dba /zfssa/dbname/*<br />or<br/># dcli -l root -g /home/oracle/dbs_group chown oracle:dba/zfssa/dbname/*
Restart the Oracle Database instance to pick up the changes that were made to the oranfstab file using one of the following options:
Restart one instance at a time (rolling upgrade), for example:
:$ srvctl stop instance -d dbname -i dbname1
:$ srvctl start instance -d dbname -i dbname1
:$ srvctl stop instance -d dbname -i dbname2
:$ srvctl start instance -d dbname -i dbname2
:$ srvctl stop instance -d dbname -i dbname3
:$ srvctl start instance -d dbname -i dbname3
:$ srvctl stop instance -d dbname -i dbname4
:$ srvctl start instance -d dbname -i dbname4
:$ srvctl stop instance -d dbname -i dbname5
:$ srvctl start instance -d dbname -i dbname5
:$ srvctl stop instance -d dbname -i dbname6
:$ srvctl start instance -d dbname -i dbname6
:$ srvctl stop instance -d dbname -i dbname7
:$ srvctl start instance -d dbname -i dbname7
:$ srvctl stop instance -d dbname -i dbname8
:$ srvctl start instance -d dbname -i dbname8
Restart the entire database, for example:
:$ srvctl stop database -d dbname
:$ srvctl start database -d dbname