PacktLib: Oracle 11g R1 / R2 Real Application Clusters Handbook

Oracle 11g R1/R2 Real Application Clusters Handbook

Credits

About the Authors

About the Reviewers

Preface

High Availability

High availability concepts

Fault tolerant systems and high availability

High Availability solutions for Oracle

Summary

Oracle 11g RAC Architecture

Oracle 11g RAC architecture

Hardware architecture for Oracle 11g RAC

Network architecture for Oracle 11g RAC

Storage architecture for Oracle 11g RAC

Storage protocols for RAC

Oracle 11g RAC components

New ASM features and RAC

New Oracle 11g ASM Disk Group compatibility features

Summary

Oracle 11g RAC Installation

What's new in Oracle Clusterware installation and configuration?

Oracle Clusterware installation configuration requirements

Installing Oracle Clusterware 11gR1

Installing Oracle RDBMS software 11gR1

Installing Oracle Clusterware 11gR2

Installing Oracle RDBMS software 11gR2

Installing Oracle RDBMS software 11gR2 RAC ONE Node

Summary

Oracle 11g Automatic Storage Management

A brief overview of Oracle Automatic Storage Management (ASM)

Understanding Automatic Storage Management concepts

Automatic Storage Management features in Oracle 11gR1

Automatic Storage Management features in Oracle 11gR2

Summary

Managing and Troubleshooting Oracle 11g Clusterware

Oracle 11g RAC Clusterware administration

Managing Oracle 11g Clusterware utilities

Troubleshooting Oracle 11g Clusterware

New features in Oracle 11g R2 Clusterware

Summary

RAC Database Administration and Workload Management

RAC database configuration and creation

What's new in Oracle 11g R1 and R2 database?

RAC database administration

Automatic Workload Management

What's new in Oracle 11g services behavior?

Summary

Backup and Recovery

Backup and recovery strategies

RMAN new features

OCR and voting disk backup and recovery

Summary

Performance Tuning

Single-instance database versus parallel database tuning considerations

New Oracle 11g performance tuning features

An overview of Oracle RAC Architecture

Tune Instance recovery in RAC

Analyzing the Cache Fusion impact on RAC performance

Examples of inter-instance communication

Monitoring RAC cluster interconnect performance

Monitoring RAC-specific wait events, global enqueues, and system statistics

Summary

Oracle 11g Clusterware Upgrade

Overview of an upgrade

Upgrading Oracle 10gR2 Clusterware to Oracle 11gR1

Upgrading to Oracle 11gR2 Clusterware

Downgrading Oracle Clusterware after an upgrade

Summary

Real-world Scenarios

Adding a new node to an existing cluster

Removing a node from the cluster

Adding an RAC database instance

Deleting an RAC database instance

Converting a single-instance database to an RAC database

Converting a single-instance database to an RAC database

Relocating an RAC database and instances across nodes

Summary

Enabling RAC for EBS

EBS architecture

Oracle 11g RAC suitability

Installing EBS 12.1.1

EBS implementation on Oracle 11g RAC

RAC enabling EBS 12.1.1

Summary

RAC and ASM for Advanced Users

What types of files does ASM support?

Creating and referencing ASM files in the database

Managing alias names for ASM filenames

Accessing ASM files with the XML DB virtual folder

Using DBMS_FILE transfer utility for ASM

Managing disk group directories

Managing disk group templates

ASM Command-line utility

Deploying ASM using SQL*Plus

Summary

ASM 11gR2 New Features

Automatic Storage Management Configuration Assistant (ASMCA)

Automatic Storage Management Dynamic Volume Manager (ADVM)

Automatic Storage Management Cluster File System (ACFS)

ACFS snapshots

ASM Intelligent Data Placement (IDP)

ASMCMD enhancements

Summary

Maximum Availability

Oracle 11g Streams for RAC

Best practices for Streams in an RAC environment

New features for Streams in Oracle 11gR2

Oracle 11g Data Guard and RAC

New features for Data Guard in Oracle 11gR2

Summary

Additional Resources and Tools for The Oracle RAC Professional

Additional Resources and Tools for The Oracle RAC Professional

Additional Resources and Tools for The Oracle RAC Professional

Additional Resources and Tools for The Oracle RAC Professional

Additional Resources and Tools for The Oracle RAC Professional

Additional Resources and Tools for The Oracle RAC Professional

Additional Resources and Tools for The Oracle RAC Professional