Oracle Database 12c R2: Clusterware & RAC Admin Accelerated Ed 2

Introduction to Grid Infrastructure

• Clusterware Characteristics
• What is a Cluster?
• What is a Flex Cluster?
• Oracle Clusterware
• Shared Storage Overview
• Hardware and Software Concepts (High level)

Oracle Clusterware Architecture

• Configuring shared GNS
• Shared GNS Background and Architecture
• Clusterware Process Architecture
• Cluster Storage Requirements
• Clusterware Initialization and OHASD
• Moving GNS to Another Cluster
• Location Independent Names, Addresses and Name Resolution (GNS, SCAN, VIP..)
• Migrating to shared GNS

Flex Cluster Architecture

• Flex Cluster Architecture
• Configuring Flex Cluster
• Flex Clusters and Node Failure

Grid Infrastructure Pre-Installation Tasks

• Shared Storage for Oracle Clusterware
• Groups and Users
• Shell Settings
• Redundant Interconnect Usage
• Kernel Requirements
• Checking System Requirements
• Single Client Access Name for the Cluster
• Oracle Validated Configuration

Installing Grid Infrastructure

• Verifying the Oracle Clusterware Installation
• Installing Oracle Grid Infrastructure
• Installing Flex Cluster

Managing Cluster Nodes

• Removing a Node from the Cluster
• Prerequisites for Running addNode.sh
• Adding a Node with addNode.sh
• Adding Oracle Clusterware Homes
• Configuring the node role

Traditional Clusterware Management

• Network Administration
• Administering the Voting Disk file
• Clusterware Admin Tools Review
• Administering the Oracle Cluster Registry Disk file
• Oracle Clusterware startup and shutdown
• What-If Command Evaluation

Policy-Based Cluster Management

• Server Categorization
• Policy-Based Cluster Management Overview
• Policy Set

Patching Grid Infrastructure

• Rolling Patches
• OPatch Overview
• Types of Patches
• Obtaining Oracle Clusterware Patches
• Installing a Rolling Patch with OPatch
• OPatch Automation
• Out-of-Place Oracle Clusterware Upgrade
• Installing a Rolling Patchset with OUI

Troubleshooting Oracle Clusterware

• Component level checks - cluvfy with -comp
• Troubleshooting Node Evictions
• Log files and Diagnostic Collection
• The column Utility
• Cluster Health Monitor Enhancements Overview
• Resource Debugging - Java Tools and Dynamic Debugging
• Diagnostic Framework Support for CRS

Making Applications Highly Available

• Server Pools
• ONS and FAN overviews
• Overview of Using Oracle Clusterware to Enable HA
• Creating an Application VIP
• Overall flow diagram of HA lifecycle (crs_profile, crs_register, crs_start….)
• Resource Management Options
• Clusterware Resource Modeling
• Oracle Clusterware HA Components

RAC Databases Overview & Architecture

• RAC and Flex ASM
• Cluster-Aware Storage Solutions
• Scaleup and Speedup
• Overview of Oracle RAC
• Global Resources
• Benefits of Using RAC
• RAC One Node
• I/O Throughput Balanced

Installing and Configuring Oracle RAC

• Installing the Oracle Database Software
• Installation options
• Single Instance to RAC Conversion
• Creating the Cluster Database
• Post-installation Tasks
• Cleaning Up Unsuccessful Installs

Oracle RAC Administration

• Undo Tablespaces
• Use Enterprise Manager Cluster Database Pages
• RAC Alerts
• Parameters and RAC - SPFILE, Identical and Unique Parameters
• Session management on RAC instances
• Redo Threads
• Instance Startup, Shutdown and Quiesce
• RAC Metrics

RAC Backup and Recovery

• Instance Failure And Recovery In RAC - LMON and SMON
• RMAN Admin For RAC: Channels, Instances, Backup Distribution
• Redo Threads and Archive Log Configurations and Admin
• RMAN Restore And Recovery RAC Considerations
• RAC and the Fast Recovery Area
• RMAN Configuration
• Parameter Settings Affecting Parallel Recovery and MTTR

RAC Global Resource Management and Cache Fusion

• Buffer cache fusion
• Accessing single blocks in RAC
• Row cache management
• Library Cache Management
• Multi-block read considerations in RAC
• Globally Managed Resources and Management
• Buffer Cache Management Requirements
• Undo and read consistency considerations in RAC

RAC Monitoring and Tuning

• Common RAC Tuning
• RAC specific V$ Views
• Wait for Events for RAC
• OCPU and Wait Time Latencies
• Session and System Statistics
• Automatic Database Diagnostic Monitor for RAC

Managing High Availability of Services in a RAC Environment

• Services for Policy - and Administrator-Managed Databases
• Creating Services
• Oracle Services
• Services and Transparent Application Failover
• Use Services with Client Applications
• Managing Services
• Services and Connection Load Balancing
• Services and the Resource Manager

Upgrading and Patching RAC

• Planning and Preparing for Upgrade
• Performing Out of Place Release Install or Upgrade
• Merge Patches
• Overview of Upgrades and Patching
• PSU, CPU and Interim Patches
• Post Upgrade Tasks
• Performing Out of Place Database Upgrades
• Release and Patch Set Upgrades

Application Continuity

• AC Architecture
• Side Effects
• Restrictions
• Benefits of AC
• What problem does it solve?
• What is AC?
• Application requirements
• How AC works

Design for High Availability

• Database High Availability Best Practices
• Hardware Assisted Resilient Data
• RAC and Data Guard
• Maximum Availability Architecture
• Oracle’s Solution to Down Time
• RAID Configuration for High Availability
• Fast-Start Failover
• Causes of Planned and Unplanned Down Time

Oracle Database Exadata Cloud Service Overview

• Simple Web-Based Provisioning & Management
• Service Architecture & Availability
• REST APIs
• Storage Configuration & Management Details
• Management Responsibilities
• Service Configuration Options & Service Connection Options
• Migrating to Exadata Cloud Service
• Introducing Exadata Cloud Service