ORACLE RAC ONLINE COURSE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CONTACT US