1. Thời lượng: 40 hours

2. Mục tiêu khóa học

This course offers students an introduction to the general features and capabilities of Oracle Database 10g Release 1 for Oracle Real Application Clusters (RAC).

Students learn how to configure and administer a database for use with Real Application Clusters. The course also explains how to setup and use Automatic Storage Management (ASM) in a Real Application Clusters environment. Lectures are reinforced with hands-on practices designed to walk the student through the RAC administration.

3. Đối tượng tham gia khóa học

• Database Administrators
• Support Engineer
• Technical Consultant

4. Điều kiện tham gia khóa học

• Oracle Database 10g: New Features for Administrators Release 2
• Oracle Database 10g: Administration Workshop I Release 2
  

5. Kết quả đạt được sau khóa học

• 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
• Migrate your database storage to Automatic Storage Management
• Setup services for workloads management, and applications high availability
• Develop a backup and recovery strategy for Real Application Clusters databases
• Review high availability best practices
  

6. Nội dung khóa học

• Introduction

  • Define a cluster
  • Define Oracle Real Application Clusters
  • List the advantages of using RAC
  • Define scalability
  • High availability and RAC

  Architecture and Concepts

  • List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
  • Describe the various types of files used by a RAC database
  • Describe the various techniques used to share database files across a cluster
  • Describe the purpose of using services with RAC

  RAC Installation and Configuration Part I

  • Outline Oracle 10g RAC Installation
  • Preinstallation Tasks
  • Cluster Setup Tasks
  • Installing OCFS
  • Installing Cluster Ready Services

  RAC Installation and Configuration Part II

  • Install Database Software
  • Launching VIPCA with root.sh
  • Database Precreation Tasks
  • Creating the Cluster Database
  • Database Postinstallation Tasks
  • Administering Enterprise Manager Jobs in Real Application Clusters
  • Node Addition and Deletion and the SYSAUX Tablespace
  • AWR snapshots in RAC

  RAC Database Instances Administration

  • Understand the EM Cluster Database Home Page
  • Starting and Stopping RAC Instances
  • RAC Initialization Parameter Files
  • Adding a Node to a Cluster
  • Deleting Instances from a RAC Database
  • Quiescing RAC Databases
  • Administering Alerts with Enterprise Manager

  Administering Storage in RAC Part I

  • Describe automatic storage management (ASM)
  • Install the ASM software
  • Set up initialization parameter files for ASM and database instances
  • Start up and shut down ASM instances
  • Add ASM instances to the target list of Database Control
  • Use Database Control to administer ASM in a RAC environment

  Administering Storage in RAC Part II

  • Manage redo log groups in a RAC environment
  • Manage undo tablespaces in a RAC environment
  • Use SRVCTL to manage ASM instances
  • Migrate database files to ASM
  • Manage and recover the OCR file and voting disk

  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
  • Set performance-metric thresholds on services
  • Configure services aggregation and tracing

  High Availability of Connections

  • Configure client side connect-time load balancing
  • Configure client side connect-time failover
  • Configure server side connect-time load balancing
  • Benefit from Fast Application Notification (FAN)
  • Configure server-side callouts
  • Configure the server and client-side ONS
  • Configure Transparent Application Failover (TAF)

  Managing Backup and Recovery in RAC

  • Configure RAC Recovery Settings with EM
  • Configure RAC Backup Settings with EM
  • Initiate Archiving
  • Configuring RMAN
  • RAC Backup and Recovery Using EM

  RAC Performance Tuning

  • Determine RAC specific tuning components
  • Tune instance recovery in RAC
  • Determine RAC specific wait events, global enqueues, and system statistics
  • Implement most common RAC tuning tips
  • Use the Cluster Database Performance pages
  • Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

  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
  • Patch your RAC system in a rolling fashion