Course Outline
Introduction
- Overview of multitenant architecture
- Benefits of 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 Container Database (CDB)
Creating and Managing PDBs
- Creating PDBs via SQL, DBCA, and PDB seed
- Managing PDBs: starting, stopping, and cloning
- PDB administration
Security in Multitenant Environment
- User security in 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 within 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
- 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
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
