Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

What's New in Oracle RAC Administration and Deployment?

• Oracle Database 11g Release 2 (11.2) New Features in Oracle RAC

1 Introduction to Oracle RAC

• Overview of Oracle RAC
• Overview of Oracle Clusterware for Oracle RAC
• Overview of Oracle RAC Architecture and Processing
  • Understanding Cluster-Aware Storage Solutions
  • Overview of Connecting to Oracle Database Using Services and VIP Addresses
  • About Oracle RAC Software Components
  • About Oracle RAC Background Processes
• Overview of Automatic Workload Management
• Overview of Installing Oracle RAC
  • Understanding Compatibility in Oracle RAC Environments
  • Overview of Oracle RAC Installation and Database Creation
  • Overview of Extending the Grid Foundation and Oracle RAC Software
• Overview of Managing Oracle RAC Environments
  • About Designing and Deploying Oracle RAC Environments
  • About Administrative Tools for Oracle RAC Environments
  • About Monitoring Oracle RAC Environments
  • About Evaluating Performance in Oracle RAC Environments

2 Administering Storage

• Overview of Storage in Oracle RAC
• Optimal Flexible Architecture
• Data File Access in Oracle RAC
• Redo Log File Storage in Oracle RAC
• Automatic Undo Management in Oracle RAC
• Oracle Automatic Storage Management in Oracle RAC
  • Storage Management in Oracle RAC
  • Modifying Disk Group Configurations for Oracle ASM in Oracle RAC
  • Oracle ASM Disk Group Management
  • Configuring Preferred Mirror Read Disks in Extended Distance Clusters
  • Converting Single-Instance Oracle ASM to Clustered Oracle ASM
  • Administering Oracle ASM Instances with SRVCTL in Oracle RAC

3 Administering Database Instances and Cluster Databases

• Tools for Administering Oracle RAC
  • Oracle RAC Database Administration
  • Administering Oracle RAC with Oracle Enterprise Manager
  • Administering Oracle RAC with SQL*Plus
    • Changing the SQL*Plus Prompt
    • How SQL*Plus Commands Affect Instances
  • Administering Oracle RAC with SRVCTL
• Starting and Stopping Instances and Oracle RAC Databases
  • Starting and Stopping with Oracle Enterprise Manager
  • Starting Up and Shutting Down with SQL*Plus
  • Starting Up and Shutting Down with SRVCTL
• Verifying That Instances are Running
• Terminating Sessions On a Specific Cluster Instance
• Overview of Initialization Parameter Files in Oracle RAC
  • Setting SPFILE Parameter Values for Oracle RAC
  • Parameter File Search Order in Oracle RAC
  • Backing Up the Server Parameter File
• Initialization Parameter Use in Oracle RAC
  • Parameters That Must Have Identical Settings on All Instances
  • Parameters That Have Unique Settings on All Instances
  • Parameters That Should Have Identical Settings on All Instances
• Quiescing Oracle RAC Databases
• Administering Multiple Cluster Interconnects on Linux and UNIX Platforms
  • Recommendations for Setting the CLUSTER_INTERCONNECTS Parameter
  • Usage Examples for the CLUSTER_INTERCONNECTS Parameter
• Customizing How Oracle Clusterware Manages Oracle RAC Databases
• Advanced Oracle Enterprise Manager Administration
  • Using Oracle Enterprise Manager Grid Control to Discover Nodes and Instances
  • Administering Jobs and Alerts in Oracle RAC
    • Administering Jobs in Oracle RAC
    • Administering Alerts in Oracle RAC with Oracle Enterprise Manager
    • Performing Scheduled Maintenance Using Defined Blackouts in Oracle Enterprise Manager

4 Introduction to Automatic Workload Management

• Overview of Automatic Workload Management
• Automatic Workload Repository
• Service Deployment Options
  • Using Oracle Services
  • Default Service Connections
  • Connection Load Balancing
• Fast Application Notification
  • Overview of Fast Application Notification
  • Application High Availability with Services and FAN
  • Managing Unplanned Outages
  • Managing Planned Outages
  • Fast Application Notification High Availability Events
  • Using Fast Application Notification Callouts
• Load Balancing Advisory
  • Overview of the Load Balancing Advisory
  • Configuring Your Environment to Use the Load Balancing Advisory
  • Load Balancing Advisory FAN Events
• Oracle Clients That Are Integrated with Fast Application Notification
  • Enabling JDBC Clients for Fast Connection Failover
    • Using FAN with Thick JDBC and Thin JDBC Clients
  • Enabling Oracle Call Interface Clients for Fast Connection Failover
  • Enabling Oracle Call Interface Clients for Run Time Connection Load Balancing
  • Enabling ODP.NET Clients to Receive FAN High Availability Events
  • Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory Events
• Enabling Event Notification for Connection Failures in Oracle RAC
• Services and Distributed Transaction Processing in Oracle RAC
• Enabling Distributed Transaction Processing for Services
• Administering Services
• Administering Services with Oracle Enterprise Manager and SRVCTL
  • Administering Services with Oracle Enterprise Manager
    • Service-Related Tasks That You Can Perform with Oracle Enterprise Manager
    • Cluster Managed Database Services Page
    • Cluster Managed Database Services Detail Page
    • Create Services Page
    • Accessing the Oracle Enterprise Manager Services Pages
  • Administering Services with SRVCTL
    • Creating Services with SRVCTL
    • Starting and Stopping Services with SRVCTL
    • Enabling and Disabling Services with SRVCTL
    • Relocating Services with SRVCTL
    • Obtaining the Statuses of Services with SRVCTL
    • Obtaining the Configuration of Services with SRVCTL
• Measuring Performance by Service Using the Automatic Workload Repository
• Service Thresholds and Alerts
  • Example of Services and Thresholds Alerts
  • Enable Service, Module, and Action Monitoring

5 Configuring Recovery Manager and Archiving

• Overview of Configuring RMAN for Oracle RAC
• Configuring the RMAN Snapshot Control File Location
• Configuring RMAN to Automatically Backup the Control File and SPFILE
• Crosschecking on Multiple Oracle RAC Nodes
• Configuring Channels for RMAN in Oracle RAC
  • Configuring Channels to Use Automatic Load Balancing
  • Configuring Channels to Use a Specific Channel
• Managing Archived Redo Logs Using RMAN in Oracle RAC
• Archived Redo Log File Conventions in Oracle RAC
• RMAN Archiving Configuration Scenarios
  • Oracle Automatic Storage Management and Cluster File System Archiving Scheme
    • Advantages of the Cluster File System Archiving Scheme
    • Initialization Parameter Settings for the Cluster File System Archiving Scheme
    • Location of Archived Logs for the Cluster File System Archiving Scheme
  • Noncluster File System Local Archiving Scheme
    • Considerations for Using Noncluster File System Local Archiving
    • Initialization Parameter Settings for Noncluster File System Local Archiving
    • Location of Archived Logs for Noncluster File System Local Archiving
    • File System Configuration for Noncluster File System Local Archiving
• Changing the Archiving Mode in Oracle RAC
• Monitoring the Archiver Processes

6 Cloning Oracle RAC to Nodes in a Cluster

• Introduction to Cloning Oracle RAC
• Preparing to Clone Oracle RAC
• Cloning Oracle RAC to Nodes in a Cluster
  • Deploying Oracle RAC Database Homes
• Locating and Viewing Log Files Generated During Cloning

7 Managing Backup and Recovery

• RMAN Backup Scenario for Noncluster File System Backups
• RMAN Restore Scenarios for Oracle RAC
  • Cluster File System Restore Scheme
  • Noncluster File System Restore Scheme
  • Using RMAN or Oracle Enterprise Manager to Restore the Server Parameter File (SPFILE)
• Instance Recovery in Oracle RAC
  • Single Node Failure in Oracle RAC
  • Multiple-Node Failures in Oracle RAC
  • Using RMAN to Create Backups in Oracle RAC
  • Channel Connections to Cluster Instances
  • Node Affinity Awareness of Fast Connections
  • Deleting Archived Redo Logs after a Successful Backup
  • Autolocation for Backup and Restore Commands
• Media Recovery in Oracle RAC
• Parallel Recovery in Oracle RAC
  • Parallel Recovery with RMAN
  • Disabling Parallel Recovery
    • Disabling Instance and Crash Recovery Parallelism
    • Disabling Media Recovery Parallelism
• Using a Flash Recovery Area in Oracle RAC

8 Using Cloning to Extend Oracle RAC to Nodes in the Same Cluster

• Adding Nodes Using Cloning in Oracle RAC Environments
  • Using Cloning to Add Nodes to Oracle RAC Environments on Windows Systems

9 Adding and Deleting Oracle RAC from Nodes on Linux and UNIX Systems

• Adding Oracle RAC to Nodes with Oracle Clusterware Installed
  • Adding Oracle RAC Database Instances to Target Nodes
    • Using DBCA in Interactive Mode to Add Database Instances to Target Nodes
    • Using DBCA in Silent Mode to Add Database Instances to Target Nodes
• Deleting Oracle RAC from a Cluster Node
  • Deleting Instances from Oracle RAC Databases
    • Using DBCA in Interactive Mode to Delete Instances from Nodes
    • Using DBCA in Silent Mode to Delete Instances from Nodes
  • Removing Oracle RAC
  • Deleting Nodes from the Cluster

10 Design and Deployment Techniques

• Deploying Oracle RAC for High Availability
  • Best Practices for Deploying Oracle RAC in a High Availability Environment
  • Consolidating Multiple Applications in a Database or Multiple Databases in a Cluster
  • Scalability of Oracle RAC
• General Design Considerations for Oracle RAC
• General Database Deployment Topics for Oracle RAC
  • Tablespace Use in Oracle RAC
  • Object Creation and Performance in Oracle RAC
  • Node Addition and Deletion and the SYSAUX Tablespace in Oracle RAC
  • Distributed Transactions and Oracle RAC
  • Deploying OLTP Applications in Oracle RAC
  • Flexible Implementation with Cache Fusion
  • Deploying Data Warehouse Applications with Oracle RAC
    • Speed-Up for Data Warehouse Applications on Oracle RAC
    • Parallel Execution in Data Warehouse Systems and Oracle RAC
  • Data Security Considerations in Oracle RAC
    • Transparent Data Encryption and Wallets
    • Windows Firewall Considerations

11 Monitoring Performance

• Overview of Monitoring and Tuning Oracle RAC Databases
  • Monitoring Oracle RAC and Oracle Clusterware
    • The Cluster Database Home Page
    • The Interconnects Page
    • The Cluster Performance Page
  • Tuning Oracle RAC Databases
• Verifying the Interconnect Settings for Oracle RAC
• Influencing Interconnect Processing
• Performance Views in Oracle RAC
• Creating Oracle RAC Data Dictionary Views with CATCLUST.SQL
• Oracle RAC Performance Statistics
• Automatic Workload Repository in Oracle RAC Environments
• Active Session History Reports for Oracle RAC
  • Overview of ASH Reports for Oracle RAC
  • ASH Report for Oracle RAC: Top Cluster Events
  • ASH Report for Oracle RAC: Top Remote Instance
• Monitoring Oracle RAC Statistics and Wait Events
  • Oracle RAC Statistics and Events in AWR and Statspack Reports
  • Oracle RAC Wait Events
  • Monitoring Performance by Analyzing GCS and GES Statistics
    • Analyzing the Effect of Cache Fusion in Oracle RAC
    • Analyzing Performance Using GCS and GES Statistics
  • Analyzing Cache Fusion Transfer Impact Using GCS Statistics
  • Analyzing Response Times Based on Wait Events

A Server Control Utility Reference

• Using SRVCTL
  • Overview of SRVCTL
  • Operational Notes for SRVCTL
    • Usage Information
    • Character Set and Case Sensitivity of Object Values
    • Summary of Tasks for Which SRVCTL Is Used
    • Using SRVCTL Help
    • Privileges and Security
  • Additional Topics on SRVCTL
  • Deprecated Subprograms or Commands
• SRVCTL Command Reference
  • add
    • srvctl add asm
    • srvctl add database
    • srvctl add eons
    • srvctl add filesystem
    • srvctl add gns
    • srvctl add instance
    • srvctl add listener
    • srvctl add nodeapps
    • srvctl add oc4j
    • srvctl add ons
    • srvctl add scan
    • srvctl add scan_listener
    • srvctl add service
    • srvctl add srvpool
    • srvctl add vip
  • config
    • srvctl config asm
    • srvctl config database
    • srvctl config eons
    • srvctl config filesystem
    • srvctl config gns
    • srvctl config listener
    • srvctl config nodeapps
    • srvctl config oc4j
    • srvctl config ons
    • srvctl config scan
    • srvctl config scan_listener
    • srvctl config service
    • srvctl config srvpool
    • srvctl config vip
  • disable
    • srvctl disable asm
    • srvctl disable database
    • srvctl disable diskgroup
    • srvctl disable eons
    • srvctl disable filesystem
    • srvctl disable gns
    • srvctl disable instance
    • srvctl disable listener
    • srvctl disable nodeapps
    • srvctl disable oc4j
    • srvctl disable ons
    • srvctl disable scan
    • srvctl disable scan_listener
    • srvctl disable service
    • srvctl disable vip
  • enable
    • srvctl enable asm
    • srvctl enable database
    • srvctl enable diskgroup
    • srvctl enable eons
    • srvctl enable filesystem
    • srvctl enable gns
    • srvctl enable instance
    • srvctl enable listener
    • srvctl enable nodeapps
    • srvctl enable oc4j
    • srvctl enable ons
    • srvctl enable scan
    • srvctl enable scan_listener
    • srvctl enable service
    • srvctl enable vip
  • getenv
    • srvctl getenv asm
    • srvctl getenv database
    • srvctl getenv listener
    • srvctl getenv nodeapps
    • srvctl getenv vip
  • modify
    • srvctl modify asm
    • srvctl modify database
    • srvctl modify eons
    • srvctl modify filesystem
    • srvctl modify gns
    • srvctl modify instance
    • srvctl modify listener
    • srvctl modify nodeapps
    • srvctl modify oc4j
    • srvctl modify ons
    • srvctl modify scan
    • srvctl modify scan_listener
    • srvctl modify service
    • srvctl modify srvpool
  • relocate
    • srvctl relocate gns
    • srvctl relocate oc4j
    • srvctl relocate scan
    • srvctl relocate scan_listener
    • srvctl relocate server
    • srvctl relocate service
  • remove
    • srvctl remove asm
    • srvctl remove database
    • srvctl remove diskgroup
    • srvctl remove eons
    • srvctl remove filesystem
    • srvctl remove gns
    • srvctl remove instance
    • srvctl remove listener
    • srvctl remove nodeapps
    • srvctl remove oc4j
    • srvctl remove ons
    • srvctl remove scan
    • srvctl remove scan_listener
    • srvctl remove service
    • srvctl remove srvpool
    • srvctl remove vip
  • setenv
    • srvctl setenv asm
    • srvctl setenv database
    • srvctl setenv listener
    • srvctl setenv nodeapps
    • srvctl setenv vip
  • start
    • srvctl start asm
    • srvctl start database
    • srvctl start diskgroup
    • srvctl start eons
    • srvctl start filesystem
    • srvctl start gns
    • srvctl start home
    • srvctl start instance
    • srvctl start listener
    • srvctl start nodeapps
    • srvctl start oc4j
    • srvctl start ons
    • srvctl start scan
    • srvctl start scan_listener
    • srvctl start service
    • srvctl start vip
  • status
    • srvctl status asm
    • srvctl status database
    • srvctl status diskgroup
    • srvctl status eons
    • srvctl status filesystem
    • srvctl status gns
    • srvctl status home
    • srvctl status instance
    • srvctl status listener
    • srvctl status nodeapps
    • srvctl status oc4j
    • srvctl status ons
    • srvctl status scan
    • srvctl status scan_listener
    • srvctl status server
    • srvctl status service
    • srvctl status srvpool
    • srvctl status vip
  • stop
    • srvctl stop asm
    • srvctl stop database
    • srvctl stop diskgroup
    • srvctl stop eons
    • srvctl stop filesystem
    • srvctl stop gns
    • srvctl stop home
    • srvctl stop instance
    • srvctl stop listener
    • srvctl stop nodeapps
    • srvctl stop oc4j
    • srvctl stop ons
    • srvctl stop scan
    • srvctl stop scan_listener
    • srvctl stop service
    • srvctl stop vip
  • unsetenv
    • srvctl unsetenv asm
    • srvctl unsetenv database
    • srvctl unsetenv listener
    • srvctl unsetenv nodeapps
    • srvctl unsetenv vip

B Troubleshooting Oracle RAC

• Where to Find Files for Analyzing Errors
• Managing Diagnostic Data in Oracle RAC
• Using Instance-Specific Alert Files in Oracle RAC
• Enabling Tracing for Java-Based Tools and Utilities in Oracle RAC
• Resolving Pending Shutdown Issues
• How to Determine If Oracle RAC Instances Are Using the Private Network

Glossary

Index