Oracle Database 19c: Multitenant Architecture

Consolidate databases efficiently with Oracle Multitenant in Oracle Database 19c.

4 daysAdvanced7 modules

Enrol or enquire →Ask on WhatsApp

Overview

About this course

Consolidate databases efficiently with Oracle Multitenant in Oracle Database 19c. Across four days you will create container databases with DBCA, provision, clone, plug and unplug pluggable databases, administer users, privileges and local undo, back up and recover at CDB and PDB level, share resources with Resource Manager, and plan patching and upgrades for individual PDBs.

What you'll learn

Understand the architecture and benefits of Oracle Multitenant in Oracle Database 19c
Create and manage container databases and pluggable databases
Perform PDB provisioning, cloning, plugging, and unplugging
Configure and manage resource allocation across PDBs
Secure, back up, and recover multitenant environments

Curriculum

7 modules

Overview of CDBs and PDBs
Benefits of the multitenant model
Comparison with traditional database architecture

CDB configuration and initialization
Creating CDBs using DBCA
Understanding root and seed containers

Creating PDBs from seed or clones
Plugging and unplugging PDBs
Cloning PDBs locally and remotely

Administering users and roles in PDBs
Managing system and object privileges
Enabling and disabling local undo

Backing up CDBs and individual PDBs
Recovery options at the PDB and CDB level
Flashback and point-in-time recovery

Managing SGA and PGA across containers
Using Resource Manager for PDB-level control
Monitoring and tuning multitenant performance

Consolidation planning
Managing lifecycle and patching of PDBs
Upgrading PDBs independently

Who it's for

Database administrators with basic Linux knowledge who plan, consolidate or run multitenant Oracle environments.

Before you start

Basic knowledge of Linux operating system

Let's plan your next step together.

Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.

Talk to an advisor →WhatsApp