About this Course
The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. Oracle Database 19c Multitenant Architecture is a three-day hands-on course that explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs).
Audience Profile
This course is introductory-level, but technical in nature.
At Course Completion
This course is approximately 50% hands-on lab to lecture ratio, combining engaging expert lessons, demos and group discussions with real-world, skills-focused machine-based labs and exercises. Working in a hands-on learning environment led by our expert facilitator, you’ll explore:
- Core concepts of regular PDBs
- Creating a CDB, and then using different methods to create PDBs.
- How to start and shut down a CDB and how to open and close a PDB.
- Security aspects in CDBs and PDBs in various areas like privileges and roles, lockdown profiles, auditing, Database Vault, and encryption.
- Availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs.
- How you can move data from a non-CDB environment to a PDB.
- How to move data between PDBs by using utilities such as the export and import features of Oracle Data Pump, SQL*Loader, external tables, and Oracle Recovery Manager.
Outline
1. Multitenant Architecture
- CDB Basics
- CDB and Regular PDBs
- Application PDBs and Application Installation
2. PDB Creation
- PDB Creation
- CDB and PDB Management
- Storage
3. Security
- Security
- Backup and Duplicate
- Recovery and Flashback
- Performance
- Resources Allocation
4. Data Movement
- Data Movement
- Upgrade Methods
- Miscellaneous
Prerequisites
In order to participate in the hands-pon labs you should have a basic understanding of database principles, basic scripting skills (in relation to Oracle) and basic analytics skills.
