Oracle RAC

Reading Time: 5 minutes

Oracle RAC

    Module 1: Oracle Real Application Clusters Overview

    • Oracle RAC Features
    • Oracle RAC Technology Hierarchy
    • Oracle RAC Capabilities
    • Oracle RAC Components
    • Tools for Installing, Configuring and Managing Oracle RAC

    Module 2: Oracle Grid Infrastructure Overview

    • Cluster Overview
    • Grid Foundation Components and Architecture
    • Oracle Clusterware Components and RAC
    • Oracle Clusterware Software and Storage
    • Oracle Storage Subsystems
    • File Types used by a RAC Database
    • Methods used to Share Database Files across a Cluster
    • ASM Architecture
    • Create and Manage ASM Disk Groups
    • Create and Manage ASM Cluster Filesystems
    • An Overview of RAC Services
    • Network Configuration

    Module 3: RAC Installation Tasks

    • Oracle RAC Pre-installation Tasks
    • Create Oracle Groups, User Accounts and Directories
    • Validate and Prepare the Hardware and the Operating System
    • Network Configuration

    Module 4: Install Oracle Grid Infrastructure and Real Application Clusters

    • Install the Oracle Grid Infrastructure
    • Cluster Verification Utility (CVU, CLUVFY)
    • Install Oracle Database Software and Create a Cluster Database
    • Verify the Installation
    • Post Installation Tasks
    • Configure Client Connections with Oracle Net Manager
    • Convert an Oracle Database to a RAC Database
    • Use the DBCA for Single Instance Conversion
    • Use rconfig for Single Instance Conversion
    • RAC Specific Background Processes

    Module 5: RAC Cluster Database and Database Instance Administration

    • RAC Initialization Parameters
    • Manage Undo Tablespaces in a RAC Environment
    • Manage Redo Log Files and Groups in a RAC Environment
    • Oracle Enterprise Manager Cluster Database Pages
    • Start and Stop Oracle RAC Databases and Instances
    • Administer Database Storage
    • Transparent Data Encryption and Wallets in RAC

    Module 6: Administer Oracle Clusterware Components

    • Manage CRS Commands
    • CRSCTL Commands to Stop, Start and Administer Clusterware
    • Backup and Recover Voting Disks
    • Add and Remove Voting Disks
    • The ocrcheck Utility
    • The ocrdump Command
    • Administer the Oracle Cluster Registry (OCR)
    • Backup and Restore OCR
    • Troubleshoot the OCR with ocrcheck

    Module 7: ASM Instance Administration

    • ASM Initialization Parameters
    • Create an ASM Instance using ASMCA
    • Start and Stop an ASM Instance using srvctl
    • Start and Stop an ASM Instance using ASMCMD
    • Start and Stop an ASM Instance Containing Cluster Files
    • Start and Stop the ASM Listener

    Module 8: ASM Disk Group Administration

    • Create and Delete ASM Disk Groups
    • ASM Disk Group Attributes
    • ASM Disk Group Maintenance Tasks
    • Preferred Read Failure Groups
    • ASM Disk Statistics

    Module 9: ASM Cluster File System Administration

    • ASM Dynamic Volume Manager
    • Manage ASM Volumes
    • Create an ASM Cluster File System (ACFS)
    • Manage a ACFS File System
    • ACFS Snapshots
    • Manage ACFS with Command Line Tools

    Module 10: RAC Management Commands

    • RAC Management Commands
    • RAC Administration with SVRCTL
    • SVRCTL Cluster Database Configuration Tasks
    • SVRCTL Cluster Database Administration Tasks
    • Check the Current Configuration
    • SVRCTL Command Summary
    • Administer Databases and Instances
    • Administer Services and Node Applications
    • Bring a Cluster Database online and offline
    • Introduction to CRS
    • Cluster Services

    Module 11: Managing the Database Workload using Services

    • Manage the Database Workload using Services
    • Create and Administer Services in a RAC Environment
    • Services and Client Applications
    • Manage Services with Enterprise Manager and from the Command Line
    • Configure Oracle Net to Support Services
    • Configure Service Level Thresholds
    • Configure Clients for Failover

    Module 12: High Availability of Connections

    • RAC High Availability Framework
    • Failure Detection with Cluster Services
    • Oracle RAC and Hardware Failover
    • Connection Failover
    • Transparent Application Failover (TAF)
    • Server, Client And Runtime Load Balancing
    • Fast Application Notification (FAN)
    • Server and Client Side Oracle Notification Services

    Module 13: Backup and Recover a RAC Database

    • Configure a Fast Recovery Area for use with RAC
    • Tune Instance Recovery in RAC
    • Parallel Recovery in RAC
    • Initiate Archiving
    • Configure RMAN Backup and Recovery Settings
    • Backup a RAC Database using RMAN
    • Restore and Recover a RAC Database using RMAN
    • Display Backup Reports

    Module 14: Create Duplicate and Standby Databases with RAC

    • Duplicate a RAC Database with RMAN
    • Standby Database in a RAC Configuration
    • Configure Data Guard for a RAC Environment
    • Possible Combinations of Instances in the RAC Primary and Standby Databases
    • Multi Instance Primary with a Single Instance Standby
    • Set up a Primary in a RAC Environment
    • Set up a Single Instance Standby Database
    • Set up a Multiple Instance Primary and Cluster Standby
    • Configure RAC Primary and Standby Databases
    • Data Protection Modes
    • Role Transition Switchovers and Failovers
    • Switchover Failover in an Oracle RAC Configuration

    Module 15: RAC Performance Tuning

    • Monitoring and Performance Guidelines
    • RAC Monitoring Tools
    • RAC Performance Recommendations
    • Analyze Performance Issues using OS Watcher and LTOM
    • Use the Automatic Workload Repository in RAC
    • Use the Automatic Database Diagnostic Monitor in RAC
    • Use Statspack with RAC
    • Global Cache Services (GCS) Monitoring
    • V$cache_transfer Views
    • Monitor the GES Processes
    • Monitor and Tune the RAC Cluster Environment using Enterprise Manager

    Module 16: Add and Delete Nodes and Clusters

    • Prepare a New Node
    • Extend the Oracle Grid Infrastructure Home to the New Node
    • Extend the Oracle RAC Home Directory
    • Add the New Node to the Cluster
    • Create an Instance on the New Node
    • Delete an Instance from the Cluster Database
    • Remove a Node from the Cluster

    Module 17: Manage Oracle Software and Apply Patches

    • Configure the EM Patch Interface
    • Obtain Patches
    • Apply Rolling Patches to a RAC System
    • Apply a Patchset with the opatch Utility
    • Apply a Patchset with OUI