title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 12c: Manage The Multitenant Architecture
Course Description
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.Objectives
- 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
Audience
- 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
Prerequisites
-
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)
- 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
Topics
- Cloud Computing Principles
- Peering Into The Architecture
- Multitenant Database Instance
- Multitenant Storage Architecture
- Multitenant Data Dictionary
- Benefits Of The Architecture
- Challenges Of The Architecture
- About cDB Capacity Planning
- cDB & pDB Creation
- Using Oracle Installer
- Using DBCA
- cDB & pDB Connections
- Using SQL*Plus
- EM Cloud Control
- 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
- 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
- Clone A pDB
- Unplug & Plug-In A pDB
- Migrate A Non-cDB To A pDB
- pDB Provisioning Using EM CC
- pDB Provisioning Using DBCA
- About Multitenant Administration
- cDB Administration
- cdb$root Administration
- pDB Administration
- Manage Permanent Tablespaces
- Manage Temporary Tablespaces
- 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
- About Resource Management
- cDB Resource Plans & Directives
- pDB Resource Plans & Directives
Related Courses
-
Introduction to Oracle Database 12c and SQL
DBOR-950- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
-
Oracle Database 12c: SQL II - Intermediate
DBOR-951- Duration: 3 Days
- Delivery Format: Classroom Training, Online Training
- Price: 2,100.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
Exam Terms & Conditions
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Purchase Information
title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.