Real Application Cluster (RAC) 12C Course Content (40 HOURS)
- Grid Infrastructure: Overview
Objectives
Cluster
Clusterware
Oracle Clusterware
Oracle Flex Clusters
Flex Cluster Scalability
Clusterware Architecture and Cluster Services
Features of Oracle Clusterware
Oracle Clusterware Networking
Oracle Clusterware Initialization
GPnP Architecture: Overview
How GPnP Works: Cluster Node Startup
Grid Naming Service (GNS)
Single-Client Access Name
Client Database Connections
Oracle ASM
ASM CloudFS and ACFS
Oracle Flex ASM
ASM Features and Benefits
- RAC Databases Overview and Architecture
Objectives
Oracle RAC: Overview
Typical Oracle RAC Architecture
RAC One Node Single-Instance High Availability
Oracle RAC One Node
Oracle RAC One Node and Oracle Clusterware
Cluster-Aware Storage Solutions
Oracle Cluster File System
Oracle RAC and Network Connectivity
Benefits of Using RAC
Clusters and Scalability
Levels of Scalability
Oracle Internal & Oracle Academy Use Only
Scaleup and Speedup
Speedup/Scaleup and Workloads
I/O Throughput Balanced: Example
Necessity of Global Resources
Additional Memory Requirement for RAC
Parallel Execution with RAC
- Installing and Configuring Oracle RAC
Objectives
Installing the Oracle Database Software
Creating the Cluster Database
Database Type Selection
Database Identification
Cluster Database Management Options
Passwords for Database Schema Owners
Storage Locations
Database Content
Initialization Parameters
Create the Database
Monitoring Progress
Postinstallation Tasks
Background Processes Specific to Oracle RAC
Single Instance–to-RAC Conversion
Considerations for Converting Single-Instance Databases to Oracle RAC
Single-Instance Conversion Using DBCA
Conversion Steps
Single-Instance Conversion Using rconfig
- Oracle RAC Administration
Objectives
Enterprise Manager Cloud Control Cluster Database Home Page
Cluster Database Home Page
Cluster Database Instance Home Page
Cluster Home Page
Topology Viewer
Enterprise Manager Alerts and RAC
Enterprise Manager Metrics and RAC
Oracle Internal & Oracle Academy Use Only
Enterprise Manager Blackouts and RAC
Enterprise Manager Database Express
Redo Log Files and RAC
Automatic Undo Management and RAC
Starting and Stopping RAC Instances
Starting and Stopping RAC Instances with srvctl
Starting and Stopping RAC Instances with SQL*Plus
Starting and Stopping Pluggable Databases in Oracle RAC
Switch Between Automatic and Manual Policies
RAC Initialization Parameter Files
SPFILE Parameter Values and RAC
Parameter File Search Order in Oracle RAC
EM and SPFILE Parameter Values
RAC Initialization Parameters
Parameters That Require Identical Settings
Parameters That Require Unique Settings
Quiescing RAC Databases
Terminating Sessions on a Specific Instance
How SQL*Plus Commands Affect Instances
Transparent Data Encryption and Keystores in RAC
- Upgrading and Patching Oracle RAC
Objectives
Patch and Patch Set: Overview
Types of Patches
Configuring the Software Library
Obtaining Oracle RAC Patches
Downloading Patches
Reduced Down-Time Patching for Cluster Environments
Rolling Patches
Out-of-Place Database Upgrades
Out-of-Place Database Upgrade with OUI
OPatch: Overview
OPatch: General Usage
Before Patching with OPatch
OPatch Automation
OPatch Automation: Examples
OPatch Log and Trace Files
Oracle Internal & Oracle Academy Use Only
Queryable Patch Inventory
Summary
- Managing Backup and Recovery for RAC
Objectives
RAC and Instance Recovery
Instance Recovery and Database Availability
Instance Recovery and RAC
Protecting Against Media Failure
Media Recovery in Oracle RAC
Parallel Recovery in RAC
RAC and the Fast Recovery Area
RAC Backup and Recovery Using EM
Configuring RAC Recovery Settings with EM
Archived Redo File Conventions in RAC
Configuring RAC Backup Settings with EM
Oracle Recovery Manager
Configuring RMAN Snapshot Control File Location
Configuring Control File and SPFILE Autobackup
Crosschecking on Multiple RAC Clusters Nodes
Channel Connections to Cluster Instances
RMAN Channel Support for the Grid
RMAN Default Autolocation
Distribution of Backups
Managing Archived Redo Logs Using RMAN
Noncluster File System Local Archiving Scheme
Configuring Non-Cluster, Local Archiving
ASM and Cluster File System Archiving Scheme
Configuring the CFS Archiving Scheme
Restoring and Recovering
- Global Resource Management Concepts
Objectives
Need for Global Concurrency Control
Global Resource Directory (GRD)
Global Resource Management
Global Resource Remastering
Global Resource Recovery
Oracle Internal & Oracle Academy Use Only
Global Resource Background Processes
Global Resource Access Coordination
Global Enqueues
Instance Locks
Global Cache Management: Overview
Global Cache Management Components
Global Cache Buffer States
Global Cache Management Scenarios for Single Block Reads
Global Cache Scenarios: Overview
Scenario 1: Read from Disk
Scenario 2: Read-Write Cache Fusion
Scenario 3: Write-Write Cache Fusion
Scenario 4: Write-Read Cache Fusion
Global Cache Management Scenarios for Multi-Block Reads
Useful Global Resource Management Views
- RAC Database Monitoring and Tuning
Objectives
CPU and Wait Time Tuning Dimensions
RAC-Specific Tuning
Analyzing Cache Fusion Impact in RAC
Typical Latencies for RAC Operations
Wait Events for RAC
Wait Event Views
Global Cache Wait Events: Overview
Global Enqueue Waits
Session and System Statistics
Most Common RAC Tuning Tips
Index Block Contention: Considerations
Oracle Sequences and Index Contention
Undo Block Considerations
High-Water Mark Considerations
Concurrent Cross-Instance Calls: Considerations
Monitoring RAC Database and Cluster Performance
Cluster Database Performance Page
Determining Cluster Host Load Average
Determining Global Cache Block Access Latency
Determining Average Active Sessions
Oracle Internal & Oracle Academy Use Only
Determining Database Throughput
Accessing the Cluster Cache Coherency
Viewing the Database Locks
AWR Snapshots in RAC
AWR Reports and RAC: Overview
Active Session History Reports for RAC
Automatic Database Diagnostic Monitor for RAC
What Does ADDM Diagnose for RAC?
EM Support for ADDM for RAC
EM Database Express Performance Hub
- Managing High Availability of Services
Objectives
Oracle Services
Service Usage in an Oracle RAC Database
Parallel Operations and Services
Service Characteristics
Default Service Connections
Restricted Service Registration
Creating Service with Enterprise Manager
Creating Services with SRVCTL
Managing Services with Enterprise Manager
Managing Services with EM
Managing Services with srvctl
Using Services with Client Applications
Services and Connection Load Balancing
Services and Transparent Application Failover
Using Services with the Resource Manager
Services and Resource Manager with EM
Using Services with the Scheduler
Services and the Scheduler with EM
Using Distributed Transactions with RAC
Distributed Transactions and Services
Service Thresholds and Alerts
Services and Thresholds Alerts: Example
Service Aggregation and Tracing
Top Services Performance Page
Service Aggregation Configuration
Oracle Internal & Oracle Academy Use Only
Service, Module, and Action Monitoring
Service Performance Views
- High Availability for Connections and Applications
Objectives
Types of Workload Distribution
Client-Side Connect-Time Load Balancing
Fast Application Notification (FAN): Overview
Fast Application Notification: Benefits
Implementing FAN Events
FAN and Oracle Integrated Clients
FAN-Supported Event Types
FAN Event Reasons
FAN Event Status
FAN Event Format
Load Balancing Advisory: FAN Event
Server-Side Callouts Implementation
Server-Side Callout Parse: Example
Server-Side Callout Filter: Example
Server-Side ONS
Optionally Configuring the Client-Side ONS
UCP JDBC Fast Connection Failover: Overview
JDBC/ODP.NET FCF Benefits
Load Balancing Advisory
UCP JDBC/ODP.NET Runtime Connection Load Balancing: Overview
Connection Load Balancing in RAC
Monitoring LBA FAN Events
Transparent Application Failover: Overview
TAF Basic Configuration on Server-Side: Example
TAF Basic Configuration on a Client-Side: Example
TAF Preconnect Configuration: Example
TAF Verification
FAN Connection Pools and TAF Considerations
Introducing Transaction Guard and Application Continuity
What Is Transaction Guard?
Benefits of Transaction Guard
How Transaction Guard Works
Using Transaction Guard
Oracle Internal & Oracle Academy Use Only
Creating Services for Transaction Guard
What Is Application Continuity?
Benefits of Application Continuity
How Does Application Continuity Work?
RAC and Application Continuity
Using Application Continuity
Creating Services for Application Continuity
- Oracle RAC One Node
Objectives
Oracle RAC One Node
Creating an Oracle RAC One Node Database
Verifying an Existing RAC One Node Database
Oracle RAC One Node Online Relocation
Online Relocation Considerations
Performing an Online Relocation
Online Relocation Illustration
Online Maintenance: Rolling Patches
Adding an Oracle RAC One Node Database to an Existing Cluster
Converting a RAC One Node Database to RAC
Converting a Single Instance Database to RAC One Node
Converting a RAC Database to RAC One Node
- Multitenant Architecture and RAC
Objectives
Non-CDB Architecture
Multitenant Architecture: Benefits
CDB in a Non-RAC Environment
Containers
Terminology
Data Dictionary Views
Connection to a Non-RAC CDB
Switching Connection
Oracle RAC and Multitenant Configuration
Oracle RAC and Multitenant Architecture
Oracle Internal & Oracle Academy Use Only
Creating a RAC CDB
Creating a RAC CDB Including PDBs
Hosting a RAC CDB in Server Pools
After CDB Creation
Connecting Using CDB/PDB Services
Opening a PDB in a RAC CDB
Closing a PDB in a RAC CDB
Types of Services
Managing Services
Affinitizing PDB Services to Server Pools
Adding a PDB to a RAC CDB
Dropping a PDB from a RAC CDB
- Quality of Service Management
Objectives
QoS Management Background
QoS Management Overview
QoS Management and Exadata Database Machine
QoS Management Focus
QoS Management Benefits
QoS Management Functional Overview
QoS Management Policy Sets
Server Pools
Performance Classes
Classification and Tagging
Performance Policies
Performance Class Ranks
Performance Objectives
Performance Satisfaction Metrics
Server Pool Directive Overrides
Overview of Metrics
QoS Management Architecture
QoS Management Recommendations
Implementing Recommendations