Overview
During this course, you gain a conceptual understanding of the multitenant architecture and learn how to manage an
Oracle multitenant container database(CDB) and its different types of pluggable databases (PDB) in an effective and efficient manner.
This 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
Learn To:
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
Monitor performance and manage resources within a multitenant container database and pluggable databases.
Perform backup, recover and ashback operations on a multitenant container database and regular and application pluggable databases.
Course Outline :: Oracle Database: Managing Multitenant Architecture::
Perform particular operations like Oracle Data Pump transportation, loading, encrypting, auditing.
Manage the CDB and PDBs in specic congurations like Data Guard, Database Vault.
Benefits To You
To provide an acceptable response time to users and manage resources effectively, you learn how to monitor performance and manage resources within the multitenant container database and its pluggable databases, and within each pluggable database.
Another important aspect is the data movement between non-CDBs and pluggable databases, and between pluggable databases.
It is also important to understand the procedures of upgrading an Oracle Database multitenant container database or an Oracle Database pluggable database.
Finally, students discover the way multitenant container database and pluggable databases are created and monitored in the Cloud.
Audience
Administrator
Architect
Database Administrator
Prerequisites
Oracle Database: Administration Workshop
Objectives
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
Course Outline :: Oracle Database: Managing Multitenant Architecture::
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, proles, objects in CDBs and PDBs
Manage PDB lockdown proles
Backup, duplicate, recover and ashback CDB and PDBs
Day 1
CDB Basics
CDB and Regular PDBs
Application PDBs and Application Installation
Day 2
PDB Creation
CDB and PDB Management
Storage
Security
Day 3
Backup and Duplicate
Recovery and Flashback
Performance Monitoring
Day 4
Resources Allocation
Data Movement
Upgrade methods
Programme scope, delivery arrangements and suitability are confirmed during enquiry.