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.
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
*Course fee/person - Subject to minimum 4 registrations. (Public/Private schedule)
