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
Mounting the Shares on the Host
Setting the Ownership of the Mounted Shares
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)
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
Optimizing high-bandwidth backup and restore operations using Oracle RMAN and the ZFS Storage Appliance requires adjusting the instance parameters that control I/O buffering. For information about how to tune these parameters, see Article ID 1072545.1: RMAN Performance Tuning Using Buffer Memory Parameters) at http://support.oracle.com.
For Oracle SPARC SuperCluster, tuning the following four parameters should be considered:
_backup_disk_bufcnt - Number of buffers used to process backup sets
_backup_disk_bufsz - Size of the buffers used to process backup sets
_backup_file_bufcnt - Number of buffers used to process image copies
_backup_file_bufsz - Size of the buffers used to process image copies
For backup and restore operations on backup sets and image copies, set the number of buffers to 64 and the buffer size to 1 MB:
SQL> alter system set “_backup_disk_bufcnt”=64; SQL> alter system set “_backup_file_bufcnt”=64; SQL> alter system set “_backup_disk_bufsz”=1048576; SQL> alter system set “_backup_file_bufsz”=1048576;
These commands may be configured persistently by adding them to the SPFILE, or they may be set dynamically in the Oracle RMAN run block used to execute the backup or restore operations.
The following code fragments show how to dynamically tune the buffer sizes and counts for backup and restore operations.
Backup set backup:
run {<br/> sql 'alter system set “_backup_disk_bufcnt”=64';<br/> sql 'alter system set “_backup_disk_bufsz”=1048576';<br/> allocate channel... ...<br/> backup as backupset database; }
Backup set restore:
run {<br/> sql 'alter system set “_backup_disk_bufcnt”=64';<br/> sql 'alter system set “_backup_disk_bufsz”=1048576';<br/> allocate channel... ...<br/> restore database; }
Image copy backup:
run {<br/> sql 'alter system set “_backup_file_bufcnt”=64';<br/> sql 'alter system set “_backup_file_bufsz”=1048576';<br/> allocate channel... ...<br/> backup as copy database; }
Image copy restore:
run {<br/> sql 'alter system set “_backup_file_bufcnt”=64';<br/> sql 'alter system set “_backup_file_bufsz”=1048576';<br/> allocate channel... ...<br/> restore database; }
Performing an incrementally applied backup requires reading an incremental backup set and writing to an image copy. To tune buffers for incrementally applied backups, run the following:<br/>
run {<br/> sql 'alter system set “_backup_disk_bufcnt”=64';<br/> sql 'alter system set “_backup_disk_bufsz”=1048576';<br/> sql 'alter system set “_backup_file_bufcnt”=64';<br/> sql 'alter system set “_backup_file_bufsz”=1048576';<br/> allocate channel... ...<br/> recover copy of database; }