Oracle Database 19c: Multitenant Architecture

Description

In this course, you will learn about the multitenant architecture and the different types of pluggable databases (PDBs) (regular and application) in multitenant container databases (CDBs). The course covers other methods of PDB creation, how to start and shut down a CDB and how to open and close a PDB. It also covers security aspects in CDBs and PDBs in various areas, such as privileges and roles, lockdown profiles, auditing, Database Vault, and encryption. The course also covers availability through backup, duplicate, recovery, and flashback topics and then performance, monitoring, and resources allocation management in CDBs and PDBs. In addition, the course covers how you can move data from a non-CDB environment to a PDB, 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. Finally, the course covers upgrade methods for converting a non-CDB to a PDB, upgrading an Oracle Database release 12.2 and 18c PDB, or CDB to a 19c PDB or CDB

Objectives

• Understand the multitenant architecture
• Create and manage a multitenant container database and pluggable databases
• Understand regular and application pluggable databases
• Manage storage within a multitenant container database and pluggable databases
• Manage security within a multitenant container database and regular and application pluggable databases
• Monitor performance and manage resources within a multitenant container database and pluggable databases
• Perform backup, recover and flashback operations on a multitenant container database and regular and application pluggable databases
• Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing
• Manage the CDB and PDBs in specific configurations like Data Guard, Database Vault