Oracle Database 19c: Multitenant Architecture cover image

Oracle Database 19c: Multitenant Architecture

Duration: 4 Days

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