Visão Geral

Curso Oracle Database 23ai Multitenant Architecture, foi desenvolvido para proporcionar um conhecimento aprofundado dos recursos avançados de multitenant do Oracle. Este curso tem como foco auxiliar profissionais de banco de dados a dominar o gerenciamento de bancos de dados contêineres (CDBs) e bancos de dados plugáveis ​​(PDBs), essenciais para a consolidação, escalabilidade e administração simplificada de bancos de dados em ambientes corporativos modernos. Os participantes aprenderão a criar, clonar, realocar e desconectar PDBs, gerenciar a segurança em múltiplos tenants e otimizar o desempenho utilizando técnicas de gerenciamento de recursos. O curso também aborda tópicos avançados como backup e recuperação em um ambiente multitenant, procedimentos de aplicação de patches e melhores práticas para estratégias de alta disponibilidade e recuperação de desastres. Ministrado por especialistas certificados pela Oracle, este treinamento prático garante que os participantes adquiram experiência prática na configuração e manutenção de configurações multitenant, tanto em implantações locais quanto em nuvem. Seja para se preparar para os exames de certificação Oracle ou para impulsionar sua carreira como Administrador de Banco de Dados (DBA) ou Arquiteto de Nuvem, este curso oferece os recursos multitenant mais recentes do Oracle 23ai, essenciais para o cenário de TI atual.

Objetivo

Após Realizar este Curso Oracle Database 23ai Multitenant Architecture, você será capaz de:

• Compreenda os conceitos fundamentais da arquitetura multitenant da Oracle, incluindo CDBs e PDBs.
• Aprenda como criar, gerenciar, clonar, desconectar e realocar bancos de dados plugáveis ​​(PDBs).
• Configure e administre bancos de dados de contêineres (CDBs) de forma eficiente em diferentes ambientes.
• Implementar gerenciamento de recursos para otimizar a carga de trabalho em vários PDBs.
• Realizar backup, recuperação e aplicação de patches em um ambiente multi-inquilino.
• Proteja e gerencie o acesso de usuários em contêineres e bancos de dados plugáveis.
• Explore métodos para atualizar e migrar bancos de dados multitenant para o Oracle Database 23ai.

Publico Alvo

1. Administradores de Banco de Dados (DBAs)
2. Arquitetos de Nuvem
3. Administradores de sistemas
4. Desenvolvedores de banco de dados
5. Engenheiros de Infraestrutura de TI
6. Profissionais Certificados Oracle
7. Arquitetos de Dados
8. Arquitetos de Soluções
9. Gerentes de TI

Pre-Requisitos

• Conhecimento básico da arquitetura do banco de dados Oracle.
• Experiência com programação em SQL e PL/SQL
• Familiaridade com tarefas de administração de banco de dados Oracle

Materiais

Conteúdo Programatico

Module 1: CDB Basics

1. Objectives
2. Challenges 
3. Multitenant Architecture: Benefits 
4. Other Benefits of Multitenant Architecture 
5. Oracle Multitenant Container Database 
6. Configurations 
7. SYSTEM Objects in the USER Container 
8. Provisioning a Pluggable Database 
9. Multitenant Container Database Architecture 
10. Containers 
11. Tools 
12. Data Dictionary and Dynamic Views 
13. Terminology 
14. Impacts
15. Summary 
16. Multitenant Architecture Poster 

Module 2: CDB and Regular PDBs

1. Objectives 
2. Goals 
3. Creating a CDB 
4. Creating a CDB: Using SQL*Plus 
5. Clause: SEED FILE_NAME_CONVERT 
6. Clause: ENABLE PLUGGABLE DATABASE 
7. After CDB Creation 
8. Data Dictionary Views: DBA_xxx 
9. Data Dictionary Views: CDB_xxx 
10. Data Dictionary Views: Examples 
11. Data Dictionary Views: V$xxx Views 
12. After CDB Creation: To Do List 
13. Automatic Diagnostic Repository 
14. Automatic Diagnostic Repository: alert.log File 
15. Provisioning New Pluggable Databases 
16. Tools 
17. Creating New PDB from PDB$SEED 
18. Steps: With FILE_NAME_CONVERT 
19. Steps: Without FILE_NAME_CONVERT 
20. Summary 

Module 3: Application PDBs and Application Installation

1. Objectives 
2. Regular PDBs 
3. PDBs and Applications 
4. Application Containers 
5. Application Containers: Other Features 
6. Types of Containers 
7. Creating Application PDBs 
8. Application Name and Version 
9. Installing Applications 
10. Patching and Upgrading Applications 
11. Application Common Objects 
12. Use Cases for Application Containers 
13. Use Case: Pure PDB-Based Vs Hybrid Model 
14. Container Map 
15. Container Map: Example 
16. Query Routed Appropriately 
17. Dynamic Container Map 
18. Container Map and Containers Default 
19. Query Across CDBs Using Application Root Replica 
20. Durable Location Transparency 
21. Data Dictionary Views 
22. Terminology in Application Container Context 
23. Commonality in Application Containers 
24. Impacts 
25. Summary 

Module 4: PDB Creation

1. Objectives 
2. Cloning Regular PDBs 
3. Cloning Application Containers 
4. Plugging a Non-CDB into CDB 
5. Plugging a Non-CDB into CDB as PDB Using DBMS_PDB 
6. Replicating Non-CDB into CDB 
7. Cloning a Non-CDB or Remote PDB 
8. Plugging an Unplugged Regular PDB into CDB 
9. Flow 
10. Plugging Using Archive File 
11. Unplugging and Plugging Application PDBs 
12. Converting Regular PDBs to Application PDBs 
13. Unplugging and Plugging a PDB with Encrypted Data 
14. Local UNDO Mode Vs Shared UNDO Mode 
15. Cloning Remote PDBs in Hot Mode 
16. Near-Zero Downtime PDB Relocation 
17. Proxy PDB: Query Across CDBs Proxying Root Replica 
18. Creating a Proxy PDB 
19. Using DBCA to Clone a Remote PDB 
20. Using DBCA to Relocate a Remote PDB 
21. Using DBCA to Duplicate a CDB 
22. Dropping PDBs 
23. Summary 

Module 5: CDB and PDB Management

1. Objectives 
2. Connection 
3. Switching Connection 
4. Creating Services 
5. Renaming Services 
6. Starting Up a CDB Instance 
7. Mounting a CDB 
8. Opening a CDB 
9. Opening a PDB 
10. Pluggable Database Hybrid Read-Only Mode 
11. Automatic PDB Opening 
12. Closing a PDB 
13. Shutting Down a CDB Instance 
14. Changing PDB Mode 
15. Modifying PDB Settings 
16. Instance Parameter Change Impact 
17. Instance Parameter Change Impact: Example 
18. Using ALTER SYSTEM Statement on PDB 
19. Configuring Host Name and Port Number per PDB 
20. Summary 

Module 6: Storage

1. Objectives 
2. Objects in Tablespaces 
3. Tablespaces Created During PDB Creation 
4. Defining Default Permanent Tablespaces 
5. Temporary Tablespaces 
6. UNDO Tablespaces 
7. Summary 

Module 7: Security

1. Objectives 
2. Creating Common Users in the CDB and PDBs 
3. Creating Common Roles in the CDB and PDBs 
4. Granting Privileges Commonly in the CDB and PDBs 
5. Creating Common Profiles in the CDB and PDBs 
6. Common Objects in Application Containers 
7. Operations on Data-Linked Objects 
8. Enabling Common Users to Access Data in PDBs 
9. Finding Information About CONTAINER_DATA Attributes 
10. Restricting Operations with PDB Lockdown Profiles 
11. Restricting Operations in a PDB Lockdown Profile 
12. PDB Lockdown Profiles Inheritance 
13. Static and Dynamic PDB Lockdown Profiles 
14. Auditing Actions in the CDB and PDBs 
15. Managing Other Types of Security Policies in Application Containers 
16. Securing Data with Oracle Database Vault 
17. Oracle Database Vault-Enabled Strict Mode 
18. Managing Keystore in the CDB and PDBs 
19. Creating and Opening a Keystore 
20. Setting TDE Master Encryption Keys 
21. Managing Keystore in the CDB and PDBs 
22. Keystore Management Changes for PDBs 
23. Defining the Keystore Type 
24. Isolating a PDB Keystore 
25. Converting a PDB to Run in Isolated Mode 
26. Converting a PDB to Run in United Mode 
27. Migrating a PDB Between Keystore Types 
28. Unplugging and Plugging a PDB with Encrypted Data 
29. Per-PDB Wallet for PDB Certificates 
30. Summary 

Module 8: Backup and Duplicate

1. Objectives
2. Goals 
3. Syntax and Clauses in RMAN 
4. CDB Backup: Whole CDB Backup 
5. CDB Backup: Partial CDB Backup 
6. PDB Backup: Partial PDB Backup 
7. Using RMAN Backup to Plug an Unplugged PDB 
8. Duplicating Pluggable Databases 
9. Cloning Active PDB into an Existing CDB 
10. Example: 1 
11. Example: 2 
12. Duplicating On-Premises CDB as Cloud Encrypted CDB 
13. Duplicating On-Premises Encrypted CDB as Cloud Encrypted CDB 
14. Migrating Cloud Encrypted CDB as On-Premises CDB 
15. Checking for Block Corruption 
16. Summary 

Module 9: Recovery and Flashback

1. Objectives 
2. Goals 
3. Instance Failure and Instance Recovery 
4. NOARCHIVELOG Mode 
5. CDB and PDB Tempfile Recovery 
6. CDB SYSTEM or UNDO Tablespace Recovery 
7. PDB SYSTEM or UNDO Tablespace Recovery 
8. CDB or PDB Non-SYSTEM Tablespace Recovery 
9. PITR 
10. Migrating a Non-CDB to a CDB 
11. Migrating a Non-CDB and Transporting Non-CDB Backups to a CDB
12. Relocating/Plugging a PDB into Another CDB 
13. Plugging a PDB and Transporting PDB Backups to a CDB: 1 
14. Plugging a PDB and Transporting PDB Backups to a CDB: 2 
15. Using PrePlug-in Backups 
16. Considerations 
17. Example 
18. CDB and PDB Flashback 
19. PDB Flashback and Clean Restore Point 
20. Creating a PDB Snapshot from a PDB 
21. PDB Snapshot Carousel 
22. Creating PDB Snapshots 
23. Creating PDBs Using PDB Snapshots 
24. Dropping PDB Snapshots 
25. Flashbacking PDBs Using PDB Snapshots 
26. Switching Over a Refreshable Cloned PDB 
27. Unplanned Switchover 
28. Summary 

Module 10: Performance

1. Objectives 
2. Tuning a CDB
3. Sizing the CDB 
4. Testing the Estimates 
5. Managing SGA for PDBs 
6. Managing PGA for PDBs 
7. Monitoring PDB Memory Usage 
8. AWR and ADDM Behavior 
9. PDB-Level Snapshot Views 
10. Configuring Automatic ADDM Analysis at the PDB Level 
11. Enabling ADDM in a Pluggable Database 
12. ADDM Data Visibility 
13. Basic Rules: Statistics for Common Objects 
14. Controlling the Degree of Parallelism of Queries 
15. Heat Map and ADO Support 
16. Managing Heat Map and ADO Policies in PDB 
17. CDB Fleet 
18. CDB Lead and CDB Members 
19. Use Cases 
20. DB Replay: The Big Picture 
21. Capturing and Replaying in a CDB and PDBs 
22. Reporting 
23. Consolidated Database Replay Use Cases 
24. Use Cases: Source Workloads 
25. The Big Picture 
26. Step 1 
27. Step 2 
28. Step 3 
29. Step 4 
30. Summary 

Module 11: Resource Allocation

1. Objectives 
2. Allocating Resources in the CDB 
3. Resource Manager and Pluggable Databases 
4. Managing Resources Between PDBs 
5. CDB Resource Plan Basics: Limits 
6. PDB IO Rate Limit 
7. CDB Resource Plan: Full Example 
8. Maintaining a CDB Resource Plan 
9. Managing Resources Within a PDB 
10. Putting It Together 
11. Considerations 
12. PDB-Level Parallel Statement Queuing 
13. PDB-Level Parallel Statement Queuing: CPU_COUNT 
14. Session PGA Limit 
15. Performance Profiles 
16. Summary 

Module 12: Data Movement

1. Objectives 
2. Using Oracle Data Pump with PDBs 
3. Exporting from Non-CDB and Importing into PDB 
4. Exporting and Importing Between PDBs 
5. Full Transportable Export/Import: Overview 
6. Full Transportable Export/Import: Usage 
7. Full Transportable Export/Import: Example 
8. Transporting a Database Over the Network: Example 
9. Additional Features of Oracle Data Pump 
10. Using SQL*Loader with PDBs 
11. Summary 

Module 13: Upgrade Methods

1. Objectives 
2. Upgrading CDB and PDBs to 23ai: Methods 
3. Upgrading CDB and PDBs to 23ai 
4. Installing Oracle Database 23ai Software Using OUI 
5. AutoUpgrade Utility System Checks 
6. Running AutoUpgrade Fixups 
7. Configuration File to Run AutoUpgrade Prechecks 
8. Upgrading Using the AutoUpgrade Utility 
9. AutoUpgrade with Source and Target Database Homes on the Same Server 
10. AutoUpgrade with Source and Target Database Homes on Different Servers 
11. Overview of AutoUpgrade Job Stages 
12. AutoUpgrade Command-Line Parameters and Options 
13. AutoUpgrade Command-Line Syntax 
14. AutoUpgrade Configuration File 
15. Using Replay Upgrade’s Automatic Upgrade on PDB Plug-In to a CDB23ai 
16. How to Disable or Enable Replay Upgrade 
17. Converting and Upgrading Regular PDBs to Application PDBs 
18. Cross-Platform Transportable PDB 
19. Cross-Platform PDB Transport: Phase 1 
20. Cross-Platform PDB Transport: Phase 2 
21. Summary 

Module 14: Consolidated Database Replay Procedures

1. Consolidated Replay Steps 
2. Procedures for Steps 4 and 5 
3. Procedures for Steps 6 and 7 
4. Procedure to Remap Connections with PDBs 
5. Procedure to Prepare the Replay 
6. Modes of Synchronization 
7. Procedure to Start Replay 
8. Views