Oracle 19C Database Multitenant Architecture (TTOR20719)

Course Objectives

Learning Objectives

Working in a hands-on learning environment led by our expert facilitator, you’ll explore:

• CDB Management Skills: Gain expertise in managing Container Databases (CDBs), including setup, configuration, and maintenance.
• PDB Operations Proficiency: Develop the ability to efficiently handle Pluggable Database (PDB) operations like creation, cloning, and management.
• Database Security Measures: Learn to implement and manage security protocols in both CDBs and PDBs, ensuring data integrity and compliance.
• Backup and Recovery Techniques: Master the techniques for performing backups and recoveries of CDBs and PDBs, ensuring data safety and continuity.
• Performance Optimization: Acquire skills to optimize the performance of databases within the Oracle Multitenant environment, including tuning and resource allocation.
• Data Movement and Storage Management: Understand and apply methods for effective data movement and storage management in a Multitenant architecture.

Need different skills or topics?  If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate.  We offer additional Oracle, database, scripting, administration and other related topics that may be blended with this course for a track that best suits your needs.

Course Prerequisites

Course Agenda

1.       CDB Basics

• Challenges
• Non-CDB Architecture
• Multitenant Architecture: Benefits
• Other Benefits of Multitenant Architecture
• Oracle Multitenant Container Database
• Configurations
• Database Objects in a non-CDB
• User-Added Objects to a non-CDB
• SYSTEM Objects in the USER Container
• Provisioning a Pluggable Database
• Multitenant Container Database Architecture
• Containers & Tools
• Data Dictionary and Dynamic Views
• Impacts

2.       CDB and Regular PDBs

• Creating a CDB
• Creating a CDB: Using SQL*Plus
• New Clause: SEED FILE_NAME_CONVERT
• New Clause: ENABLE PLUGGABLE DATABASE
• After CDB Creation: What’s New in CDB
• Data Dictionary Views: DBA_xxx
• Data Dictionary Views: CDB_xxx
• Data Dictionary Views: Examples
• Data Dictionary Views: V$xxx Views
• After CDB Creation: To do List
• Automatic Diagnostic Repository
• Automatic Diagnostic Repository: alert.log File
• Provisioning New Pluggable Databases
• Tools
• Create New PDB from PDB$SEED
• Steps: With FILE_NAME_CONVERT
• Steps: Without FILE_NAME_CONVERT

3.       Application PDBs and Application Installation

• Regular PDBs
• PDBs and Applications
• Application Containers
• Application Containers: Other Features
• Types of Containers
• Creating Application PDBs
• Application Name and Version
• Installing Applications
• Patching and Upgrading Applications
• Application Common Objects
• Use Cases for Application Containers
• Use Case: Pure PDB-Based Versus Hybrid Model
• Container Map
• Container Map: Example
• Query Routed Appropriately
• Dynamic Container Map
• Container Map and Containers Default
• Query Across CDBs Using Application Root Replica
• Durable Location Transparency
• Data Dictionary Views
• Terminology in Application Container Context
• Commonality in Application Containers
• Impacts

4.       PDB Creation

• Cloning Regular PDBs
• Cloning Application Containers
• Plugging a Non-CDB into CDB
• Plugging a Non-CDB into CDB Using DBMS_PDB
• Replicating Non-CDB into CDB
• Cloning a Non-CDB or Remote PDB
• Plugging an Unplugged Regular PDB into CDB
• Flow
• Plugging Using Archive File
• Unplugging and Plugging Application PDBs
• Converting Regular PDBs to Application PDBs
• Unplugging and Plugging a PDB with Encrypted Data
• Local UNDO Mode Versus Shared UNDO Mode
• Cloning Remote PDBs in Hot Mode
• Near-Zero Downtime PDB Relocation
• Proxy PDB: Query Across CDBs Proxying Root Replica
• Creating a Proxy PDB
• Dropping PDBs

5.       CDB and PDB Management

• Connection
• Switching Connection
• Creating Services
• Renaming Services
• Starting Up a CDB Instance
• Mounting a CDB
• Opening a CDB
• Opening a PDB
• Automatic PDB Opening
• Closing a PDB
• Shutting Down a CDB Instance
• Changing PDB Mode
• Modifying PDB Settings
• Instance Parameter Change Impact
• Instance Parameter Change Impact: Example
• Using ALTER SYSTEM Statement on PDB
• Configuring Host Name and Port Number per PDB

6.       Storage

• Objects in Tablespaces
• Tablespaces Created During PDB Creation
• Defining Default PermanentTablespaces
• Temporary Tablespaces
• UNDO Tablespaces

7.       Security

• Creating Common Users in the CDB and PDBs
• Creating Common Roles in the CDB and PDBs
• Granting Privileges Commonly in the CDB and PDBs
• Creating Common Profiles in the CDB and PDBs
• Common Objects in Application Containers
• Operations on Data-Linked Objects
• Enabling Common Users to Access Data in PDBs
• Finding Information About CONTAINER_DATA Attributes
• Restricting Operations with PDB Lockdown Profiles
• Restricting Operations in a PDB Lockdown Profile
• PDB Lockdown Profiles Inheritance
• Static and Dynamic PDB Lockdown Profiles
• Auditing Actions in the CDB and PDBs
• Managing Other Types of Security Policies in Application Containers
• Securing Data with Oracle Database Vault
• Oracle Database Vault-Enabled Strict Mode
• Managing Keystore in the CDB and PDBs
• Creating and Opening a Keystore
• Setting TDE Master Encryption Keys
• Managing Keystore in the CDB and PDBs
• Keystore Management Changes for PDBs
• Defining the Keystore Type
• Isolating a PDB Keystore
• Converting a PDB to Run in Isolated Mode
• Converting a PDB to Run in United Mode
• Migrating a PDB Between Keystore Types
• Unplugging and Plugging a PDB with Encrypted Data
• Per-PDB Wallet for PDB Certificates

8.       Backup and Duplicate

   Goals

• Syntax and Clauses in RMAN
• CDB Backup: Whole CDB Backup
• CDB Backup: Partial CDB Backup
• PDB Backup: Partial PDB Backup
• Using RMAN Backup to Plug an Unplugged PDB
• Duplicating Pluggable Databases
• Cloning Active PDB into an Existing CDB
• Duplicating On-Premise CDB as Cloud Encrypted CDB
• Duplicating On-Premise Encrypted CDB as Cloud Encrypted CDB
• Migrating Cloud Encrypted CDB as On-Premise CDB
• Checking for Block Corruption

9.       Recovery and Flashback

• Instance Failure and Instance Recovery
• NOARCHIVELOG Mode
• PDB Tempfile Recovery
• PDB SYSTEM or UNDO Tablespace Recovery
• PDB non-SYSTEM Tablespace Recovery
• PITR
• Migrating a Non-CDB to a CDB
• Migrating a Non-CDB and Transporting Non-CDB Backups to a CDB
• Relocating/Plugging a PDB into Another CDB
• Plugging a PDB and Transporting PDB Backups to a CDB - 1
• Plugging a PDB and Transporting PDB Backups to a CDB - 2
• Using PrePlugin Backups
• CDB and PDB Flashback
• PDB Flashback and Clean Restore Point
• PDB Snapshot Carousel
• Creating PDB Snapshot
• Creating PDBs Using PDB Snapshots
• Dropping PDB Snapshots
• Flashbacking PDBs Using PDB Snapshots
• Switching Over a Refreshable Cloned PDB
• Unplanned Switchover

10.   Performance

• Tuning a CDB
• Sizing the CDB
• Testing the Estimates
• Managing SGA and PGA for PDBs
• Monitoring PDB Memory Usage
• AWR and ADDM Behavior
• PDB-Level Snapshot Views
• AWR Report
• ADDM Tasks: At the CDB Level Only
• Basic Rules: Statistics for Common Objects
• Controlling the Degree of Parallelism of Queries
• Heat Map and ADO Support
• Managing Heat Map and ADO Policies in PDB
• CDB Fleet
• CDB Lead and CDB Members
• Use Cases
• Consolidated Database Replay Use Cases
• Use Cases: Source Workloads
• The Big Picture

11.   Resources Allocation

• Allocating Resources in the CDB
• Resource Manager and Pluggable Databases
• Managing Resources Between PDBs
• CDB Resource Plan Basics: Limits
• PDB IO Rate Limit
• Maintaining a CDB Resource Plan
• Managing Resources Within a PDB
• Putting It Together
• PDB-Level Parallel Statement Queuing
• PDB-Level Parallel Statement Queuing: CPU_COUNT
• Session PGA Limit
• Performance Profiles

12.   Data Movement

• Using Oracle Data Pump with PDBs
• Exporting from non-CDB and Importing into PDB
• Exporting and Importing Between PDBs
• Exporting from PDB and Importing into non-CDB
• Full Transportable Export/Import: Overview
• Full Transportable Export/Import: Usage
• Full Transportable Export/Import: Example
• Transporting a Database Over the Network: Example
• Using SQL*Loader with PDBs

13.   Upgrade Methods

• Upgrading CDB and PDBs
• Converting and Upgrading Regular PDBs to Application PDBs
• Cross-Platform Transportable PDB

14.   Time Permitting / Extras

• Using Xstreams with a CDB and PDB
• Creating a Standby of a CDB
• Instantiating a PDB on a Standby
• Scheduling Operations in a PDB
• Jobs Coordinator and Resources
• Mining Statements of a PDB Using LogMiner 

Course Materials

Setup Made Simple! Learning Experience Platform (LXP) 

All applicable course software, digital courseware files or course notes, labs, data sets and solutions, live coaching support channels, CodeCoach.AI anytime tutor access, and rich extended learning and post training resources are provided for you in our “easy access, single source, no install required” online Learning Experience Platform (LXP), remote lab and content environment. Access periods vary by course. We’ll collaborate with you to ensure your team is set up and ready to go well in advance of the class. Please inquire about set up details and options for your specific course of interest.