Oracle RAC
Module 1: Oracle Real Application Clusters Overview
- Oracle RAC Features
- Oracle RAC Technology Hierarchy
- Oracle RAC Capabilities
- Oracle RAC Components
- Tools for Installing, Configuring and Managing Oracle RAC
Module 2: Oracle Grid Infrastructure Overview
- Cluster Overview
- Grid Foundation Components and Architecture
- Oracle Clusterware Components and RAC
- Oracle Clusterware Software and Storage
- Oracle Storage Subsystems
- File Types used by a RAC Database
- Methods used to Share Database Files across a Cluster
- ASM Architecture
- Create and Manage ASM Disk Groups
- Create and Manage ASM Cluster Filesystems
- An Overview of RAC Services
- Network Configuration
Module 3: RAC Installation Tasks
- Oracle RAC Pre-installation Tasks
- Create Oracle Groups, User Accounts and Directories
- Validate and Prepare the Hardware and the Operating System
- Network Configuration
Module 4: Install Oracle Grid Infrastructure and Real Application Clusters
- Install the Oracle Grid Infrastructure
- Cluster Verification Utility (CVU, CLUVFY)
- Install Oracle Database Software and Create a Cluster Database
- Verify the Installation
- Post Installation Tasks
- Configure Client Connections with Oracle Net Manager
- Convert an Oracle Database to a RAC Database
- Use the DBCA for Single Instance Conversion
- Use rconfig for Single Instance Conversion
- RAC Specific Background Processes
Module 5: RAC Cluster Database and Database Instance Administration
- RAC Initialization Parameters
- Manage Undo Tablespaces in a RAC Environment
- Manage Redo Log Files and Groups in a RAC Environment
- Oracle Enterprise Manager Cluster Database Pages
- Start and Stop Oracle RAC Databases and Instances
- Administer Database Storage
- Transparent Data Encryption and Wallets in RAC
Module 6: Administer Oracle Clusterware Components
- Manage CRS Commands
- CRSCTL Commands to Stop, Start and Administer Clusterware
- Backup and Recover Voting Disks
- Add and Remove Voting Disks
- The ocrcheck Utility
- The ocrdump Command
- Administer the Oracle Cluster Registry (OCR)
- Backup and Restore OCR
- Troubleshoot the OCR with ocrcheck
Module 7: ASM Instance Administration
- ASM Initialization Parameters
- Create an ASM Instance using ASMCA
- Start and Stop an ASM Instance using srvctl
- Start and Stop an ASM Instance using ASMCMD
- Start and Stop an ASM Instance Containing Cluster Files
- Start and Stop the ASM Listener
Module 8: ASM Disk Group Administration
- Create and Delete ASM Disk Groups
- ASM Disk Group Attributes
- ASM Disk Group Maintenance Tasks
- Preferred Read Failure Groups
- ASM Disk Statistics
Module 9: ASM Cluster File System Administration
- ASM Dynamic Volume Manager
- Manage ASM Volumes
- Create an ASM Cluster File System (ACFS)
- Manage a ACFS File System
- ACFS Snapshots
- Manage ACFS with Command Line Tools
Module 10: RAC Management Commands
- RAC Management Commands
- RAC Administration with SVRCTL
- SVRCTL Cluster Database Configuration Tasks
- SVRCTL Cluster Database Administration Tasks
- Check the Current Configuration
- SVRCTL Command Summary
- Administer Databases and Instances
- Administer Services and Node Applications
- Bring a Cluster Database online and offline
- Introduction to CRS
- Cluster Services
Module 11: Managing the Database Workload using Services
- Manage the Database Workload using Services
- Create and Administer Services in a RAC Environment
- Services and Client Applications
- Manage Services with Enterprise Manager and from the Command Line
- Configure Oracle Net to Support Services
- Configure Service Level Thresholds
- Configure Clients for Failover
Module 12: High Availability of Connections
- RAC High Availability Framework
- Failure Detection with Cluster Services
- Oracle RAC and Hardware Failover
- Connection Failover
- Transparent Application Failover (TAF)
- Server, Client And Runtime Load Balancing
- Fast Application Notification (FAN)
- Server and Client Side Oracle Notification Services
Module 13: Backup and Recover a RAC Database
- Configure a Fast Recovery Area for use with RAC
- Tune Instance Recovery in RAC
- Parallel Recovery in RAC
- Initiate Archiving
- Configure RMAN Backup and Recovery Settings
- Backup a RAC Database using RMAN
- Restore and Recover a RAC Database using RMAN
- Display Backup Reports
Module 14: Create Duplicate and Standby Databases with RAC
- Duplicate a RAC Database with RMAN
- Standby Database in a RAC Configuration
- Configure Data Guard for a RAC Environment
- Possible Combinations of Instances in the RAC Primary and Standby Databases
- Multi Instance Primary with a Single Instance Standby
- Set up a Primary in a RAC Environment
- Set up a Single Instance Standby Database
- Set up a Multiple Instance Primary and Cluster Standby
- Configure RAC Primary and Standby Databases
- Data Protection Modes
- Role Transition Switchovers and Failovers
- Switchover Failover in an Oracle RAC Configuration
Module 15: RAC Performance Tuning
- Monitoring and Performance Guidelines
- RAC Monitoring Tools
- RAC Performance Recommendations
- Analyze Performance Issues using OS Watcher and LTOM
- Use the Automatic Workload Repository in RAC
- Use the Automatic Database Diagnostic Monitor in RAC
- Use Statspack with RAC
- Global Cache Services (GCS) Monitoring
- V$cache_transfer Views
- Monitor the GES Processes
- Monitor and Tune the RAC Cluster Environment using Enterprise Manager
Module 16: Add and Delete Nodes and Clusters
- Prepare a New Node
- Extend the Oracle Grid Infrastructure Home to the New Node
- Extend the Oracle RAC Home Directory
- Add the New Node to the Cluster
- Create an Instance on the New Node
- Delete an Instance from the Cluster Database
- Remove a Node from the Cluster
Module 17: Manage Oracle Software and Apply Patches
- Configure the EM Patch Interface
- Obtain Patches
- Apply Rolling Patches to a RAC System
- Apply a Patchset with the opatch Utility
- Apply a Patchset with OUI