Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
-
1
Introduction to Oracle RAC
- Overview of Oracle RAC
- Overview of Oracle Multitenant with Oracle RAC
- Overview of Installing Oracle RAC
- Overview of Oracle Real Application Clusters One Node
-
Overview of Oracle Clusterware for Oracle RAC
- Guidelines for Using Oracle Clusterware
- Overview of Reader Nodes
-
Overview of Local Temporary Tablespaces
- Parallel Execution Support for Cursor-Duration Temporary Tablespaces
- Local Temporary Tablespace Organization
- Temporary Tablespace Hierarchy
- Local Temporary Tablespace Features
- Metadata Management of Local Temporary Files
- DDL Support for Local Temporary Tablespaces
- Local Temporary Tablespace for Users
- Atomicity Requirement for Commands
- Local Temporary Tablespace and Dictionary Views
-
Overview of Oracle RAC Architecture and Processing
- Understanding Cluster-Aware Storage Solutions
- Oracle RAC and Network Connectivity
- Overview of Using Dynamic Database Services to Connect to Oracle Databases
- Overview of Virtual IP Addresses
- Restricted Service Registration in Oracle RAC
- About Oracle RAC Software Components
- About Oracle RAC Background Processes
- 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 Database In-Memory and Oracle RAC
- Overview of Managing Oracle RAC Environments
-
2
Administering Storage in Oracle RAC
- About Oracle ASM
- 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
- Storage Management in Oracle RAC
- Modifying Disk Group Configurations for Oracle ASM
- Oracle ASM Disk Group Management
- Configuring Preferred Mirror Read Disks in Extended Distance Clusters
- Converting Nonclustered Oracle ASM to Clustered Oracle ASM
- Administering Oracle ASM Instances with SRVCTL in 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
- Pluggable Database Rank
- Pluggable Database Placement
- Reducing Downtime During Database and Instance Outages
- Verifying 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
- Customizing How Oracle Clusterware Manages Oracle RAC Databases
- Advanced Oracle Enterprise Manager Administration
- 4 Administering Oracle RAC One Node
-
5
Workload Management with Dynamic Database Services
- Connection Load-Balancing
- Load Balancing Advisory
-
Enabling Clients for Oracle RAC
- Overview of Oracle Integrated Clients and FAN
- Enabling JDBC-Thin Clients for Fast Connection Failover
- Enabling JDBC Clients for Run-time Connection Load Balancing
- Configuring JDBC-Thin Clients for Application Continuity for Java
- Configuring JDBC-Thin Clients for Transaction Guard
- Enabling OCI Clients for Fast Connection Failover
- Enabling OCI Clients for Run-time Connection Load Balancing
- Configuring OCI Clients to use Transaction Guard
- Enabling ODP.NET Clients to Receive FAN High Availability Events
- Enabling ODP.NET Clients to Receive FAN Load Balancing Advisory Events
- Configuring ODP.NET Clients to use Transaction Guard
- 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
- Using Oracle Services
- Service Deployment Options
-
Administering Services
- Overview of Service Administration
- Administering Services with Oracle Enterprise Manager
-
Administering Services with SRVCTL
- Creating Services with SRVCTL
- Creating Services for Application Continuity and Transaction Guard
- Starting and Stopping Services with SRVCTL
- Enabling and Disabling Services with SRVCTL
- Relocating Services with SRVCTL
- Obtaining the Status of Services with SRVCTL
- Obtaining the Configuration of Services with SRVCTL
- Global Services
- Service-Oriented Buffer Cache Access
- Connecting to a Service: An Example
-
6
Ensuring Application Continuity
-
Understanding Application Continuity
- About Application Continuity
- Key Concepts for Application Continuity
- How Application Continuity Works for Applications
- Potential Side Effects of Application Continuity
- Support for Oracle Application Continuity and Transparent Application Continuity
- Restrictions and Other Considerations for Application Continuity
- Transparent Application Continuity
-
Fast Application Notification (FAN)
- Overview of Fast Application Notification (FAN)
- The Importance of Using Fast Application Notification
- How FAN is Used with Oracle Database and Applications
- Requirements for Using FAN
- FAN Callouts
- Fast Application Notification High Availability Events
- Subscription to High Availability Events
- Using Fast Application Notification Callouts
- Managing Unplanned Outages
- Managing Planned Maintenance
-
Configuring Application Continuity
- Overview of Application Continuity Configuration Tasks
- Configuring Connections for High Availability and Application Continuity
- Configuring Oracle Database for Application Continuity
-
Establishing the Initial State Before Application Continuity Replays
- Checking Initial States for Application Continuity
- FAILOVER_RESTORE
- States Restored with FAILOVER_RESTORE
- FAILOVER_RESTORE Extended
- Configuring a Keystore for FAILOVER_RESTORE
- Configuring a Wallet and SQLNET.ORA for FAILOVER_RESTORE
- FAILOVER_RESTORE = NONE and No Callback
- Connection Labeling
- Connection Initialization Callback
- RESET_STATE
- Application Continuity Protection Check
-
Administering Application Continuity Operation and Usage
- Using Application Continuity for Planned Maintenance
- Administering Mutable Values
- Protection-Level Statistics
- Session State Consistency
- Delaying the Reconnection in Application Continuity
- Running Without Application Continuity
-
Disabling Replay in Application
Continuity
- Understanding Enabling and Disabling Replay in Application Continuity
- Application Calls Autonomous Transactions, External PL/SQL, or Java Actions that Should Not Be Repeated
- Application Synchronizes Independent Sessions
- Application Uses Time at the Middle Tier in the Execution Logic
- Application Assumes that ROWIds Do Not Change
- Application Assumes that Location Values Do Not Change
- Terminating or Disconnecting a Session Without Replay
- Transaction Guard for Improving Client Failover
- Failing Over OCI Clients with Transparent Application Failover
-
Understanding Application Continuity
-
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
- Managing Archived Redo Logs Using RMAN in Oracle RAC
- Archived Redo Log File Conventions in Oracle RAC
- RMAN Archiving Configuration Scenarios
- Monitoring the Archiver Processes
-
8
Managing Backup and Recovery
- Managing Backup and Recovery in Clusters
- RMAN Backup Scenario for Noncluster File System Backups
- RMAN Restore Scenarios for Oracle RAC
-
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 with RMAN
- 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
- Using a Fast Recovery Area in Oracle RAC
- 9 Cloning Oracle RAC to Nodes in a New Cluster
- 10 Using Cloning to Extend Oracle RAC to Nodes in the Same Cluster
- 11 Adding and Deleting Oracle RAC from Nodes on Linux and Unix Systems
- 12 Adding and Deleting Oracle RAC from Nodes on Windows Systems
-
13
Design and Deployment Techniques
- Deploying Oracle RAC for High Availability
- 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 in Oracle RAC
- Data Security Considerations in Oracle RAC
-
14
Monitoring Performance
- Monitoring and 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
- Overview of Converting Databases to Oracle RAC Using DBCA
- Converting Oracle Database Installations to Oracle RAC Using DBCA
- Converting Single Instance on a Cluster to Oracle RAC One Node Using DBCA
- Converting Single Instance on a Cluster to Oracle RAC Using DBCA
- 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
-
SRVCTL Command Reference
- About Using SRVCTL Commands
-
database Commands
- srvctl add database
- srvctl config database
- srvctl convert database
- srvctl disable database
- srvctl downgrade database
- srvctl enable database
- srvctl getenv database
- srvctl modify database
- srvctl predict database
- srvctl relocate database
- srvctl remove database
- srvctl setenv database
- srvctl start database
- srvctl status database
- srvctl stop database
- srvctl unsetenv database
- srvctl update database
- srvctl upgrade database
- diskgroup Commands
- home Commands
- instance Commands
-
listener Commands
- srvctl add listener
- srvctl config listener
- srvctl disable listener
- srvctl enable listener
- srvctl getenv listener
- srvctl modify listener
- srvctl predict listener
- srvctl remove listener
- srvctl setenv listener
- srvctl start listener
- srvctl status listener
- srvctl stop listener
- srvctl unsetenv listener
- srvctl update listener
- network Commands
- nodeapps Commands
- ons Commands
- pdb Commands
- scan Commands
-
scan_listener Commands
- srvctl add scan_listener
- srvctl config scan_listener
- srvctl disable scan_listener
- srvctl enable scan_listener
- srvctl export scan_listener
- srvctl modify scan_listener
- srvctl predict scan_listener
- srvctl relocate scan_listener
- srvctl remove scan_listener
- srvctl start scan_listener
- srvctl status scan_listener
- srvctl stop scan_listener
- srvctl update scan_listener
- server Commands
- service Commands
- srvpool Commands
- vip Commands
- volume Commands
-
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