ORACLE RAC 12C
COURSE CONTENT
Oracle Grid Infrastructure Architecture
• Explain the principles and purposes of clusters
• Describe Cluster hardware best practices
• Describe the Oracle Clusterware architecture
• Describe how Grid Plug and Play affects Clusterware
• Describe the Automatic Storage Management (ASM) architecture
• Describe the components of ASM
Grid Infrastructure Installation
• Perform preinstallation tasks for Grid Infrastructure
• Install Grid Infrastructure
• Verify the installation
• Configure Automatic Storage Management (ASM) disk groups
• Configure ASM volumes
• Make the ASM cluster file system
• Mount ASM Cluster File System (ACFS) volumes
Administering Oracle Clusterware
• Display Clusterware management proficiency
• Demonstrate Oracle Cluster Registry (OCR) backup and recovery techniques
• Manage network settings
Managing Oracle Clusterware
1) Adding and Deleting Oracle Clusterware Homes
• Perform the prerequisite steps for extending a cluster
• Use addNode.sh to add a node to a cluster
• Delete a node from a cluster
2) Patching Oracle Clusterware
• Describe the types of patches and upgrades available
• Design for rolling patches and rolling upgrades
• Compare software versions with the active version
• Install a patchset with the Oracle Universal Installer (OUI) utility
• Install a patch with the opatch utility
Making Applications Highly Available with Oracle Clusterware
• Describe the high availability components of Oracle Clusterware
• Contrast policy-managed and administration-managed databases
• Describe the functionality of server pools
• Describe application-placement policies
• Create an application Virtual IP (VIP)
• Manage application resources
Troubleshooting Oracle Clusterware
• Locate Oracle Clusterware log files
• Gather all log files using diagcollection.pl
• Enable resource debugging
• Enable component-level debugging
• Enable tracing for Java-based tools
• Troubleshoot the Oracle Cluster Registry (OCR) file
Administering ASM Instances
• Explain and apply (ASM) initialization parameters
• Manage ASM instances and associated processes
• Monitor ASM using the V$ASM dynamic performance views
RAC Concepts
• Explain the necessity of global resources
• Describe global cache coordination
• Explain object affinity and dynamic remastering
Real Application Clusters Database Installation
• Install the Oracle database software
• Create a cluster database
• Perform post-database-creation tasks
• Perform a single instance to RAC conversion
Oracle RAC Administration
• Use Enterprise Manager Cluster Database pages
• Define redo log files in a RAC environment
• Define undo tablespaces in a RAC environment
• Start and stop RAC databases and instances
• Modify initialization parameters in a RAC environment
Managing Backup and Recovery for RAC
• The RAC database to use ARCHIVELOG mode and the fast recovery area
• RMAN for the RAC environment
RAC Database Monitoring and Tuning
• Determine RAC-specific tuning components
• Tune instance recovery in RAC
• Determine RAC-specific wait events, global enqueues, and system statistics
• Implement the most common RAC tuning tips
• Use the Cluster Database Performance pages
• Use the Automatic Workload Repository (AWR) in RAC
• Use Automatic Database Diagnostic Monitor (ADDM) in RAC
Services
• Configure and manage services in a RAC environment
• Use services with client applications
• Use services with the Database Resource Manager
• Use services with the Scheduler
• Configure services aggregation and tracing
Design for High Availability
• Design a Maximum Availability Architecture in your environment
• Determine the best RAC and Data Guard topologies for your environment
• Configure the Data Guard Broker configuration files in a RAC environment
• Identify successful disk I/O strategies