Oracle Multitenant Architecture (CDB/PDB)

Module 1: Introduction to Oracle Multitenant

• Overview of Oracle Multitenant architecture
• Container Database (CDB) and Pluggable Database (PDB)
• Multitenant vs. non-CDB architecture
• Multitenant use cases: Consolidation, cloud
• Multitenant licensing and editions

Module 2: CDB Architecture

• CDB root and seed (PDB$SEED)
• System containers and application containers
• CDB data dictionary
• Common and local users, roles, and privileges
• CDB background processes

Module 3: PDB Lifecycle Management

• Creating PDBs: From seed, clone, plug-in
• PDB open and close modes
• PDB save state
• Dropping and unplugging PDBs
• PDB manifest and XML metadata

Module 4: PDB Provisioning

• Cloning a PDB locally
• Remote PDB cloning
• PDB snapshot cloning
• Refreshable PDB cloning
• PDB relocation

Module 5: Application Containers

• Application root and application PDB
• Application installation and upgrade
• Application common objects
• Application container use cases
• Application container vs. regular CDB

Module 6: Resource Management in CDB

• CDB Resource Manager
• PDB performance profiles
• CPU, I/O, and memory limits per PDB
• Monitoring PDB resource usage
• Automatic PDB performance management

Module 7: Security in Multitenant

• Common vs. local users and privileges
• Lockdown profiles for PDBs
• TDE in CDB and PDB
• Auditing in multitenant
• PDB isolation and security best practices

Module 8: Backup and Recovery in Multitenant

• RMAN backup of CDB and PDB
• PDB point-in-time recovery
• CDB whole backup and restore
• Flashback PDB
• Cross-CDB recovery scenarios

Module 9: Patching and Upgrades in Multitenant

• CDB patching with OPatch
• PDB compatibility and upgrade
• AutoUpgrade for CDB/PDB
• In-place and out-of-place CDB upgrade
• Minimal downtime PDB upgrade

Module 10: Multitenant High Availability

• Data Guard with CDB and PDB
• RAC with multitenant
• GoldenGate with CDB/PDB
• PDB failover and switchover
• Maximum Availability for multitenant

Module 11: Multitenant on Oracle Cloud

• Autonomous Database as PDB
• CDB in Oracle Base Database Service
• PDB management on OCI
• Multitenant in Exadata Cloud
• Future of multitenant: Oracle 23ai

Module 12: Real-Time Projects and Case Studies

• Database consolidation using multitenant
• PDB provisioning automation
• End-to-end multitenant administration
• Certification and interview preparation

Experience in the Industry Gain knowledge from experts with hands-on Oracle Multitenant project experience in database consolidation and cloud migration.

Backgrounds at the Top Prominent corporations such as HCL, TCS, Wipro, and Oracle Consulting employ our Oracle Multitenant trainers.

Clear & Effective Teaching Excellent communication and real-world examples simplify complex CDB/PDB architecture and lifecycle management.

Hands-On Learning Focus Students apply skills using live Oracle 19c/21c CDB environments with real PDB provisioning and recovery projects.

Up-to-Date Knowledge Trainers stay current with Oracle Multitenant 21c, Oracle 23ai, and latest cloud database consolidation best practices.