Detailed Course Outline
CDB Basics
- Describe the multitenant architecture
- Describe the CDB root and pluggable database containers
- Differentiate the CDB root from a pluggable database
- Understand the terminology of commonality
- List impacts in various areas
CDB and Regular PDBs
- Configure and create a CDB
- Create a new PDB from the CDB seed
- Explore the instance
- Explore the structure of PDBs
- Explore the Automatic Diagnostic Repository (ADR)
Application PDBs and Application Installation
- Describe application containers in CDBs
- Explain the purpose of application root and application seed
- Define application PDBs
- Create application PDBs
- Explain application installation on top of application containers
- Install an application
- Upgrade and patch applications
- Describe the commonality concept in application contexts
PDB Creation
- Clone a regular PDB
- Clone an application PDB
- Unplug and plug a non-CDB
- Unplug and plug a regular PDB
- Unplug and plug an application container
- Convert regular PDBs to application PDBs
- Configure and use the local UNDO mode
- Perform hot cloning and relocation
CDB and PDB Management
- Establish connections to CDB and PDB
- Start up and shut down a CDB
- Open and close PDBs
- Avoid service name conflicts
- Start PDB service
- Change the different modes and settings of PDBs
- Evaluate the impact of parameter value changes
- Configure host name and port number per PDB
Storage
- Manage permanent tablespaces in CDB and PDBs
- Manage temporary tablespaces in CDB and PDBs
- Manage the UNDO tablespaces in CDB root and PDB
Security
- Manage common and local users, roles, privileges and profiles in PDBs
- Manage common and local objects in application containers
- Enable common users to access data in PDBs
- Manage PDB lockdown profiles
- Audit users in CDB and PDBs
- Manage other types of policies in application containers
- Protect data with Database Vault policies in CDB and PDBs
- Encrypt data in PDBs
Backup, Recovery, and Flashback
- Backup CDB and PDBs
- Recover a PDB from essential file damage
- Recover a PDB from non-essential file damage
- Use RMAN backups to plug unplugged PDBs
- Duplicate PDBs
- Validate CDBs and PDBs
- Perform CDB flashback
- Perform PDB flashback
Performance Monitoring
- Monitor operations in a CDB and PDBs
- Monitor performance in a CDB and PDBs
- Manage SGA and PGA limits at the PDB level
- Manage AWR snapshots at the CDB and PDB levels
- Run ADDM tasks for CDB and PDB recommendations
- Manage application shared object statistics
- Control query DOP involving the containers() construct
- Control PDB IO rate limits
Resources Allocation
- Manage resource allocation between PDBs and within a PDB
- Manage PDB performance profiles
- Avoid excessive session PGA
Data Movement
- Export from a non-CDB and import into a PDB
- Export from a PDB and import into a PDB
- Export from a PDB and import into a non-CDB
- Use SQL*Loader to load data into a PDB
Upgrade Methods
- Upgrade 12.1 CDB to 12.2
- Upgrade 12.1 PDBs to PDBs in 12.2
- Plug in a remote PDB through XTTS into a target CDB
Miscellaneous
- Describe the limits of data replication
- Describe XStreams usage with PDB and CDB
- Describe Data Guard with CDB and PDB
- Schedule operations in a PDB using Oracle Scheduler
- Mine PDB statements using LogMiner
PDBs in Cloud
- Create a database deployment in the Cloud
- Create PDBs in the Cloud database using DBaaS Monitor
- Understand encryption in a Cloud CDB and PDBs
- Manage PDBs in the Cloud database using DBaaS Monitor
- Migrate on-premises PDBs in a database deployment in the Cloud