Visão Geral

Este curso aborda a arquitetura Oracle Multitenant, baseada em Container Databases (CDB) e Pluggable Databases (PDB), uma das principais tecnologias do Oracle Database moderno. O participante aprenderá a implementar, administrar, monitorar e otimizar ambientes multitenant, consolidando múltiplos bancos de dados em uma única infraestrutura com maior eficiência, segurança, escalabilidade e facilidade de gerenciamento.

Objetivo

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

• Compreender os fundamentos da arquitetura Oracle Multitenant
• Administrar Container Databases (CDBs) e Pluggable Databases (PDBs)
• Implementar estratégias de consolidação e isolamento de bancos de dados
• Gerenciar segurança, recursos e desempenho em ambientes multitenant
• Realizar backup, recuperação e migração de PDBs
• Aplicar boas práticas para ambientes Oracle Multitenant corporativos

Publico Alvo

• Administradores de Banco de Dados Oracle (DBAs)
• Arquitetos de soluções Oracle
• Analistas de banco de dados
• Especialistas em infraestrutura Oracle
• Consultores Oracle Database
• Profissionais responsáveis por ambientes corporativos Oracle

Pre-Requisitos

• Conhecimentos equivalentes ao curso Oracle Database Administration I
• Familiaridade com arquitetura Oracle Database
• Conhecimentos básicos de administração de bancos Oracle

Conteúdo Programatico

Module 1: Introduction to Oracle Multitenant Architecture

1. Evolution of Oracle Database architecture
2. Introduction to Multitenant concepts
3. Benefits of CDB and PDB architecture
4. Consolidation strategies
5. Multitenant terminology and components
6. Oracle Multitenant use cases

Module 2: Container Database (CDB) Fundamentals

1. Understanding Container Databases
2. CDB architecture and components
3. Root container concepts
4. Seed database architecture
5. Common and local users
6. Administrative structures within CDBs

Module 3: Pluggable Database (PDB) Fundamentals

1. Understanding Pluggable Databases
2. PDB lifecycle management
3. Creating and configuring PDBs
4. Managing PDB states
5. Cloning and provisioning PDBs
6. PDB administration best practices

Module 4: Installing and Configuring Multitenant Environments

1. Multitenant deployment planning
2. Creating CDB environments
3. Configuring multiple PDBs
4. Initial setup and validation
5. Environment administration procedures
6. Configuration best practices

Module 5: Managing Users, Security and Access Control

1. Common versus local users
2. Roles and privileges management
3. Security administration in multitenant environments
4. Authentication and authorization concepts
5. Resource access controls
6. Security best practices

Module 6: Resource Management and Performance Administration

1. Resource Manager integration
2. Managing CPU and memory allocation
3. Workload isolation techniques
4. Monitoring resource utilization
5. Performance optimization strategies
6. Capacity planning concepts

Module 7: Backup and Recovery in Multitenant Databases

1. RMAN integration with Multitenant
2. CDB backup strategies
3. PDB backup strategies
4. Recovery operations for CDBs and PDBs
5. Point-in-time recovery concepts
6. Data protection best practices

Module 8: PDB Cloning, Relocation and Migration

1. Cloning PDBs locally and remotely
2. Unplug and plug operations
3. PDB relocation procedures
4. Database consolidation projects
5. Migration planning and execution
6. Validation and testing practices

Module 9: Monitoring and Troubleshooting

1. Monitoring CDB and PDB environments
2. Dynamic performance views
3. Diagnostic tools and techniques
4. Troubleshooting common issues
5. Alert and trace analysis
6. Operational monitoring best practices

Module 10: High Availability and Business Continuity

1. Data Guard integration with Multitenant
2. RAC and Multitenant architecture
3. High availability considerations
4. Disaster recovery planning
5. Business continuity strategies
6. Operational resilience practices

Module 11: Automation and Enterprise Administration

1. Administrative automation techniques
2. Managing large-scale multitenant environments
3. Operational governance practices
4. Compliance and auditing considerations
5. Standardization and documentation
6. Enterprise administration best practices

Module 12: Practical Labs and Enterprise Scenarios

1. CDB and PDB administration workshops
2. Cloning and migration exercises
3. Backup and recovery simulations
4. Performance management laboratories
5. Enterprise consolidation case studies
6. Final Oracle Multitenant administration project