Oracle Training Overview
This Oracle RAC Administration training course teaches attendees how to install, configure, and manage Oracle RAC (Real Application Clusters).
Location and Pricing
Accelebrate offers instructor-led enterprise training for groups of 3 or more online or at your site. Most Accelebrate classes can be flexibly scheduled for your group, including delivery in half-day segments across a week or set of weeks. To receive a customized proposal and price quote for private corporate training on-site or online, please contact us.
In addition, some courses are available as live, instructor-led training from one of our partners.
Objectives
- Create clustered databases, convert from single instance to RAC
- Carry out basic RAC administration, backup and recovery, and performance tuning
- Configure RAC database services for zero downtime
- Use GI to manage virtual IP addresses
- Configure shared storage
Prerequisites
- Understanding of Oracle database and instance architecture
- Familiarity with SQL and basic PL/SQL
- Knowledge of TCP/IP networking and file system administration
- Able to work with Linux command-line tools
Outline
Expand All | Collapse All
Introduction
RAC and Grid Infrastructure Architectural summary
- ASM and shared storage
- The two-tier listener model: SCAN listeners and node listeners
- RAC and GI capabilities
Real Application Clusters Database Installation
- Installing Oracle Database Software
- Single Instance to RAC conversion
- Creating A Cluster Database
Oracle RAC Administration
- Redo Log Files In A RAC Environment
- Undo Tablespaces In A RAC Environment
- Starting And Stopping RAC Databases And Instances
- Initialization Parameters In A RAC Environment
Managing Backup and Recovery for RAC
- Protecting Against Media Failure
- Archived Log File Configurations
- Database Backup and Recovery with RMAN
- Recovery following instance failure
Performance Tuning
- The Tuning Methodology
- The global cache and the global enqueue service
- RAC Specific Statistics and Wait Events
- Tuning Parallel Processing
- RAC Specific Performance Issues
- AWR and Statspack in a clustered environment
High Availability and Services
- RAC Service Architecture
- Configure and Manage Services in a RAC environment
- Using Services with Client Applications
- The fault-tolerant architecture
- Instance evictions
- Policy managed databases and services
- Stretched clusters
- Maximum Availability Architecture: RAC plus Data Guard
Practical Exercises
- Install a RAC database home
- Convert a single instance database to RAC
- Create a RAC database
- Configure RMAN for a RAC database
- Backup, restore, and recover a RAC database
- Tune parallel query and parallel DML in a RAC
- Convert databases between administrator management and policy management
- Use services for high availability and load balancing
- Set up session connect time load balancing and fault tolerance
- Configure session failover
Conclusion
Training Materials
All Oracle training students receive comprehensive courseware and a related textbook.
Software Requirements
- At least 8 GB RAM
- A complete installation of Oracle
- Oracle SQL Developer
- Please contact us for detailed setup instructions if you have purchased this class
