H2K Infosys | Oracle RAC Online Course Details

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 2 for Oracle Real Application Clusters (RAC). Students learn how to install and administer Oracle Clusterware, Real Application Clusters, and Automatic Storage Management. Students also learn how to administer their Database in a Real Application Clusters environment using Enterprise Manager Grid Control. Increase your efficiency by learning how to configure and use database services as well as the Load Balancing Advisory in a RAC environment. Learn how to add and remove nodes in clusters and how to patch both Oracle Clusterware and Real Application Clusters software in a rolling fashion.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator certification.

• Install Oracle Clusterware and Real Application Clusters
• Administer a RAC Database
• Administer Database Services in a RAC environment
• Administer Oracle Clusterware
• Add/Remove a node to/from a cluster
• Patch Oracle Clusterware and RAC software in a rolling fashion

Audience:

• Data Warehouse Administrator
• Database Administrators
• Database Designers
• Project Manager
• Support Engineer
• System Analysts
• Technical Administrator
• Technical Consultant

Prerequisites:

• Single-instance Oracle Database 10g Architecture and Experience

Skills Gained:

• Identify Real Application Clusters components
• Install, create, administer, and monitor a Real Application Clusters database
• Use configuration and management tools for Real Application Clusters databases
• Setup services for workloads management, and applications high availability
• Develop a backup and recovery strategy for Real Application Clusters databases
• Configure and monitor Oracle Clusterware resources
• Review high availability best practices

Details:

Identify Real Application Clusters components

• Understand Real Application Clusters
• Clusters Scalability and High Availability
• The Necessity of Global Resources
• Parallel Execution with RAC
• RAC Software and Database Principles
• RAC and Shared Storage Technologies
• Understand VIPs

Install, create, administer, and monitor a Real Application Clusters database

• Describe the installation of Oracle RAC 10g
• Perform RAC pre-installation tasks
• Perform cluster setup tasks
• Install Oracle Clusterware
• Install and configure Automatic Storage Management (ASM)
• Install the Oracle database software
• Create a cluster database
• Install the Enterprise Manager agent on each cluster node

Use configuration and management tools for Real Application Clusters databases

• 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
• Manage ASM instances in a RAC environment

Develop a backup and recovery strategy for Real Application Clusters databases

• Configure the RAC database to use ARCHIVELOG mode and the flash recovery area
• Configure RMAN for the RAC environment

Configure and monitor Oracle Clusterware resources

• Manually control the Oracle Clusterware stack
• Change voting disk and OCR configuration
• Back up or recover your voting disks and OCR files
• Change VIP addresses
• Use the CRS framework

Review high availability best practices

• Add a new node to your cluster database
• Remove a node from your cluster database
• Decide on the best ASM configuration to use
• Patch your RAC system in a rolling fashion
• High Availability Architecture