OD-AI-MA: Oracle AI Database Multitenant Architecture

Module 1: CDB Basics

• Objectives
• Challenges
• Multitenant Architecture: Benefits
• Other Benefits of Multitenant Architecture
• Oracle Multitenant Container Database
• Configurations
• SYSTEM Objects in the USER Container
• Provisioning a Pluggable Database
• Multitenant Container Database Architecture
• Containers
• Tools
• Data Dictionary and Dynamic Views
• Terminology
• Impacts
• Summary
• Multitenant Architecture Poster

Module 2: CDB and Regular PDBs

• Objectives
• Goals
• Creating a CDB
• Creating a CDB Using SQL*Plus
• SEED FILE_NAME_CONVERT Clause
• ENABLE PLUGGABLE DATABASE Clause
• After CDB Creation
• 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
• Creating New PDBs
• Creating New PDB from PDB$SEED
• Steps with FILE_NAME_CONVERT
• Steps without FILE_NAME_CONVERT
• Summary

Module 3: Application PDBs and Application Installation

• Objectives
• 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 vs Hybrid Model
• Container Map
• Container Map: Example
• Query Routed Appropriately
• Dynamic Container Map
• Container Map and Container Defaults
• Query Across CDBs Using Application Root Replica
• Durable Location Transparency
• Data Dictionary Views
• Terminology in Application Container Context
• Commonality in Application Containers
• Impacts
• Summary

Module 4: PBD Creation

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

Module 5: CDB and PDB Management

• Objectives
• Connection
• Switching Connection
• Creating Services
• Renaming Services
• Starting Up a CDB Instance
• Mounting a CDB
• Opening a CDB
• Opening a PDB
• Pluggable Database Hybrid Read-Only Mode
• 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 a PDB
• Configuring Host Name and Port Number per PDB
• Summary

Module 6: Storage

• Objectives
• Objects in Tablespaces
• Tablespaces Created During PDB Creation
• Defining Default Permanent Tablespaces
• Temporary Tablespaces
• UNDO Tablespaces
• Summary

Module 7: Security

• Objectives
• 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
• 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
• Summary

Module 8: Backup and Duplicate

• Objectives
• 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 an Active PDB into an Existing CDB
• Example: Scenario 1
• Example: Scenario 2
• Duplicating On-Premises CDB as a Cloud Encrypted CDB
• Duplicating On-Premises Encrypted CDB as a Cloud Encrypted CDB
• Migrating a Cloud Encrypted CDB to an On-Premises CDB
• Checking for Block Corruption
• Summary

Module 9: Recovery and Flashback

• Objectives
• Goals
• Instance Failure and Instance Recovery
• NOARCHIVELOG Mode
• CDB and PDB Tempfile Recovery
• CDB SYSTEM or UNDO Tablespace Recovery
• PDB SYSTEM or UNDO Tablespace Recovery
• CDB or PDB Non-SYSTEM Tablespace Recovery
• Point-In-Time 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: Scenario 1
• Plugging a PDB and Transporting PDB Backups to a CDB: Scenario 2
• Using Pre-Plug-in Backups
• Considerations
• Example
• CDB and PDB Flashback
• PDB Flashback and Clean Restore Point
• Creating a PDB Snapshot from a PDB
• PDB Snapshot Carousel
• Creating PDB Snapshots
• Creating PDBs Using PDB Snapshots
• Dropping PDB Snapshots
• Flashbacking PDBs Using PDB Snapshots
• Switching Over a Refreshable Cloned PDB
• Unplanned Switchover
• Summary

Module 10: Performance

• Objectives
• Tuning a CDB
• Sizing the CDB
• Testing the Estimates
• Managing SGA for PDBs
• Managing PGA for PDBs
• Monitoring PDB Memory Usage
• AWR and ADDM Behavior
• PDB-Level Snapshot Views
• Configuring Automatic ADDM Analysis at the PDB Level
• Enabling ADDM in a Pluggable Database
• ADDM Data Visibility
• 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
• DB Replay: The Big Picture
• Capturing and Replaying in a CDB and PDBs
• Reporting
• Consolidated Database Replay Use Cases
• Use Cases: Source Workloads
• The Big Picture
• Step 1
• Step 2
• Step 3
• Step 4
• Summary

Module 11: Resource Allocation

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

Module 12: Data Movement

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

Module 13: Upgrade Methods

• Objectives
• Upgrading CDB and PDBs to 23ai: Methods
• Upgrading CDB and PDBs to 23ai
• Installing Oracle Database 23ai Software Using OUI
• AutoUpgrade Utility System Checks
• Running AutoUpgrade Fixups
• Configuration File to Run AutoUpgrade Prechecks
• Upgrading Using the AutoUpgrade Utility
• AutoUpgrade with Source and Target Database Homes on the Same Server
• AutoUpgrade with Source and Target Database Homes on Different Servers
• Overview of AutoUpgrade Job Stages
• AutoUpgrade Command-Line Parameters and Options
• AutoUpgrade Command-Line Syntax
• AutoUpgrade Configuration File
• Using Replay Upgrade’s Automatic Upgrade on PDB Plug-In to a CDB23ai
• How to Disable or Enable Replay Upgrade
• Converting and Upgrading Regular PDBs to Application PDBs
• Cross-Platform Transportable PDB
• Cross-Platform PDB Transport: Phase 1
• Cross-Platform PDB Transport: Phase 2
• Summary