Visão Geral

Este curso aborda a administração completa do Oracle Data Guard, solução de alta disponibilidade e recuperação de desastres do Oracle Database. O participante aprenderá a planejar, implementar, configurar, monitorar e administrar ambientes Primary e Standby, garantindo continuidade dos negócios, proteção de dados e recuperação eficiente em situações de falha.

Objetivo

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

• Compreender a arquitetura e os componentes do Oracle Data Guard
• Planejar e implementar ambientes de alta disponibilidade e recuperação de desastres
• Configurar e administrar bancos Primary e Standby
• Executar operações de switchover e failover com segurança
• Monitorar e otimizar ambientes Data Guard
• Implementar estratégias de continuidade de negócios e proteção de dados

Publico Alvo

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

Pre-Requisitos

• Conhecimentos equivalentes ao curso Oracle Database Administration II
• Experiência com Oracle Database Administration
• Conhecimentos de backup e recuperação com RMAN
• Familiaridade com redes e arquitetura Oracle

Conteúdo Programatico

Module 1: Introduction to Oracle Data Guard

1. High availability concepts
2. Business continuity and disaster recovery fundamentals
3. Oracle Data Guard architecture overview
4. Data Guard components and terminology
5. Primary and standby database concepts
6. Data protection modes overview

Module 2: Planning and Designing Data Guard Environments

1. High availability requirements analysis
2. Recovery objectives (RTO and RPO)
3. Network and infrastructure planning
4. Capacity and storage considerations
5. Data Guard deployment architectures
6. Best practices for environment design

Module 3: Configuring Physical Standby Databases

1. Physical standby database architecture
2. Creating standby databases
3. RMAN duplication techniques
4. Redo transport configuration
5. Standby redo logs management
6. Initial synchronization procedures

Module 4: Redo Transport and Apply Services

1. Redo transport architecture
2. Log shipping mechanisms
3. Synchronous and asynchronous transport
4. Redo Apply services
5. Real-Time Apply configuration
6. Monitoring redo transport performance

Module 5: Managing Oracle Data Guard Broker

1. Introduction to Data Guard Broker
2. Broker architecture and components
3. DGMGRL administration
4. Creating broker configurations
5. Managing databases with Broker
6. Monitoring and automation features

Module 6: Monitoring and Performance Management

1. Data Guard monitoring tools
2. Dynamic performance views
3. Lag monitoring techniques
4. Performance analysis and troubleshooting
5. Monitoring alerts and events
6. Operational best practices

Module 7: Switchover and Failover Operations

1. Switchover concepts and procedures
2. Planned role transitions
3. Failover concepts and scenarios
4. Unplanned outage recovery
5. Reinstating failed primary databases
6. Operational testing and validation

Module 8: Advanced Data Guard Features

1. Active Data Guard overview
2. Read-only standby databases
3. Real-Time Query functionality
4. Block repair capabilities
5. Automatic gap resolution
6. Advanced data protection features

Module 9: Backup and Recovery in Data Guard Environments

1. RMAN integration with Data Guard
2. Backup strategies for primary and standby databases
3. Recovery operations in standby environments
4. Recovery testing methodologies
5. Flashback Database integration
6. Disaster recovery planning

Module 10: Multitenant and Enterprise Deployments

1. Data Guard with CDB and PDB environments
2. Multitenant administration considerations
3. Enterprise deployment strategies
4. Resource management practices
5. Scalability and operational planning
6. Hybrid and cloud deployment concepts

Module 11: Security, Compliance and Operational Governance

1. Security considerations for Data Guard environments
2. Network encryption and protection
3. Access control and privilege management
4. Auditing and compliance requirements
5. Governance and operational procedures
6. Documentation and change management

Module 12: Practical Labs and Disaster Recovery Simulations

1. Data Guard implementation workshops
2. Switchover and failover exercises
3. Disaster recovery simulations
4. Performance troubleshooting labs
5. Enterprise case studies
6. Final Oracle Data Guard administration project