Course Overview
The single most important new capability introduced with the Oracle 12c release of the database is the multitenant database feature. With this technology, the Oracle database can be a full participant in a cloud computing-based application architecture. Even a traditional on-premise systems architecture can be dynamically and dramatically transformed as a result of this feature. Many traditional and new database features are enhanced or introduced when a multitenant database configuration is used.
What you’ll learn
We will devote this course to the following multitenant database topics:
- Understanding the multitenant database architecture
- Review the business challenges, needs and objectives that are addressed with multitenant database technology
- Creating and connecting to Oracle container databases (cDBs) and pluggable databases (pDBs)
- Managing common and local users along with multiple container management of security objects
- Creating container databases, provisioning pluggable databases, perform unplug and plug-in, and administering multiple database tenants
- Migrating traditional single-tenant databases to pluggable databases
- Managing temporary and permanent storage within container and pluggable databases
- Multitenant backup and recovery strategies, including complete and incomplete recovery at either the container or the pluggable database level, Flashback Database and other sophisticated recovery operations
- Using SQL, RMAN, DBCA, and Enterprise Manager Cloud Control for the administration of multiple database tenants
- Resource management and container caging
Requirements
- Senior developers will also need these prerequisites, or equivalent experience.
- DBOR-950 and DBOR-951 Oracle Database 12c: SQL Fundamentals (Levels I & II)
- DBOR-952 and DBOR-953 Oracle Database 12c: PL/SQL Fundamentals (Levels I & II)
- Administrators these are the required prerequisites, or equivalent experience:
- DBOR-955 Oracle Database 12c: Install & Upgrade Workshop
- DBOR-956 Oracle Database 12c: Architecture & Internals
- DBOR-957 Oracle Database 12c: Administration Workshop
- DBOR-958 Oracle Database 12c: Administration II - Advanced
- DBOR-959 Oracle Database 12c: Resource Manager & Scheduler
Target audiences
- Database administrators
- Application designers and developers
- Web server administrators
- System administrators
- Implementation specialists
- Data center support engineers
- Chief Information Officers (CIO) and other information technology (IT) management professionals
Curriculum
- 1 Section
- 9 Lessons
- 3 Days
Expand all sectionsCollapse all sections
- Topics9
- 1.1Fundamentals: 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
- 1.2Fundamentals: 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
- 1.3Fundamentals: 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
- 1.4Provisioning: 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
- 1.5Provisioning: 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
- 1.6Administration: Administering Multitenant Databases About Multitenant Administration cDB Administration cdb$root Administration pDB Administration
- 1.7Administration: Multitenant Storage Management Manage Permanent Tablespaces Manage Temporary Tablespaces
- 1.8Administration: 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
- 1.9Administration: Multitenant Resource Management About Resource Management cDB Resource Plans & Directives pDB Resource Plans & Directives
Instructor
