CONTENUTI

1: CDB Basics

• Objectives 1-2
• Challenges 1-3
• Multitenant Architecture: Benefits 1-4
• Other Benefits of Multitenant Architecture 1-5
• Oracle Multitenant Container Database 1-6
• Configurations 1-7
• SYSTEM Objects in the USER Container 1-8
• Provisioning a Pluggable Database 1-9
• Multitenant Container Database Architecture 1-10
• Containers 1-11
• Tools 1-12
• Data Dictionary and Dynamic Views 1-13
• Terminology 1-14
• Impacts 1-16
• Summary 1-18
• Multitenant Architecture Poster 1-19

 

2: CDB and Regular PDBs

• Objectives 2-2
• Goals 2-3
• Creating a CDB 2-4
• Creating a CDB: Using SQL*Plus 2-5
• Clause: SEED FILE_NAME_CONVERT 2-6
• Clause: ENABLE PLUGGABLE DATABASE 2-7
• After CDB Creation 2-8
• Data Dictionary Views: DBA_xxx 2-9
• Data Dictionary Views: CDB_xxx 2-10
• Data Dictionary Views: Examples 2-11
• Data Dictionary Views: V$xxx Views 2-12
• After CDB Creation: To Do List 2-13
• Automatic Diagnostic Repository 2-14
• Automatic Diagnostic Repository: alert.log File 2-15
• Provisioning New Pluggable Databases 2-16
• Tools 2-17
• Creating New PDB from PDB$SEED 2-18
• Steps: With FILE_NAME_CONVERT 2-19
• Steps: Without FILE_NAME_CONVERT 2-20
• Summary 2-21

 

3: Application PDBs and Application Installation

• Objectives 3-2
• Regular PDBs 3-4
• PDBs and Applications 3-5
• Application Containers 3-6
• Application Containers: Other Features 3-7
• Types of Containers 3-8
• Creating Application PDBs 3-9
• Application Name and Version 3-10
• Installing Applications 3-11
• Patching and Upgrading Applications 3-12
• Application Common Objects 3-13
• Use Cases for Application Containers 3-14
• Use Case: Pure PDB-Based Vs Hybrid Model 3-15
• Container Map 3-16
• Container Map: Example 3-17
• Query Routed Appropriately 3-18
• Dynamic Container Map 3-19
• Container Map and Containers Default 3-20
• Query Across CDBs Using Application Root Replica 3-21
• Durable Location Transparency 3-22
• Data Dictionary Views 3-23
• Terminology in Application Container Context 3-24
• Commonality in Application Containers 3-25
• Impacts 3-26
• Summary 3-27

 

4: PDB Creation

• Objectives 4-2
• Cloning Regular PDBs 4-4
• Cloning Application Containers 4-5
• Plugging a Non-CDB into CDB 4-6
• Plugging a Non-CDB into CDB as PDB Using DBMS_PDB 4-7
• Replicating Non-CDB into CDB 4-8
• Cloning a Non-CDB or Remote PDB 4-9
• Plugging an Unplugged Regular PDB into CDB 4-10
• Flow 4-11
• Plugging Using Archive File 4-13
• Unplugging and Plugging Application PDBs 4-14
• Converting Regular PDBs to Application PDBs 4-15
• Unplugging and Plugging a PDB with Encrypted Data 4-16
• Local UNDO Mode Vs Shared UNDO Mode 4-17
• Cloning Remote PDBs in Hot Mode 4-18
• Near-Zero Downtime PDB Relocation 4-19
• Proxy PDB: Query Across CDBs Proxying Root Replica 4-21
• Creating a Proxy PDB 4-22
• Using DBCA to Clone a Remote PDB 4-23
• Using DBCA to Relocate a Remote PDB 4-24
• Using DBCA to Duplicate a CDB 4-25
• Dropping PDBs 4-26
• Summary 4-27

 

5: CDB and PDB Management

• Objectives 5-2
• Connection 5-4
• Switching Connection 5-5
• Creating Services 5-6
• Renaming Services 5-7
• Starting Up a CDB Instance 5-8
• Mounting a CDB 5-9
• Opening a CDB 5-10
• Opening a PDB 5-11
• Pluggable Database Hybrid Read-Only Mode 5-12
• Automatic PDB Opening 5-16
• Closing a PDB 5-17
• Shutting Down a CDB Instance 5-18
• Changing PDB Mode 5-19
• Modifying PDB Settings 5-20
• Instance Parameter Change Impact 5-21
• Instance Parameter Change Impact: Example 5-22
• Using ALTER SYSTEM Statement on PDB 5-23
• Configuring Host Name and Port Number per PDB 5-24
• Summary 5-25

 

6: Storage

• Objectives 6-2
• Objects in Tablespaces 6-3
• Tablespaces Created During PDB Creation 6-5
• Defining Default Permanent Tablespaces 6-6
• Temporary Tablespaces 6-7
• UNDO Tablespaces 6-8
• Summary 6-9

 

7: Security

• Objectives 7-2
• Creating Common Users in the CDB and PDBs 7-4
• Creating Common Roles in the CDB and PDBs 7-5
• Granting Privileges Commonly in the CDB and PDBs 7-6
• Creating Common Profiles in the CDB and PDBs 7-7
• Common Objects in Application Containers 7-8
• Operations on Data-Linked Objects 7-9
• Enabling Common Users to Access Data in PDBs 7-10
• Finding Information About CONTAINER_DATA Attributes 7-11
• Restricting Operations with PDB Lockdown Profiles 7-12
• Restricting Operations in a PDB Lockdown Profile 7-13
• PDB Lockdown Profiles Inheritance 7-14
• Static and Dynamic PDB Lockdown Profiles 7-15
• Auditing Actions in the CDB and PDBs 7-16
• Managing Other Types of Security Policies in Application Containers 7-18
• Securing Data with Oracle Database Vault 7-19
• Oracle Database Vault-Enabled Strict Mode 7-20
• Managing Keystore in the CDB and PDBs 7-21
• Creating and Opening a Keystore 7-22
• Setting TDE Master Encryption Keys 7-23
• Managing Keystore in the CDB and PDBs 7-24
• Keystore Management Changes for PDBs 7-25
• Defining the Keystore Type 7-26
• Isolating a PDB Keystore 7-27
• Converting a PDB to Run in Isolated Mode 7-28
• Converting a PDB to Run in United Mode 7-29
• Migrating a PDB Between Keystore Types 7-30
• Unplugging and Plugging a PDB with Encrypted Data 7-31
• Per-PDB Wallet for PDB Certificates 7-32
• Summary 7-33

 

8: Backup and Duplicate

• Objectives 8-2
• Goals 8-3
• Syntax and Clauses in RMAN 8-4
• CDB Backup: Whole CDB Backup 8-6
• CDB Backup: Partial CDB Backup 8-7
• PDB Backup: Partial PDB Backup 8-8
• Using RMAN Backup to Plug an Unplugged PDB 8-9
• Duplicating Pluggable Databases 8-10
• Cloning Active PDB into an Existing CDB 8-11
• Example: 1 8-12
• Example: 2 8-13
• Duplicating On-Premises CDB as Cloud Encrypted CDB 8-14
• Duplicating On-Premises Encrypted CDB as Cloud Encrypted CDB 8-15
• Migrating Cloud Encrypted CDB as On-Premises CDB 8-16
• Checking for Block Corruption 8-17
• Summary 8-18

 

9: Recovery and Flashback

• Objectives 9-2
• Goals 9-4
• Instance Failure and Instance Recovery 9-5
• NOARCHIVELOG Mode 9-6
• CDB and PDB Tempfile Recovery 9-7
• CDB SYSTEM or UNDO Tablespace Recovery 9-8
• PDB SYSTEM or UNDO Tablespace Recovery 9-9
• CDB or PDB Non-SYSTEM Tablespace Recovery 9-10
• PITR 9-11
• Migrating a Non-CDB to a CDB 9-12
• Migrating a Non-CDB and Transporting Non-CDB Backups to a CDB 9-13
• Relocating/Plugging a PDB into Another CDB 9-14
• Plugging a PDB and Transporting PDB Backups to a CDB: 1 9-15
• Plugging a PDB and Transporting PDB Backups to a CDB: 2 9-16
• Using PrePlug-in Backups 9-17
• Considerations 9-18
• Example 9-19
• CDB and PDB Flashback 9-20
• PDB Flashback and Clean Restore Point 9-21
• Creating a PDB Snapshot from a PDB 9-22
• PDB Snapshot Carousel 9-23
• Creating PDB Snapshots 9-24
• Creating PDBs Using PDB Snapshots 9-25
• Dropping PDB Snapshots 9-26
• Flashbacking PDBs Using PDB Snapshots 9-27
• Switching Over a Refreshable Cloned PDB 9-28
• Unplanned Switchover 9-29
• Summary 9-30

 

10: Performance

• Objectives 10-2
• Tuning a CDB 10-4
• Sizing the CDB 10-5
• Testing the Estimates 10-6
• Managing SGA for PDBs 10-7
• Managing PGA for PDBs 10-8
• Monitoring PDB Memory Usage 10-9
• AWR and ADDM Behavior 10-10
• PDB-Level Snapshot Views 10-11
• Configuring Automatic ADDM Analysis at the PDB Level 10-12
• Enabling ADDM in a Pluggable Database 10-13
• ADDM Data Visibility 10-14
• Basic Rules: Statistics for Common Objects 10-16
• Controlling the Degree of Parallelism of Queries 10-17
• Heat Map and ADO Support 10-18
• Managing Heat Map and ADO Policies in PDB 10-19
• CDB Fleet 10-20
• CDB Lead and CDB Members 10-21
• Use Cases 10-22
• DB Replay: The Big Picture 10-23
• Capturing and Replaying in a CDB and PDBs 10-24
• Reporting 10-25
• Consolidated Database Replay Use Cases 10-26
• Use Cases: Source Workloads 10-27
• The Big Picture 10-28
• Step 1 10-29
• Step 2 10-30
• Step 3 10-31
• Step 4 10-32
• Summary 10-33

 

11: Resource Allocation

• Objectives 11-2
• Allocating Resources in the CDB 11-3
• Resource Manager and Pluggable Databases 11-4
• Managing Resources Between PDBs 11-5
• CDB Resource Plan Basics: Limits 11-6
• PDB IO Rate Limit 11-8
• CDB Resource Plan: Full Example 11-9
• Maintaining a CDB Resource Plan 11-10
• Managing Resources Within a PDB 11-11
• Putting It Together 11-12
• Considerations 11-13
• PDB-Level Parallel Statement Queuing 11-14
• PDB-Level Parallel Statement Queuing: CPU_COUNT 11-15
• Session PGA Limit 11-16
• Performance Profiles 11-17
• Summary 11-18

 

12: Data Movement

• Objectives 12-2
• Using Oracle Data Pump with PDBs 12-3
• Exporting from Non-CDB and Importing into PDB 12-4
• Exporting and Importing Between PDBs 12-5
• Full Transportable Export/Import: Overview 12-6
• Full Transportable Export/Import: Usage 12-7
• Full Transportable Export/Import: Example 12-9
• Transporting a Database Over the Network: Example 12-10
• Additional Features of Oracle Data Pump 12-11
• Using SQL*Loader with PDBs 12-12
• Summary 12-13

 

13: Upgrade Methods

• Objectives 13-2
• Upgrading CDB and PDBs to 23ai: Methods 13-3
• Upgrading CDB and PDBs to 23ai 13-4
• Installing Oracle Database 23ai Software Using OUI 13-5
• AutoUpgrade Utility System Checks 13-6
• Running AutoUpgrade Fixups 13-7
• Configuration File to Run AutoUpgrade Prechecks 13-8
• Upgrading Using the AutoUpgrade Utility 13-9
• AutoUpgrade with Source and Target Database Homes on the Same Server 13-10
• AutoUpgrade with Source and Target Database Homes on Different Servers 13-11
• Overview of AutoUpgrade Job Stages 13-12
• AutoUpgrade Command-Line Parameters and Options 13-14
• AutoUpgrade Command-Line Syntax 13-17
• AutoUpgrade Configuration File 13-18
• Using Replay Upgrade’s Automatic Upgrade on PDB Plug-In to a CDB23ai 13-19
• How to Disable or Enable Replay Upgrade 13-20
• Converting and Upgrading Regular PDBs to Application PDBs 13-21
• Cross-Platform Transportable PDB 13-22
• Cross-Platform PDB Transport: Phase 1 13-23
• Cross-Platform PDB Transport: Phase 2 13-24
• Summary 13-25