Visão Geral

Este curso aborda a administração do Oracle Real Application Clusters (RAC), solução de alta disponibilidade e escalabilidade do Oracle Database. O participante aprenderá a instalar, configurar, administrar, monitorar e otimizar ambientes Oracle RAC, garantindo continuidade dos serviços, balanceamento de carga e máxima disponibilidade para aplicações corporativas críticas.

Objetivo

Após realizar este curso, você será capaz de:

• Compreender a arquitetura e os componentes do Oracle RAC
• Instalar e configurar ambientes Oracle RAC
• Administrar instâncias RAC e infraestrutura Grid
• Monitorar e otimizar o desempenho de clusters Oracle
• Implementar estratégias de alta disponibilidade e continuidade de negócios
• Solucionar problemas e administrar ambientes RAC corporativos

Publico Alvo

• Administradores de Banco de Dados Oracle (DBAs)
• Especialistas em alta disponibilidade e infraestrutura crítica
• Arquitetos de soluções Oracle
• Analistas de banco de dados e infraestrutura
• Consultores Oracle Database
• Profissionais responsáveis por ambientes corporativos de missão crítica

Pre-Requisitos

• Conhecimentos equivalentes aos cursos Oracle Database Administration I e II
• Experiência com administração de Oracle Database
• Conhecimentos de sistemas Linux e redes
• Familiaridade com armazenamento compartilhado e alta disponibilidade

Conteúdo Programatico

Module 1: Introduction to Oracle RAC Architecture

1. High availability and scalability concepts
2. Oracle RAC architecture overview
3. RAC components and terminology
4. Cluster database fundamentals
5. Shared storage concepts
6. RAC use cases and benefits

Module 2: Oracle Clusterware Fundamentals

1. Oracle Grid Infrastructure overview
2. Oracle Clusterware architecture
3. Cluster components and services
4. Cluster resource management
5. Cluster health monitoring
6. Oracle Cluster Registry (OCR) fundamentals

Module 3: RAC Infrastructure Planning and Installation

1. Hardware and software requirements
2. Network architecture planning
3. Shared storage preparation
4. Grid Infrastructure installation
5. Oracle RAC database installation
6. Post-installation validation

Module 4: RAC Database Administration

1. Managing RAC databases
2. Instance administration
3. Service configuration and management
4. Startup and shutdown procedures
5. Resource allocation strategies
6. Managing cluster resources

Module 5: Storage Management in RAC Environments

1. Automatic Storage Management (ASM)
2. ASM architecture and components
3. Disk groups administration
4. Shared storage management
5. ASM performance considerations
6. Storage monitoring and maintenance

Module 6: RAC Networking and Connectivity

1. Public and private network configuration
2. Virtual IP addresses (VIPs)
3. Single Client Access Name (SCAN)
4. Listener administration
5. Load balancing concepts
6. Network troubleshooting techniques

Module 7: Performance Monitoring and Optimization

1. RAC performance architecture
2. Global cache management
3. Monitoring cluster performance
4. Workload distribution analysis
5. Identifying performance bottlenecks
6. RAC tuning methodologies

Module 8: High Availability and Failover Management

1. Failover architecture and processes
2. Node failure scenarios
3. Service failover management
4. Fast Application Notification (FAN)
5. Application Continuity overview
6. High availability best practices

Module 9: Backup, Recovery and Maintenance

1. RMAN integration with RAC
2. Backup strategies for clustered databases
3. Recovery procedures in RAC environments
4. Patch management concepts
5. Rolling maintenance operations
6. Database upgrade considerations

Module 10: Security and Operational Governance

1. Security architecture in RAC environments
2. User and privilege management
3. Cluster security best practices
4. Auditing and compliance requirements
5. Operational governance procedures
6. Documentation and change control

Module 11: Advanced RAC Administration

1. Enterprise deployment strategies
2. Capacity planning techniques
3. Resource Manager integration
4. RAC and Data Guard integration
5. Troubleshooting complex RAC issues
6. Operational optimization practices

Module 12: Practical Labs and Enterprise Scenarios

1. Oracle RAC installation workshops
2. Cluster administration exercises
3. Failover and recovery simulations
4. Performance tuning laboratories
5. Enterprise case studies
6. Final Oracle RAC administration project