Oracle Database 12c R2: Managing Multitenant Architecture (D99340) – Outline

Detailed Course Outline

CDB Basics

• Describe the multitenant architecture
• Describe the CDB root and pluggable database containers
• Differentiate the CDB root from a pluggable database
• Understand the terminology of commonality
• List impacts in various areas

CDB and Regular PDBs

• Configure and create a CDB
• Create a new PDB from the CDB seed
• Explore the instance
• Explore the structure of PDBs
• Explore the Automatic Diagnostic Repository (ADR)

Application PDBs and Application Installation

• Describe application containers in CDBs
• Explain the purpose of application root and application seed
• Define application PDBs
• Create application PDBs
• Explain application installation on top of application containers
• Install an application
• Upgrade and patch applications
• Describe the commonality concept in application contexts

PDB Creation

• Clone a regular PDB
• Clone an application PDB
• Unplug and plug a non-CDB
• Unplug and plug a regular PDB
• Unplug and plug an application container
• Convert regular PDBs to application PDBs
• Configure and use the local UNDO mode
• Perform hot cloning and relocation

CDB and PDB Management

• Establish connections to CDB and PDB
• Start up and shut down a CDB
• Open and close PDBs
• Avoid service name conflicts
• Start PDB service
• Change the different modes and settings of PDBs
• Evaluate the impact of parameter value changes
• Configure host name and port number per PDB

Storage

• Manage permanent tablespaces in CDB and PDBs
• Manage temporary tablespaces in CDB and PDBs
• Manage the UNDO tablespaces in CDB root and PDB

Security

• Manage common and local users, roles, privileges and profiles in PDBs
• Manage common and local objects in application containers
• Enable common users to access data in PDBs
• Manage PDB lockdown profiles
• Audit users in CDB and PDBs
• Manage other types of policies in application containers
• Protect data with Database Vault policies in CDB and PDBs
• Encrypt data in PDBs

Backup, Recovery, and Flashback

• Backup CDB and PDBs
• Recover a PDB from essential file damage
• Recover a PDB from non-essential file damage
• Use RMAN backups to plug unplugged PDBs
• Duplicate PDBs
• Validate CDBs and PDBs
• Perform CDB flashback
• Perform PDB flashback

Performance Monitoring

• Monitor operations in a CDB and PDBs
• Monitor performance in a CDB and PDBs
• Manage SGA and PGA limits at the PDB level
• Manage AWR snapshots at the CDB and PDB levels
• Run ADDM tasks for CDB and PDB recommendations
• Manage application shared object statistics
• Control query DOP involving the containers() construct
• Control PDB IO rate limits

Resources Allocation

• Manage resource allocation between PDBs and within a PDB
• Manage PDB performance profiles
• Avoid excessive session PGA

Data Movement

• Export from a non-CDB and import into a PDB
• Export from a PDB and import into a PDB
• Export from a PDB and import into a non-CDB
• Use SQL*Loader to load data into a PDB

Upgrade Methods

• Upgrade 12.1 CDB to 12.2
• Upgrade 12.1 PDBs to PDBs in 12.2
• Plug in a remote PDB through XTTS into a target CDB

Miscellaneous

• Describe the limits of data replication
• Describe XStreams usage with PDB and CDB
• Describe Data Guard with CDB and PDB
• Schedule operations in a PDB using Oracle Scheduler
• Mine PDB statements using LogMiner

PDBs in Cloud

• Create a database deployment in the Cloud
• Create PDBs in the Cloud database using DBaaS Monitor
• Understand encryption in a Cloud CDB and PDBs
• Manage PDBs in the Cloud database using DBaaS Monitor
• Migrate on-premises PDBs in a database deployment in the Cloud