Oracle 19c Container and Pluggable Database Administration

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: CHANGES TO DATABASE MANAGEMENT TOOLS

• Enterprise Manager Express Home Page
• SQL Developer new DBA management functionality
• Changes to the OUI and the DBCA

Session 2: ORACLE DATABASE MULTITENANT ARCHITECTURE

• Overview of the Oracle Database architecture
• An overview of a Container Database (CDB)
• The benefits of Multitenant Architecture
• The Root Container and Pluggable Database containers
• The structure of the Root Container
• The structure of a Pluggable Database (PDB)
• CDB_xxx and DBA_xxx Views
• Plan an installation
• System requirements and operating system prerequisites
• Install the Oracle Database 19c software with the OUI
• The Oracle Inventory
• Silent mode installation
• Database software de-install
• Workshop Exercises

Session 3: CREATE A DATABASE WITH THE DATABASE CONFIGURATION ASSISTANT (DBCA)

• Create a Container and Pluggable databases with the OUI
• Select a database storage method
• Select a CDB or non-CDB database
• Select a database type based on workload
• Select a character set for the database
• Set the NLS_LANG initialization parameter
• Create a database with the DBCA
• Manual Creation of a CDB
• Workshop Exercises

Session 4: MANAGE A CONTAINER DATABASE AND PLUGGABLE DATABASES

• Introduction
• Connect to a CDB as an administrator
• Connect to a CDB using a service name
• Connect to a Pluggable database
• Display the current container
• Switch between containers
• Startup and shutdown a CDB
• Open and close a PDB
• Open and close all PDBs
• Automatic startup of pluggable databases
• Preserve or discard the PDB open mode after a CDB restart
• Change the state of a PDB
• Workshop Exercises

Session 5: NEW TABLESPACE AND MANAGEMENT FEATURES

• Introduction
• Data storage overview
• Create and manage tablespaces in the CDB and PDBs
• Online rename and Relocation of an active datafile
• Restrict PGA Size
• Configure Instance Parameters in a CDB and a PDB
• Enable and disable temporary undo
• Query temporary undo information
• Workshop Exercises

Session 6: MANAGE COMMON AND LOCAL USERS, ROLES AND PRIVILEGES

• Introduction
• Overview of common and local user management
• Create and manage common users
• Create and manage local users
• Create common roles
• Create local roles
• Grant roles and privileges to common and local users
• Use the PDB CONTAINERS clause with common and local users
• Block common users from accessing local data with Oracle Database Vault
• Workshop Exercises

Session 7: CONFIGURE A CONTAINER DATABASE AND CREATE AND CLONE PLUGGABLE DATABASES

• Configure a Container Database
• Examine the structure of a CDB using CDB_XXX views
• Administer the database using SQL Developer and EM Express
• Create a new PDB from PDB$SEED
• The PDB LOGGING and NOLOGGING clauses
• Create a Metadata only PDB
• Clone a PDB subset
• Create a PDB from a non-CDB
• Clone a PDB into the same CDB
• Clone a PDB into the same CDB using database links
• Clone a remote PDB or non-CDB
• Clone a remote PDB using DBCA Silent mode
• Plug and unplug a PDB
• Parallel PDB creation
• Create a PDB with a default tablespace
• Use local UNDO mode with a PDB
• Hot clone a PDB
• Refresh a read only PDB
• Plug and unplug a PDB using a PDB archive file
• Relocate a PDB to a new container
• Relocate a PDB from a remote CDB to a local CDB
• Remote proxy PDBs
• Workshop Exercises

Session 8: AVAILABILITY ENHANCEMENTS

• The SYSBACKUP privilege
• Execute SQL statements in RMAN
• Use the RMAN DESCRIBE Command
• RMAN syntax enhancements
• Container and Pluggable Database Backups
• Backup a Container Database
• Root Container Backup
• Backup a Pluggable Database
• Tablespace and Datafile Backups
• Container and Pluggable Database Recovery
• Container Database Complete Recovery
• Root Container Complete Recovery
• Pluggable Database Complete Recovery
• Tablespace and Datafile Complete Recovery
• Point in Time Recovery
• Container Database Point in Time Recovery
• Pluggable Database Point in Time Recovery
• Table Point in Time Recovery
• Recover a CDB from the Loss of Redo Logs, Control Files and Undo
• Use Flashback at CDB Level
• Restrictions on Point in Time Recovery of Pluggable Database
• RMAN syntax enhancements
• Recover a database after missing redo logs found
• Enhanced table point in time recovery
• The enhanced REPAIR FAILURE command
• Enhanced table point in time recovery
• Create multi-section backups
• Backup and restore very large files
• Recover a database after missing redo logs found
• Reuse preplugin backups before and after a non-CDB conversion as a PDB or a PDB migration to another CDB
• Clone an active PDB into another CDB using DUPLICATE
• Workshop Exercises

Session 9: RECOVERY AND FLASHBACK AT PDB LEVEL

• Shutdown a PDB with critical datafiles missing
• Flashback a pluggable database at PDB level
• Create a restore point at CDB and PDB level
• Create a clean restore point
• Flashback a PDB in local and shared undo mode

Session 10: APPLICATIONS AND APPLICATION CONTAINERS

• Application Root and Application Container PDBs
• Create an Application Container
• Open an Application Container
• Create network services
• Drop an Application Container
• Manage Applications
• Install and uninstall an Application
• Upgrade an Application
• Drop an Application Container
• Manage an Application seed
• Application common objects
• Application Container views

Session 11: PDB SECURITY

• Create common and local users in an application
• Grant common and local privileges in an application
• Create and grant common and local roles in application containers
• Use common and local objects and profiles in an application
• Application common objects
• Implement Lockdown Policies
• Assign a lockdown profile to a PDB
• Lockdown profile inheritance
• Create and use static and dynamic lockdown profiles
• Isolate PDB Keystores

Session 12: PDB PERFORMANCE MANAGEMENT

• Automatic Workload Repository Data at CDB and PDB Level
• Enable PDB snapshots
• Analyze AWR data in a PDB
• Disable AWR for a PDB with a Lockdown profile
• Automatic ADDM analysis for PDBs
• Set SGA and PGA for a PDB
• Share Resource between PDBs
• PDB Profile Directives
• Share Based Instance Caging
• Limit I/O rates for PDBs
• Use PDB Resource Plans

Session 13: RESOURCE MANAGER ENHANCEMENTS

• Memory Resource management for PDBs
• Manage session PGA limit
• Control memory usage for PDBs
• PDB memory parameters
• Set PDB memory parameters
• Monitor memory usage for PDBs
• The SESSION_PGA_LIMIT parameter
• Limit session PGA with a resource plan
• Manage session PGA limit

Session 14: SQL TUNING ENHANCEMENTS

• New default values for OPTIMIZER_ADAPTIVE parameters
• Adaptive Query optimization enhancements from 12.2
• The Optimizer Statistics Advisor rules, findings, recommendations and actions
• The Expression Statistics Store
• Continuous Adaptive Query plans
• Enhancements to the SQL Performance Analyzer
• Enhancements to SQL Plan Management
• Execution plan capture from AWR
• Automatic Capture files

Session 15: DIAGNOSABILITY

• Set an ADR retention target
• The Retention Advisor
• The TFA Collector
• Install the TFA Collector
• Manage the TFA daemon
• Start and stop the TFA Collector
• Dynamic Data Pump tracing

Session 16: PREPARATION FOR UPGRADE

• Methods used to perform upgrade
• Methods of data migration
• Direct upgrade supported releases
• The Database Upgrade Assistant (dbua)
• Upgrade process overview
• Rolling upgrade
• Create an upgrade test plan
• Carry out performance testing
• Run the Pre-Upgrade Information tool
• Backup the database
• Install the Oracle Database software
• Create the new Oracle home

Session 17: UPGRADE TO ORACLE DATABASE

• Prepare to upgrade a database to 19c
• Execute preupgrade.jar
• Upgrade a database with the Database Upgrade Assistant (DBUA)
• Upgrade a database manually
• Post upgrade tasks
• Plugin an upgraded database as a PDB into a CDB
• Deprecated database features and parameters

Session 18: POST UPGRADE TASKS

• Common installation errors
• Check the /etc/oratab file
• Check the database version
• Enterprise Manager Express configuration
• Carry out post upgrade tasks after a manual upgrade
• Migrate to unified auditing

Session 19: MIGRATE DATA WITH DATA PUMP

• Migrate data with Data Pump
• Transport a database
• Import data using a Data Pump network link