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 using multitenant architecture
- Key components: container database (CDB) and pluggable databases (PDBs)
Multitenant Architecture Components
- Understanding the container database (CDB)
- Understanding pluggable databases (PDBs)
- Differences between 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 the PDB seed
- Managing PDBs: starting, stopping, and cloning
- PDB administration
Security in a Multitenant Environment
- User security within CDBs and PDBs
- Managing roles and privileges
- Implementing Transparent Data Encryption (TDE) in PDBs
Backup and Recovery of Multitenant Databases
- Backup strategies for CDBs 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
- 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 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
- Foundational knowledge of Oracle database administration
- Familiarity with SQL and PL/SQL
Target Audience
- Database administrators
- IT professionals
21 Hours
