Oracle Database 18c: Managing Multitenant Architecture Ed 1

Suggested Prerequisite

• Basic knowledge of Linux operating system
• Working knowledge of SQL and use of PL/SQL packages

Required Prerequisite

• Oracle Database 18c: Administration Workshop
• Oracle Database 18c: Administration Workshop

Audience

• Database Administrators
• Database Designers
• Support Engineer
• Technical Administrator
• Data Warehouse Administrator

Course Topics

1. CDB Basics

• Differentiate the CDB root from a pluggable database
• Describe the multitenant architecture
• List impacts in various areas
• Describe the CDB root and pluggable database containers
• Understand the terminology of commonality

2. PDB Creation

• Convert regular PDBs to application PDBs
• Clone a regular PDB
• Unplug and plug a non-CDB
• Unplug and plug a regular PDB
• Perform hot cloning and relocation
• Configure and use the local UNDO mode
• Unplug and plug an application container
• Clone an application PDB

3. Backup and Duplicate

• Validate CDBs and PDBs
• Duplicate PDBs
• Backup CDB and PDBs
• Duplicate a CDB as encrypted
• Use RMAN backups to plug unplugged PDBs
• Duplicate an active PDB into an existing CDB

4. Resources Allocation

• Avoid excessive session PGA
• Enable parallel statement queuing at PDB level
• Manage PDB performance profiles
• Manage resource allocation between PDBs and within a PDB

5. CDB and Regular PDBs

• Create a new PDB from the CDB seed
• Explore the structure of PDBs
• Explore the instance
• Provision new PDBs
• Explore the Automatic Diagnostic Repository (ADR)
• Configure and create a CDB

6. CDB and PDB Management

• Start up and shut down a CDB
• Configure host name and port number per PDB
• Change the different modes and settings of PDBs
• Start PDB service
• Open and close PDBs
• Avoid service name conflicts
• Establish connections to CDB and PDB
• Evaluate the impact of parameter value changes

7. Recovery and Flashback

• Reuse preplugin backups after conversion of a non-CDB to a PDB
• Perform CDB flashback
• Perform PDB flashback
• Recover a PDB from essential file damage
• Use clean restore points to complete PDB flashback
• Recover a PDB from non-essential file damage
• Reuse preplugin backups after plugging/relocating a PDB into another CDB
• Manage PDB snapshots

8. Data Movement

• Export from a PDB and import into a PDB
• Export from a non-CDB and import into a PDB
• Export from a PDB and import into a non-CDB
• Use SQL*Loader to load data into a PDB

9. Application PDBs and Application Installation

• Define application PDBs
• Use a dynamic container map
• Describe application containers in CDBs
• Create application PDBs
• Describe the commonality concept in application contexts
• Explain the purpose of application root and application seed
• Install, upgrade and patch an application
• Explain application installation on top of application containers

10. Storage

• Manage temporary tablespaces in CDB and PDBs
• Manage permanent tablespaces in CDB and PDBs
• Manage the UNDO tablespaces in CDB root and PDB

11. Security

• Enable common users to access data in PDBs
• Encrypt data in PDBs
• Manage PDB lockdown profiles
• Manage common and local objects in application containers
• Manage common and local users, roles, privileges and profiles in PDBs
• Protect data with Database Vault policies in CDB and PDBs
• Audit users in CDB and PDBs
• Manage other types of policies in application containers

12. Performance Monitoring

• Control PDB IO rate limits
• Run ADDM tasks for CDB and PDB recommendations
• Manage AWR snapshots at the CDB and PDB levels
• Monitor performance in a CDB and PDBs
• Manage application shared object statistics
• Monitor operations in a CDB and PDBs
• Control query DOP involving the containers() construct
• Manage SGA and PGA limits at the PDB level

13. Upgrade methods

• Plug in a remote PDB through XTTS into a target CDB
• Upgrade 12.2 CDB to 18c
• Upgrade 12.2 PDBs to PDBs in 18c

14. Miscellaneous

• Mine PDB statements using LogMiner
• Describe XStreams usage with PDB and CDB
• Describe Data Guard with CDB and PDB
• Schedule operations in a PDB using Oracle Scheduler
• Describe the limits of data replication