Visão Geral

Este curso aprofunda os conhecimentos em administração de bancos de dados Oracle, abordando recursos avançados de gerenciamento, desempenho, alta disponibilidade, backup e recuperação, segurança, automação e monitoramento. O participante aprenderá a administrar ambientes Oracle corporativos, implementar estratégias de continuidade de negócios e otimizar o desempenho de bancos de dados críticos.

Objetivo

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

• Administrar ambientes Oracle avançados e corporativos
• Implementar estratégias de backup, recuperação e continuidade de negócios
• Monitorar e otimizar o desempenho de bancos de dados Oracle
• Gerenciar ambientes multitenant e recursos avançados de armazenamento
• Implementar mecanismos avançados de segurança e auditoria
• Automatizar tarefas administrativas e gerenciar alta disponibilidade

Publico Alvo

• Administradores de Banco de Dados Oracle (DBAs)
• Analistas de infraestrutura e banco de dados
• Especialistas em suporte de ambientes Oracle
• Arquitetos de soluções Oracle
• Consultores de banco de dados
• Profissionais que concluíram Oracle Database Administration I

Pre-Requisitos

• Conhecimentos equivalentes ao curso Oracle Database Administration I
• Experiência com administração básica de Oracle Database
• Conhecimentos de SQL e arquitetura Oracle

Conteúdo Programatico

Module 1: Advanced Oracle Architecture

1. Review of Oracle Database architecture
2. Advanced memory architecture concepts
3. Background processes and optimization
4. Multitenant architecture deep dive
5. Container and pluggable databases
6. Enterprise database design considerations

Module 2: Advanced Storage Administration

1. Advanced tablespace management
2. ASM (Automatic Storage Management) fundamentals
3. Managing large databases
4. Space utilization optimization
5. Datafile administration techniques
6. Storage performance considerations

Module 3: Backup and Recovery with RMAN

1. RMAN architecture and components
2. Backup strategies and planning
3. Full and incremental backups
4. Recovery catalog management
5. Point-in-time recovery techniques
6. Recovery testing and validation

Module 4: Flashback Technologies and Data Protection

1. Flashback Query
2. Flashback Table
3. Flashback Database
4. Recycle Bin management
5. Data recovery strategies
6. Business continuity considerations

Module 5: Oracle Multitenant Administration

1. Creating and managing CDBs and PDBs
2. Pluggable database lifecycle management
3. Cloning and relocating PDBs
4. Resource management in multitenant environments
5. Backup and recovery of PDBs
6. Multitenant administration best practices

Module 6: Performance Monitoring and Tuning

1. Oracle performance architecture
2. Automatic Workload Repository (AWR)
3. Active Session History (ASH)
4. Performance diagnostics techniques
5. Identifying performance bottlenecks
6. Tuning methodologies and strategies

Module 7: SQL and Database Optimization

1. SQL performance analysis
2. Execution plan interpretation
3. Optimizer fundamentals
4. Statistics management
5. Index optimization strategies
6. SQL tuning best practices

Module 8: Security Administration and Auditing

1. Advanced user and privilege management
2. Database auditing concepts
3. Unified Auditing architecture
4. Transparent Data Encryption (TDE) overview
5. Data protection strategies
6. Security compliance best practices

Module 9: High Availability and Disaster Recovery

1. High availability concepts
2. Oracle Data Guard fundamentals
3. Standby database configurations
4. Switchover and failover operations
5. Disaster recovery planning
6. Business continuity strategies

Module 10: Automation and Advanced Administration

1. Oracle Scheduler advanced usage
2. Administrative scripting techniques
3. Database maintenance automation
4. Data Pump advanced operations
5. Patch and upgrade management concepts
6. Operational efficiency practices

Module 11: Monitoring, Diagnostics and Troubleshooting

1. Advanced monitoring techniques
2. Diagnostic tools and utilities
3. Incident management processes
4. Alert and trace file analysis
5. Troubleshooting methodologies
6. Root cause analysis techniques

Module 12: Enterprise DBA Workshops and Final Project

1. Performance tuning workshops
2. Backup and recovery simulations
3. High availability exercises
4. Security and auditing scenarios
5. Enterprise administration case studies
6. Final Oracle DBA enterprise project