DAY
1
Introduction to RAC 12c
The
Dynamic Business Environment
The
Explosive Growth of Business Data
Online and Real-Time Access to Corporate
Data
Data Warehousing, Packaged Applications, E-Commerce Operations
Dependence on Database Management Systems
High Performance Systems
Introduction to Cluster Technology
Benefits of Real Application Clusters (RAC)
What is a DB Cluster?
Architectures of DB Clusters
What is a Cluster Interconnect?
Problems with Other Architectures
The IBM Shared-Nothing Configuration
Microsoft Federated Servers Database
Seeing
the High Availability Spectrum
Real
Application Clusters
Processing Prior to Cache Fusion
Oracle Real Application Clusters
Attributes of an Oracle RAC Cluster
Building an Oracle RAC Cluster
RAC Performance and Scalability
RAC 12c High Performance and Highly Available Databases
Growth of Powerful Processors
Why Parallel Processing?
Opportunities for Parallelism
Scalability
Parallel Databases
Types of Parallelism
High
Performance Computing Cluster HPCC
Clusterize Applications
How Do You Clusterize Applications?
Highly
Available Databases
Need for Highly Available Data
Failure
Availability
Reliability and Serviceability
Fault-tolerant Systems
Database Availability
Clustered Systems
Databases Issues
Oracle
RAC High Performance and Highly Available Database
Database Clusters
Overview of the Cluster Technology
How Clusters Differ from Distributed Systems
Clusters are Different from Fault-tolerant Systems
Database Clusters
Why Clusters?
Types
of Clusters
Failover Clusters
Scalable High Performance Clusters
Application Server Clusters
Other Types of Clusters
Components of a Cluster
Cluster Nodes
Emerging Server Cluster Architectures
Cluster Interconnect
Essentials for Parallel Database Clusters
Cluster Interconnect Products
Infiniband Interconnect
ClusterWare
Concurrent Database Access
Failover Database Clusters
Resources, Resource Type
Resource Groups
The Concept of a Virtual Server
Failover Process
Examples
Failover Cluster Architecture
Oracle Database Service in HA Cluster
Issues with FO Clusters Hidden Risks
Parallel Database Clusters
Shared-Nothing Model
Shared-Disk Model
Microsoft SQL Server Federated Database
IBM Offerings
Requirements for Parallel Clusters
Oracles Instance Membership Recovery
Cache Coherency and Lock Management
Real
Application Cluster Architecture
Overview of Oracle Real Application Clusters
RMAN for RAC
RAC Workload Management
RAC Scalability
High Availability
Architecture
Oracle12c Basic Processes
Oracle12c Basic Internal Structures
Oracle12c RAC Additional Processes
Oracle12c RAC Additional SGA Areas
RAC
Server Components
GCS Resource Modes and Roles
Accessing RAC
DAY 2
RAC Server and Disk Technology
Overview
Oracle12c RAC Disk System
Understanding Disks, LUNs, Volumes
Raw Volumes
File Systems
Storage Technology and Redundancy
Disk Systems
Understanding I/O
Path
Host Bus Adapters (HBA)
Storage Redundancy
Components
RAID and RAID
Administration
High Availability
of Storage
Logical Volume
Managers
Storage Areas
OCFS/OCFS2
RAW Volumes
ASM
Other CFS Solutions
Redundancy
Understanding RAID
Redundancy
Capabilities
Server Redundancy
Redundancy Types
RAC Installation and Configuration
Architecture and Components
Servers and
Operating System
Cluster
Interconnect and Public Switch
Oracle
Clusterware
Shared
Storage Subsystem
Overview of Installation Steps
Installation
of Oracle Clusterware
Installation
of Oracle for use with ASM
Installation
of Oracle for production database use
Oracle RAC Tools
crs_stat
olsnodes
srvctl
dbca
netca
Internals
of Real Application Clusters
Overview of Cache Fusion
Evolution of Cache Fusion
Nature of Cache Fusion
Benefits of Cache Fusion
Concurrency and Consistency
Cache Coherency
Global Cache Service
|
|
DAY
3
SGA
Components and Locking
SGA System Global Area
Program Global Area (PGA)
Buffer Cache Management
What is a Dirty Block?
Multi Version Consistency Model
RAC
Components
Global Cache Service
Global Enqueque Service
Row-Level Locks
Global Resource Directory
RAC Processes
Resource Coordination
Synchronization
GCS Resource Modes and Roles
Concept of Past Image
Lock Modes
Block Access Modes and Buffer States
Cache Fusion Scenarios
Block transfers using Cache Fusion Examples
Block Access, Grants, and Interrupts
Cache
Fusion and Recovery
Recovery Features
Recovery Methodology and Steps
Recovery Process Re-mastering Resources
12c RAC Administration
Parameter Management
Overview
RAC and Initialization Parameters
UNDO
Management
UNDO Management in RAC
UNDO Tablespace Features
System Rollback Segment
Concept
of Thread
Thread Features
Redo Thread Maintenance
Segment
Space Management
Automatic Segment Space Management
Manual Space Management
Oracle Managed Files
Using
SQL*Plus
Starting the Database in Cluster Mode
Using
Oracle DB Control for Clusters
Configuration of
DB control w/RAC
RAC
12c Backup and Recovery
Overview of RAC backup and Recovery
Export
Cold Backup using Scripts
Hot Backups using Scripts
RMAN (Recovery Manager)
Third Party Solutions
Backup
of RAC Database
Using RMAN for Backups
Backup Procedures RMAN and RAC
Recovery in the RAC Environment
Media Recovery in RAC Instances
Using RMAN to Recover a RAC Environment
Recovery in an OCFS Environment
Recovery in a Raw File System Environment
Parallel Recovery
Standby
Databases in RAC Configuration
Setting up a Standby Database for a RAC
Cluster to a Single-Instance (One Node)
Configuration when the Standby Database is a Single Node System
Cross-Instance Archival
Archive Log Gap Resolution and FAL
ASM and RMAN
Performing
advanced backup/ recovery techniques with ASM
SWITCH
DATABASE TO COPY
Keeping ASM
Clean
Failover and Load Balancing
Services In-depth
Failover
Load
Balancing
Planning and
Configuration
Connection Pools and Services
The Load Balancing Advisory
Monitoring Services
RAC Performance Monitoring and Tuning
Analysis of Performance Issues
Monitoring RAC
Cluster Interconnect
Using performance views
Using AWR
ADDM for RAC
Using DB Control to
Monitor RAC
RAC Design Consideration
Designing equipment for RAC
Effects of
component failure
Redundancy
at every level
Choosing Service/Nodes for Work
Sequences in RAC
Tablespace Design Considerations
Solid
State Disk Considerations
Table
Locks and Latch Waits
Scalability and Unpredictable Loads
Migration to RAC Databases
Overview
Migration Methodology
Moving from
Single Instance to RAC
Cloning
Overview
Migrating to
Oracle 12c
Rolling
Upgrades
Oracle 12c RAC
parallel upgrades
Oracle 12c RAC has a rolling
upgrade features whereby RAC database can be upgraded without any downtime.
Oracle 12c hot
patching
Oracle 12c RAC has a the ability to apply
patches on a node-by-node basis without service interruption.
Oracle 12c RAC load
balancing advisor
Starting in 10gr2 we see a
RAC load balancing advisor
utility. Oracle says that the 12c RAC load balancing advisor is only
available with clients which use .NET, ODBC, or the Oracle Call Interface
(OCI).
ADDM for RAC 12c
In Oracle 12c, ADDM has been extended to include RAC, and
provides information on the entire cluster including latency issues on the
cluster interconnect, global cache hot blocks (blocks with concurrency
issues across multiple nodes), and general object usage information across
multiple nodes.
12c RAC cache fusion
protocols
12c RAC improves the cache fusion layer for faster and
more efficient pinging between nodes
12c RAC ASMCA
Oracle 12c offers an ASM configuration assistant allows
you to install cluster file systems (ACFS), ASM instances, ASM volumes and
disk groups
Optimized 12c RAC cache fusion protocols
Extends the general cache fusion protocols in 10g to deal
with specific scenarios where the protocols could be further optimized.
Oracle 12c RAC Grid provisioning
The Oracle 12c grid control provisioning pack allows you
to "blow-out" a RAC node without the time-consuming install, using a
pre-installed "footprint".
|
