Overview

This OD-MMA: Oracle Database: Managing Multitenant Architecture course covers all aspects of the multitenant architecture, providing detailed information on the components of an Oracle multitenant container database and its regular and application pluggable databases.

You learn why and how to create and manage a multitenant container database and its regular and application pluggable databases, with storage structures appropriate for the business applications. You practice cold and hot cloning, plugging unplugged pluggable databases in multitenant container databases using various methods.

In addition, you learn how to create common and local users and administer database security to meet your business requirements by using encryption, Database Vault and auditing and you will learn how to create a database deployment in the Cloud.

Versions Supported: 19c, 18c, 12c

Skills Covered

  • Manage PDB snapshots
  • Encrypt data in PDBs and isolate PDB keystore
  • Monitor performance in CDBs and PDBs
  • Audit users in CDB and PDBs
  • Protect data with Database Vault policies in CDB and PDBs
  • Manage a CDB fleet
  • Manage resource allocation between PDBs and within a PDB
  • Use Data Pump operations from a non-CDB or CDB into a PDB
  • Upgrade 12c CDBs or PDBs to 18c
  • Configure and create a CDB
  • Create, clone, unplug, plug, relocate, proxy, switch over and drop PDBs
  • Startup and shutdown CDBs and PDBs
  • Manage tablespaces in CDB and PDBs
  • Manage common and local users, roles, privileges, profiles, objects in CDBs and PDBs
  • Manage PDB lockdown profiles
  • Backup, duplicate, recover and flashback CDB and PDBs

Who Should Attend

  • Administrator
  • Architect
  • Database Administrator

Course Curriculum

Prerequisites

Download Syllabus