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

Oracle 11g R1/R2 Real Application Clusters Essentials

Credits

About the Authors

About the Reviewers

www.PacktPub.com

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

Clusterware Installation

Preparing for a cluster installation

Oracle 11g R1 Clusterware installation

Oracle 11g R2 Clusterware installation

Removing/Reconfiguring a Grid Infrastructure configuration

Summary

Automatic Storage Management

Overview of Automatic Storage Management (ASM)

ASM instance configuration and management

Overview of ASMCMD

ASM 11g R1 new features

ASM 11g R2 new features

ASM backup strategies

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 databases?

RAC database administration

Automatic Workload Management

What's new in Oracle 11g services' behavior?

Summary

Backup and Recovery

An overview of backup and recovery

An overview of Recovery Manager (RMAN)

Backup types and methods

RMAN new features in 11g R1 and 11g R2

RMAN best practices for RAC

OCR and Voting disk backup and recovery strategies

Summary

Performance Tuning

Tuning differences: single instance versus RAC

New Oracle 11g performance tuning features

New performance features in Oracle 11gR2

Analyzing the Cache Fusion impact on RAC performance

Monitoring RAC cluster interconnect performance

Oracle cluster interconnects

Monitoring RAC wait events

Summary

Oracle 11g Clusterware Upgrade

Overview of an upgrade

Upgrading Oracle 10g R2 Clusterware to Oracle 11g R1

Upgrading to Oracle 11g R2 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

Establishing applications environment for Oracle RAC

Setting up load balancing

Configuring Parallel Concurrent Processing

Cloning EBS concepts in brief

Summary

Maximum Availability

Oracle 11g Streams for RAC

Best practices for Streams in an RAC environment

New features for Streams in Oracle 11g R2

Oracle 11g Data Guard and RAC

New features for Data Guard in Oracle 11g R2

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

Index