Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
- Overview of multitenant architecture
- Advantages of multitenant architecture
- Core components: container database (CDB) and pluggable databases (PDBs)
Multitenant Architecture Components
- Understanding the container database (CDB)
- Understanding pluggable databases (PDBs)
- Comparing non-CDB and CDB architectures
Installing and Configuring Multitenant Architecture
- Installing Oracle Database 19c with the multitenant option
- Configuring a multitenant environment
- Creating a CDB
Creating and Managing PDBs
- Creating PDBs using SQL, DBCA, and PDB seed
- Managing PDBs: starting, stopping, and cloning
- PDB administration
Security in Multitenant Environments
- User security within CDBs and PDBs
- Managing roles and privileges
- Implementing transparent data encryption (TDE) in PDBs
Backup and Recovery for Multitenant Databases
- Backup strategies for CDBs and PDBs
- Recovery scenarios in a multitenant environment
- Utilizing RMAN with 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
- Utilizing Oracle Data Pump in a multitenant architecture
Patching and Upgrading in a Multitenant Environment
- Patching strategies for CDBs and PDBs
- Upgrading PDBs: best practices
- Techniques for minimizing downtime
High Availability and Disaster Recovery
- Configuring Data Guard with multitenant databases
- Failover and switchover scenarios in a multitenant environment
- Implementing Oracle RAC with 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
Requirements
- Fundamental knowledge of Oracle database administration
- Familiarity with SQL and PL/SQL
Target Audience
- Database administrators
- IT professionals
21 Hours
