About this course

Course type Essentials
Course code OC11GRACAD2
Duration 4 Days

In this course delegates will learn about RAC database administration in the Oracle Grid Infrastructure environment. Delegates will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. They will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied. Delegates will learn about Oracle RAC One Node and online migration. Students will learn about Quality of Service concepts. Finally, students will learn how to upgrade and path Oracle RAC databases.

This course counts toward the Hands-on course requirement for the following certifications

  • Oracle Database 11g Administrator Certification
  • Oracle Database 10g: Real Application Clusters Administrator Certified Expert

Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement.

Learn To:

  • 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

Target Audience

  • Database Administrators
  • Support Engineer
  • Data Warehouse Administrator
  • Technical Administrator

Prerequisites

Required Prerequisites:

  • General understanding of database administration
  • Oracle Grid Infrastructure 11g: Manage Clusterware and ASM Release 2

Suggested Prerequisites:

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

    Delegates will learn how to

    • 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
    • Identify Real Application Clusters components

    Outline

    Oracle Clusterware Installation

    • Oracle RAC 11g Installation
    • Cluster Setup Tasks
    • Using Raw Partitions
    • Cluster Configuration

    RAC Installation

    • Installing Automatic Storage Management
    • Configure ASM Storage
    • Install the Database Software

    Database Creation

    • Management Agent Installation
    • Storage Options for Database Files
    • Create the Database
    • Single Instance to RAC Conversion

    RAC DB Administration

    • Cluster Database Instance Administration
    • Topology Viewer
    • Automatic Undo Management and RAC
    • Quiescing RAC Databases
    • Transparent Data Encryption and Wallets in RAC
    • ASM Instance and Crash Recovery in RAC

    Backup and Recover a RAC DB

    • Protecting Against Media Failure
    • Oracle Recovery Manager

    RAC DB Monitoring and Tuning

    • CPU and Wait Time Tuning Dimensions
    • Dynamic Reconfiguration
    • ADDM Analysis

    Services

    • Workload Dispatching
    • High Availability of Services in RAC
    • Services and Resource Manager with EM
    • Change Service Thresholds
    • Using Distributed Transactions with RAC

    High Availability of Connections

    • Fast Application Notification
    • Load Balancing Advisory
    • Transparent Application Failover

    Oracle Clusterware Administration

    • Controlling the Oracle Clusterware Stack
    • Back Up and Recover Your Voting Disks
    • Back Up and Recover Oracle Cluster Registry
    • Prevent Automatic Instance Restarts

    Diagnosing the Oracle Clusterware components

    • Oracle Clusterware Main Log Files
    • RAC Diagnostic Infrastructure

    Node Addition/Removal

    • Add and Delete Nodes and Instances
    • Clone Oracle Clusterware

    Design for High Availability

    • Maximum Availability Architecture
    • RAC and Data Guard Topologies
    • Extended RAC Connectivity
    • Extended RAC disk mirroring
    • Patch your RAC system in a rolling fashion

    Workshop

    • Extend your cluster using Grid Control
    • Patch Oracle Clusterware

    Oracle RAC One Node

    • Online database migration
    • Add a RAC One Node database to an existing cluster
    • Convert a RAC One Node Database to a RAC database
    • Convert a single instance database to a RAC One Node database

    Quality of Service Management (QoS)

    • QoS concepts
    • QoS components
    • Oracle database QoS management

    Essentials

    4 Days

    Duration
    Delivery Method

    Delivery method

    Classroom

    Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

    Find dates and prices

    Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

    Trusted, awarded and accredited

    Fully accredited to ensure we provide the highest possible standards in learning

    All third party trademark rights acknowledged.