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