List of Tables
Title and Copyright Information
Preface
- Audience
- Documentation Accessibility
- Related Documents
- Conventions
Changes in This Release for Oracle Real Application Clusters Administration and Deployment Guide
- Changes in Oracle Real Application Clusters Release 19c
- Changes in Oracle Real Application Clusters Release 18c, Version 18.1
- Changes in Oracle Real Application Clusters 12c Release 2 (12.2)
- Changes in Oracle Real Application Clusters 12c Release 1 (12.1)
1 Introduction to Oracle RAC
- Overview of Oracle RAC
- Overview of Installing Oracle RAC
- Overview of Oracle Real Application Clusters One Node
- Overview of Oracle Clusterware for Oracle RAC
- Overview of Oracle RAC Architecture and Processing
- Overview of Automatic Workload Management with Dynamic Database Services
- Overview of Server Pools and Policy-Managed Databases
- Overview of Oracle Database Quality of Service Management
- Overview of Hang Manager
- Overview of Oracle Multitenant with Oracle RAC
- Overview of Database In-Memory and Oracle RAC
- Overview of Managing Oracle RAC Environments
2 Administering Storage in Oracle RAC
- Overview of Storage Management for Oracle RAC
- Data File Access in Oracle RAC
- NFS Server for Storage
- Redo Log File Storage in Oracle RAC
- Automatic Undo Management in Oracle RAC
- Oracle Automatic Storage Management with Oracle RAC
3 Administering Database Instances and Cluster Databases
- Overview of Oracle RAC Database Administration
  - Tools for Administering Oracle RAC
- Starting and Stopping Instances and Oracle RAC Databases
- Starting and Stopping PDBs in Oracle RAC
- Verifying That Instances are Running
  - Using SRVCTL to Verify That Instances are Running
  - Using SQL*Plus to Verify That Instances are Running
- Terminating Sessions On a Specific Cluster Instance
- Overview of Initialization Parameter Files in Oracle RAC
- Initialization Parameter Use in Oracle RAC
- Converting an Administrator-Managed Database to a Policy-Managed Database
- Managing Memory Pressure for Database Servers
- Quiescing Oracle RAC Databases
- Administering Multiple Cluster Interconnects on Linux and UNIX Platforms
  - Use Cases for Setting the CLUSTER_INTERCONNECTS Parameter
- Customizing How Oracle Clusterware Manages Oracle RAC Databases
- Advanced Oracle Enterprise Manager Administration
4 Administering Oracle RAC One Node
- Creating an Oracle RAC One Node Database
- Converting Databases
  - Converting a Database from Oracle RAC to Oracle RAC One Node
  - Converting a Database from Oracle RAC One Node to Oracle RAC
- Online Database Relocation
5 Workload Management with Dynamic Database Services
- Connection Load Balancing
- Load Balancing Advisory
- Enabling Clients for Oracle RAC
- Distributed Transaction Processing in Oracle RAC
- Oracle RAC Sharding
- Automatic Workload Repository
- Measuring Performance by Service Using the Automatic Workload Repository
- Automatic Workload Repository Service Thresholds and Alerts
  - Example of Services and Thresholds Alerts
  - Enable Service, Module, and Action Monitoring
- Using Oracle Services
- Service Deployment Options
- Administering Services
- Global Services
- Service-Oriented Buffer Cache Access
- Connecting to a Service: An Example
6 Ensuring Application Continuity
- Fast Application Notification
- Managing Unplanned Outages
- Managing Planned Maintenance
- About Application Continuity
  - Key Concepts for Application Continuity
  - Transparent Application Continuity
    - Transparent Application Continuity for Various Applications
- Application Continuity Operation and Usage
- Potential Side Effects of Application Continuity
- Restrictions and Other Considerations for Application Continuity
- Transaction Guard for Improving Client Failover
  - Transaction Guard Configuration Checklist
  - Configuring Services for Transaction Guard
- Failing Over OCI Clients with TAF
7 Configuring Recovery Manager and Archiving
- Overview of Configuring RMAN for Oracle RAC
- Archiving Mode in 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 Node
- 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
  - Noncluster File System Local Archiving Scheme
- Monitoring the Archiver Processes
8 Managing Backup and Recovery
- RMAN Backup Scenario for Noncluster File System Backups
- RMAN Restore Scenarios for Oracle RAC
- Instance Recovery in Oracle RAC
- 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 Fast Recovery Area in Oracle RAC
9 Cloning Oracle RAC to Nodes in a New Cluster
- Introduction to Cloning Oracle RAC
- Preparing to Clone Oracle RAC
- Deploying Oracle RAC Clone to Nodes in a Cluster
- Locating and Viewing Log Files Generated During Cloning
10 Using Cloning to Extend Oracle RAC to Nodes in the Same Cluster
- About Adding Nodes Using Cloning in Oracle RAC Environments
- Cloning Local Oracle Homes on Linux and UNIX Systems
- Cloning Shared Oracle Homes on Linux and UNIX Systems
- Cloning Oracle Homes on Windows Systems
11 Adding and Deleting Oracle RAC from Nodes on Linux and UNIX Systems
- Adding Oracle RAC to Nodes with Oracle Clusterware Installed
  - Adding Policy-Managed Oracle RAC Database Instances to Target Nodes
  - Adding Administrator-Managed 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
12 Adding and Deleting Oracle RAC from Nodes on Windows Systems
- Adding Oracle RAC to Nodes with Oracle Clusterware Installed
  - Adding Administrator-Managed 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
13 Design and Deployment Techniques
- Deploying Oracle RAC for High Availability
- General Design Considerations for Oracle RAC
- General Database Deployment Topics for Oracle RAC
14 Monitoring Performance
- Overview of Monitoring and Tuning Oracle RAC Databases
  - Monitoring Oracle RAC and Oracle Clusterware
  - 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
- Monitoring Oracle RAC Statistics and Wait Events
15 Converting Single-Instance Oracle Databases to Oracle RAC and Oracle RAC One Node
- Administrative Issues for Converting Databases to Oracle RAC
- Converting to Oracle RAC and Oracle RAC One Node Using DBCA
- Preparing to Convert with rconfig and Oracle Enterprise Manager
- Converting Databases to Oracle RAC Using rconfig
- Example of rconfig XML Input Files for ConvertToRAC
- Postconversion Steps
A Server Control Utility Reference
- SRVCTL Usage Information
- Specifying Command Parameters as Keywords Instead of Single Letters
- Character Set and Case Sensitivity of SRVCTL Object Values
- Summary of Tasks for Which SRVCTL Is Used
- Using SRVCTL Help
- SRVCTL Privileges and Security
- Additional SRVCTL Topics
- Deprecated SRVCTL Subprograms or Commands
  - Single Character Parameters for all SRVCTL Commands
  - Miscellaneous SRVCTL Commands and Parameters
- SRVCTL Command Reference
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