Course Title - Pro Tech Training by yaosaigeng

VIEWS: 2 PAGES: 3

									                                                 "Charting the Course ...

                                                                                                                        ... to Your Success!"

                                                 Oracle 10g Real Application Clusters
                                                                          Course Summary
Description

Students attending this class will learn how to identify, install, create, administer and monitor a real application
cluster environment in Oracle.

Objectives
At the end of this course, students will be able to:

      •      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

Topics

      •      Introduction                                                                                      •      Services
      •      Architecture and Concepts                                                                         •      High Availability of Connections
      •      RAC Installation and Configuration Part I                                                         •      Managing Backup and Recovery in RAC
      •      RAC Installation and Configuration Part II                                                        •      RAC Performance Tuning
      •      RAC Database Instances Administration                                                             •      Design for High Availability
      •      Administering Storage in RAC Part I
      •      Administering Storage in RAC Part II

Audience

The course is recommended for application developers, database administrators, systems programmers,
database designers, and system analysts, personnel interested in Oracle performance and tuning facilities and
those who are interested in learning about the real application clusters feature of Oracle.

Prerequisites

It is recommended that people attending this class have a working knowledge of Oracle 9i and have worked with
Oracle for a period of at least three months.

Duration

Five days




 Due to the nature of this material, this document refers to numerous hardware and software products by their trade names. References to other companies and their products are for informational
   purposes only, and all trademarks are the properties of their respective companies. It is not the intent of ProTech Professional Technical Services, Inc. to use any of these names generically

PT5260_ORACLEVERSION10GREALAPPLICATIONCLUSTERS.DOC
                                                 "Charting the Course ...

                                                                                                                        ... to Your Success!"
                                                 Oracle 10g Real Application Clusters
                                                                             Course Outline

I.    Introduction
      A. Define a cluster
      B. Define Oracle Real Application Clusters
      C. List the advantages of using RAC
      D. Define scalability
      E. High availability and RAC

II. Architecture and Concepts
    A. List the various components of Cluster Ready Services (CRS) and Real Application Clusters (RAC)
    B. Describe the various types of files used by a RAC database
    C. Describe the various techniques used to share database files across a cluster
    D. Describe the purpose of using services with RAC

III. RAC Installation and Configuration Part I
     A. Outline Oracle 10g RAC Installation
     B. Pre-installation Tasks
     C. Cluster Setup Tasks
     D. Installing OCFS
     E. Installing Cluster Ready Services

IV. RAC Installation and Configuration Part II
    A. Install Database Software
    B. Launching VIPCA with root.sh
    C. Database Pre-creation Tasks
    D. Creating the Cluster Database
    E. Database Post-installation Tasks
    F. Administering Enterprise Manager Jobs in Real Application Clusters
    G. Node Addition and Deletion and the SYSAUX Tablespace
    H. AWR snapshots in RAC

V. RAC Database Instances Administration
   A. Understand the EM Cluster Database Home Page
   B. Starting and Stopping RAC Instances
   C. RAC Initialization Parameter Files
   D. Adding a Node to a Cluster
   E. Deleting Instances from a RAC Database
   F. Quiescing RAC Databases
   G. Administering Alerts with Enterprise Manager

VI. Administering Storage in RAC Part I
    A. Describe automatic storage management (ASM)
    B. Install the ASM software
    C. Set up initialization parameter files for ASM and database instances
    D. Start up and shut down ASM instances
    E. Add ASM instances to the target list of Database Control
    F. Use Database Control to administer ASM in a RAC environment
 Due to the nature of this material, this document refers to numerous hardware and software products by their trade names. References to other companies and their products are for informational
   purposes only, and all trademarks are the properties of their respective companies. It is not the intent of ProTech Professional Technical Services, Inc. to use any of these names generically

PT5260_ORACLEVERSION10GREALAPPLICATIONCLUSTERS.DOC
                                                 "Charting the Course ...

                                                                                                                        ... to Your Success!"

                                                 Oracle 10g Real Application Clusters
                                                                    Course Outline (cont’d)
VII. Administering Storage in RAC Part II
     A. Manage redo log groups in a RAC environment
     B. Manage undo table spaces in a RAC environment
     C. Use SRVCTL to manage ASM instances
     D. Migrate database files to ASM
     E. Manage and recover the OCR file and voting disk

VIII.Services
     A. Configure and manage services in a RAC environment
     B. Use services with client applications
     C. Use services with the Database Resource Manager
     D. Use services with the Scheduler
     E. Set performance-metric thresholds on services
     F. Configure services aggregation and tracing

IX. High Availability of Connections
    A. Configure client side connect-time load balancing
    B. Configure client side connect-time failover
    C. Configure server side connect-time load balancing
    D. Benefit from Fast Application Notification (FAN)
    E. Configure server-side callouts
    F. Configure the server and client-side ONS
    G. Configure Transparent Application Failover (TAF)

X. Managing Backup and Recovery in RAC
   A. Configure RAC Recovery Settings with EM
   B. Configure RAC Backup Settings with EM
   C. Initiate Archiving
   D. Configuring RMAN
   E. RAC Backup and Recovery Using EM

XI. RAC Performance Tuning
    A. Determine RAC specific tuning components
    B. Tune instance recovery in RAC
    C. Determine RAC specific wait events, global enqueues, and system statistics
    D. Implement most common RAC tuning tips
    E. Use the Cluster Database Performance pages
    F. Use Automatic Workload Repository and Automatic Database Diagnostic Monitor in RAC

XII. Design for High Availability
     A. Design a Maximum Availability Architecture in your environment
     B. Determine the best RAC and Data Guard topologies for your environment
     C. Configure the Data Guard Broker configuration files in a RAC environment
     D. Patch your RAC system in a rolling fashion


 Due to the nature of this material, this document refers to numerous hardware and software products by their trade names. References to other companies and their products are for informational
   purposes only, and all trademarks are the properties of their respective companies. It is not the intent of ProTech Professional Technical Services, Inc. to use any of these names generically

PT5260_ORACLEVERSION10GREALAPPLICATIONCLUSTERS.DOC

								
To top