Oracle Database 19c: Multitenant Architecture

Course details

Oracle introduced the multitenant architecture in version 12.1.0.2 as an available option, but starting with 19c, creating a multitenant database is the only option for a new database. In this course, Oracle database administrator Bob Bryla helps DBAs create and effectively utilize resources within multitenant databases. Bob shows how to manage one or more multitenant databases on the same server, how to create the CDB, create a PDB from the seed database, and clone a PDB to the same or another container. The multitenant architecture also has several new options when backing up and recovering databases and individual tables with the existing RMAN utility, so Bob explains new RMAN scenarios and details when to back up just the CDB root, the entire CDB, or individual PDBs. He also covers how to create and manage a special type of PD called an application PDB, also known as an application container, and shows how to leverage the versioning capabilities included with application containers.

Concepts

0. Introduction

01 - Multitenant
02 - What you should know

1. Multitenant Architecture

03 - Components of a multitenant environment
04 - CDB root
05 - PDB seed
06 - Connecting to CDBs and PDBs
07 - Multitenant data dictionary views
08 - Challenge - Connect to the CDB and PDB
09 - Solution - Connect to the CDB and PDB

2. Create and Clone PDBs and Users

10 - Creating a container database
11 - Creating a PDB from the seed database
12 - Copying a PDB
13 - Dropping a PDB
14 - Creating and managing local and common users
15 - Moving a PDB
16 - Upgrading a PDB to a new database version
17 - Challenge - Move a PDB to a new container with SQL Developer
18 - Solution - Move a PDB to a new container with SQL Developer

3. Application PDBs

19 - Creating application containers and application PDBs
20 - Installing an application in an application PDB
21 - Challenge - Upgrade an application PDB
22 - Solution - Upgrade an application PDB

4. Multitenant Backup and Recovery

23 - Back up a CDB and PDB with RMAN
24 - Recover a CDB or one of the PDBs
25 - Challenge - Recover a PDB tablespace
26 - Solution - Recover a PDB tablespace

Conclusion

27 - Next steps