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 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
Requirements
- Basic understanding of Oracle database administration
- Familiarity with SQL and PL/SQL
Audience
- Database administrators
- IT professionals
21 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 4800 € + VAT*
Contact us for an exact quote and to hear our latest promotions
Testimonials (1)
Generating reports with the graphical interface.
Harold Romero Romero - OSFEM
Course - Oracle Database 19c: Administration
Machine Translated
