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 the multitenant architecture.
- Advantages of adopting a multitenant architecture.
- Key components: container database (CDB) and pluggable databases (PDBs).
Multitenant Architecture Components
- Comprehending the container database (CDB) structure.
- Understanding the role of pluggable databases (PDBs).
- Distinctions between non-CDB and CDB architectures.
Installing and Configuring Multitenant Architecture
- Installing Oracle Database 19c with the multitenant option enabled.
- Setting up a multitenant environment.
- Creating a CDB.
Creating and Managing PDBs
- Creating PDBs via SQL, DBCA, and PDB seed.
- Managing PDBs: starting, stopping, and cloning.
- General PDB administration tasks.
Security in Multitenant Environment
- User security configurations in CDB and PDBs.
- Managing roles and privileges.
- Implementing transparent data encryption (TDE) within PDBs.
Backup and Recovery of Multitenant Databases
- Backup strategies for CDB and PDBs.
- Recovery scenarios specific to a multitenant environment.
- Utilizing RMAN within a multitenant architecture.
Performance Tuning in Multitenant Architecture
- Resource management within a multitenant environment.
- Optimizing PDB performance.
- Monitoring performance using Enterprise Manager.
Managing Data in PDBs
- Transferring data between PDBs.
- Importing and exporting data within PDBs.
- Leveraging Oracle Data Pump in a multitenant architecture.
Patching and Upgrading in a Multitenant Environment
- Patching strategies for CDBs and PDBs.
- Upgrading PDBs: recommended best practices.
- Techniques to minimize downtime.
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 challenges in multitenant architecture.
- Diagnostic tools and methodologies.
- Troubleshooting techniques specific to PDBs.
Best Practices for Multitenant Architecture
- Security best practices.
- Backup and recovery best practices.
- Performance tuning best practices.
Summary and Next Steps
Requirements
- Foundational knowledge of Oracle database administration.
- Proficiency in SQL and PL/SQL.
Target Audience
- Database administrators.
- IT professionals.
21 Hours
Testimonials (1)
good explanation on each points and provide assignment for practices.
