Implementing Oracle on NetApp Storage Systems (ORONSS)

Course Outline

Module 1: Implementing Oracle on NetApp Storage Systems Overview

• Describe components of Oracle databases
• Describe key issues that are often experienced with Oracle deployments
• Describe the advantages of implementing Oracle solutions on NetApp technology

Module 2: Designing and Planning an Oracle Implementation

Module 3: Setting Up NetApp Storage Systems of Oracle Databases

• Configure clustered Data ONTAP network interface groups, logical interfaces (LIFs), and interface failover
• Configure clustered Data ONTAP virtual storage servers (Vservers)
• Provision storage for a Vserver
• Access a Data ONTAP cluster
• Configure export policies
• Implement and validate a storage design on the clustered Data ONTAP operating system

Module 4: Installing an Oracle Server and Oracle Databases

Module 5: Oracle dNFS and NetApp Storage

• Enable direct NFS (dNFS) for an Oracle database
• Explain what dNFS is and how it differs from kernel Network File Systems (kNFS)
• List the database objects that show you the dNFS database traffic
• Configure multiple paths for dNFS

Module 6: Using Oracle ASM with NetApp Storage

Module 7: Backup and Recovery Methods for Oracle

Module 8: Cloning Oracle Databases

Module 9: Disaster Recovery for Oracle Databases

Lab Exercises

Lab 1-1 Use login credentials for the Linux host
Lab 1-2 Verify the necessary file systems
Lab 1-3 Verify that initial databases are available
Lab 1-4 Identify NetApp cluster components
Lab 2-1 Identify the components of the Oracle database
Lab 2-2 Describe the use case that is associated with the storage design
Lab 3-1 Log in to cluster1_01 VSIM
Lab 3-2 Create a Vserver
Lab 3-3 Modify the Vserver to enable the NFS protocol, assign the default aggregates and add the appropriate DNS
Lab 3-4 Add the appropriate LIFS for your Vserver
Lab 3-5 Define the export policy for the Vserver
Lab 3-6 Modify the Vserver vsadmin user
Lab 3-7 Provision storage on the Vserver for the Oracle database server
Lab 4-1 Validate and prepare parameters for the Linux host
Lab 4-2 Validate and prepare parameters for the Data ONTAP host
Lab 4-3 Define the file systems for the Oracle database
Lab 4-4 Create an Oracle database
Lab 5-1 Enable dNFS for an Oracle database
Lab 5-2 Verify that the database is using dNFS
Lab 5-3 Disable dNFS for a database (optional)
Lab 6-1 Create a Vserver
Lab 6-2 Modify the Vserver to enable iSCSI protocol, assign the default aggregates and add the appropriate DNS information
Lab 6-3 Add the appropriate LIFs for your Vserver
Lab 6-4 Create groups, create users, and modify the Vserver vsadmin user
Lab 6-5 Start the iSCSI service for this Vserver
Lab 6-6 Provision storage for the database
Lab 6-7 Configure and validate iSCSI service on the Linux host
Lab 6-8 Prepare the Linux host for Device Mapper and discovery of LUNs
Lab 6-9 Start the Oracle Grid Infrastructure
Lab 6-10 Prepare the LUNs on the Linux host for use by ASM
Lab 6-11 Create ASM disk groups with iSCSI LUNs
Lab 6-12 Create the oraiscsi database through DBCA
Lab 6-13 Move the clustered Data ONTAP operating system and LUNs
Lab 7-1 Start the grid infrastructure
Lab 7-2 Install SnapDrive for UNIX
Lab 7-3 Install and configure SMO
Lab 7-4 Configure a SMO repository
Lab 7-5 Create an SMO profile for oraclass
Lab7-6 Create an SMO backup for oraclass
Lab 7-7 Restore an Oracle database
Lab 7-8 Install Snap Creator Framework for Oracle database servers
Lab 7-9 Set up the Snap Creator configuration file to back up your database
Lab 7-10 Restore the Oracle database using Snap Creator Framework
Lab 8-1 Create a SMO profile for oraclass
Lab 8-2 Delete a clone
Lab 8-3 Define the Snap Creator configuration for a clone workflow
Lab 8-4 Prepare a host for the new cloned database
Lab 8-5 Configure the Oracle database using Snap Creator Framework