Oracle Database 19c - Multitenant Architecture

• Basic understanding of Oracle database administration
• Familiarity with SQL and PL/SQL

Audience

• Database administrators
• IT professionals

Oracle Database 19c: Multitenant Architecture is a feature introduced in Oracle Database that allows a single database instance, known as a Container Database (CDB), to host multiple separate databases, called Pluggable Databases (PDBs). This architecture provides a way to consolidate multiple databases on a single hardware resource, making it easier to manage, administer, and optimize resources.

This instructor-led, live training (online or onsite) is aimed at intermediate-level database administrators who wish to effectively manage and optimize a multitenant environment.

By the end of this training, participants will be able to:

• Understand the key components and benefits of Oracle Database 19c's multitenant architecture, including CDBs and PDBs.
• Gain practical skills in installing, configuring, and managing container databases (CDBs) and pluggable databases (PDBs).
• Develop proficiency in implementing security measures, backup and recovery strategies, and performance tuning in a multitenant environment.
• Learn how to manage high availability and disaster recovery in a multitenant architecture, including configuring Data Guard and Oracle RAC.
• Acquire troubleshooting techniques and best practices for maintaining a secure, efficient, and reliable multitenant database environment.

Format of the Course

• Interactive lecture and discussion.
• Lots of exercises and practice.
• Hands-on implementation in a live-lab environment.

Course Customization Options

• To request a customized training for this course, please contact us to arrange.

Introduction

• Overview to the multitenant architecture
• Benefits of multitenant architecture
• Components: container database (CDB) and pluggable databases (PDBs)

Multitenant Architecture Components

• Understanding container database (CDB)
• Understanding pluggable databases (PDBs)
• Differences between non-CDB and CDB architectures

Installing and Configuring Multitenant Architecture

• Installation of Oracle Database 19c with multitenant option
• Configuration of a multitenant environment
• Creating a CDB

Creating and Managing PDBs

• Creating PDBs using SQL, DBCA, and PDB seed
• Managing PDBs: start, stop, and clone
• PDB administration

Security in Multitenant Environment

• User security in CDB and PDBs
• Managing roles and privileges
• Implementing transparent data encryption (TDE) in PDBs

Backup and Recovery of Multitenant Databases

• Backup strategies for CDB and PDBs
• Recovery scenarios in a multitenant environment
• Using RMAN with a multitenant architecture

Performance Tuning in Multitenant Architecture

• Resource management in a multitenant environment
• Tuning PDBs for optimal performance
• Monitoring performance using Enterprise Manager

Managing Data in PDBs

• Moving data between PDBs
• Importing and exporting data in PDBs
• Using Oracle Data Pump in a multitenant architecture

Patching and Upgrading in a Multitenant Environment

• Patching strategies for CDBs and PDBs
• Upgrading PDBs: best practices
• Downtime minimization techniques

High Availability and Disaster Recovery

• Configuring Data Guard with multitenant databases
• Failover and switchover scenarios in a multitenant environment
• Implementing Oracle RAC with a multitenant architecture

Troubleshooting Multitenant Databases

• Common issues in multitenant architecture
• Diagnostic tools and techniques
• Troubleshooting techniques for PDBs

Best Practices for Multitenant Architecture

• Security best practices
• Backup and recovery best practices
• Performance tuning best practices

Summary and Next Steps