Oracle Database 12c: Manage The Multitenant Architecture (ORMMTA12C) – Outline

Detailed Course Outline

Fundamentals: The Multitenant Database Architecture
  • Cloud Computing Principles
  • Peering Into The Architecture
  • Multitenant Database Instance
  • Multitenant Storage Architecture
  • Multitenant Data Dictionary
  • Benefits Of The Architecture
  • Challenges Of The Architecture
Fundamentals: Creating & Connecting To Multitenant Databases
  • About cDB Capacity Planning
  • cDB & pDB Creation
  • Using Oracle Installer
  • Using DBCA
  • cDB & pDB Connections
  • Using SQL*Plus
  • EM Cloud Control
Fundamentals: Multitenant Database Security Management
  • Multitenant Security Model
  • Multitenant Privileges & Roles
  • Common Users
  • Local Users
  • Common & Local Roles & Privileges
  • Commonly & Locally Defined
  • Commonly & Locally Granted
  • Common & Local Profiles
  • Common & Local Dictionary Access
  • Multitenant Unified Auditing
  • Local Audit Policies
  • Querying The Unified Audit Trail
  • Common Audit Policies
  • Auditing Management With EM CC
Provisioning: Provisioning pDBs From pdb$seed
  • Provision & Decommission pDBs
  • EM CC Provisioning Prerequisites
  • pDB File Location Prerequisites
  • Provision A pDB From pdb$seed
  • Provision Using SQL
  • Provision Using EM CC
  • Post Provisioning Checklist
  • Drop A pDB
  • Querying cDB & pDB Metadata
Provisioning: Additional pDB Provisioning
  • Clone A pDB
  • Unplug & Plug-In A pDB
  • Migrate A Non-cDB To A pDB
  • pDB Provisioning Using EM CC
  • pDB Provisioning Using DBCA
Administration: Administering Multitenant Databases
  • About Multitenant Administration
  • cDB Administration
  • cdb$root Administration
  • pDB Administration
Administration: Multitenant Storage Management
  • Manage Permanent Tablespaces
  • Manage Temporary Tablespaces
Administration: Multitenant Backup & Recovery
  • Devising Multitenant Recovery Plan
  • RMAN Multitenant Usage
  • RMAN Multitenant Backup
  • EM CC Multitenant Backup
  • RMAN Multitenant Recovery
  • Complete Recovery
  • Incomplete cDB / pDB Point-in-time Recovery (PITR)
  • Incomplete Table Point-in-time Recovery (PITR)
  • Multitenant Flashback Database
  • EM CC Multitenant Recovery
  • Multitenant Database Duplication
  • cDB Duplication
  • pDB Duplication
Administration: Multitenant Resource Management
  • About Resource Management
  • cDB Resource Plans & Directives
  • pDB Resource Plans & Directives