Oracle Multitenant Administration

Course Introduction

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

Session 1: ORACLE DATABASE MULTITENANT ARCHITECTURE

• Overview of the Oracle Database architecture
• Change of MTA licencing at 19c
• 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
• Multitenant Administrators Guide
• System requirements and operating system prerequisites
• Install the Oracle Database 19c software with the OUI
• The Oracle Inventory
• Workshop Exercises

Session 2: CREATE A CDB AND PDBs WITH THE DBCA

• Create a Container and Pluggable databases with the DBCA
• Create a database using DBCA Silent Mode
• Create a database using a response file with DBCA Silent Mode
• Create a demonstration database using the Pre-Install RPM
• Create a database using a response File with DBCA Silent Mode
• Create a duplicate database with DBCA Silent Mode
• Delete a Database with the DBCA Silent Mode
• Post database creation tasks
• Workshop Exercises

Session 3: MANAGE A CDB AND PDBs

• 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 4: CDB AND PDB ADMINISTRATION

• Administer a CDB and PDBs using SQL Developer
• Multitenant data storage overview
• Create and manage tablespaces in the CDB and PDBs
• Online rename and relocation of an active datafile
• Configure instance parameters in a CDB and a PDB
• The PDB LOGGING and NOLOGGING clauses
• Manage Undo tablespaces in a PDB
• Upgrade a PDB from shared undo mode to local undo mode
• Query temporary undo information
• Set the default tablespaces in a PDB
• Query container data objects (CONTAINER_DATA)
• Enable Unified Auditing for a Container and Pluggable Databases
• Workshop Exercises

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

• 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 profiles with common and local users
• Use the PDB CONTAINERS clause with common and local users
• Use the CONTAINER_DATA attribute of a common user
• Audit users in a CDB and PDBs
• Block common users from accessing local data with Oracle Database Vault
• Workshop Exercises

Session 6: CREATE AND CLONE PLUGGABLE DATABASES

• Create a new PDB from PDB$SEED
• Create a New PDB from an existing PDB using Hot Cloning
• Parallel PDB creation
• Create a PDB with a default tablespace
• Create a metadata only PDB
• Clone a PDB subset
• Upgrade a non-container database to a 19c PDB using DBMS_PDB
• Use Data Pump to move PDB within or between CDBs
• Unplug a PDB using an XML metadata file
• Unplug a PDB using a PDB archive file
• Check that a PDB is compatible with a CDB
• Plug in a PDB
• Drop a PDB
• Clone a PDB into the same CDB
• Clone a PDB into the same CDB using database links
• Clone a remote PDB
• Clone a remote non-CDB
• Clone a remote PDB using DBCA Silent mode
• Use local UNDO mode with a PDB
• Automatically refresh a read only PDB
• Refreshable PDB Switchover
• Relocate a PDB to a new container
• Relocate a PDB from a remote CDB to a local CDB
• Remote proxy PDBs
• Workshop Exercises

Session 7: BACKUP AND RECOVER AT CDB AND PDB LEVEL

• The SYSBACKUP privilege
• Container and pluggable database backups
• The RMAN VALIDATE command
• Backup a container database
• Backup the Root container
• Backup a Pluggable database
• Tablespace and datafile backups
• The enhanced REPAIR FAILURE command
• 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 or control files
• Clone an active PDB into another CDB using DUPLICATE
• Create usable backups of non-CDB databases and relocated PDBs
• Recover from a preplugin backup
• Workshop Exercises

Session 8: RECOVERY AND FLASHBACK AT PDB LEVEL

• Local and Shared UNDO mode
• Enable and disable flashback database
• Create a restore point at CDB and PDB level
• Create a clean restore point
• Flashback a container database
• Flashback a pluggable database
• Flashback a PDB in local and shared undo mode
• Flashback a PDB without influencing a CDB
• Restrictions on point in time recovery of a pluggable database
• Workshop Exercises

Session 9: APPLICATIONS AND APPLICATION CONTAINERS

• The Structure of an Application Container
• Application Root and Application Container PDBs
• Create an Application Container
• Open an Application Container
• 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
• 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

Session 10: PDB SECURITY

• Lockdown Policy Overview
• Implement Lockdown Policies
• Create and assign a lockdown profile to a PDB
• Create and assign a lockdown profile to an Application root Container
• Lockdown profile inheritance
• Create and use static and dynamic lockdown profiles
• Isolate PDB Keystores

Session 11: PDB PERFORMANCE MANAGEMENT

• Monitor memory usage for PDBs
• PDB Memory Parameters
• Control memory usage for PDBs
• Manage PGA limit for PDBs with the SESSION_PGA_LIMIT parameter
• Limit session PGA with a resource plan
• Limit Share Resource between PDBs
• Share Based Instance Caging
• Limit I/O rates for PDBs
• Automated Maintenance Tasks
• Dynamic CPU Scaling for PDBs
• PDB Profile Directives
• Resource Manager PDB Performance Profiles
• Use PDB Resource Plans
• Automatic Workload Repository Data at CDB and PDB Level
• Enable PDB snapshots
• Analyse AWR data in a PDB
• Disable AWR for a PDB with a Lockdown profile
• Automatic ADDM analysis for PDBs

Session 12: PREPARATION FOR UPGRADE TO 19c MULTITENANT

• Overview of the upgrade to 19c process
• Methods used to perform upgrade
• Methods of data migration
• Direct upgrade supported releases
• The Database Upgrade Assistant (dbua)
• Upgrade process overview
• 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 13: UPGRADE TO ORACLE DATABASE 19c MULTITENANT

• Prepare to upgrade a database to 19c
• Execute preupgrade.jar
• Upgrade a database with the Database Upgrade Assistant (DBUA)
• Run the DBUA in Silent mode
• Upgrade a database manually
• Manually restart a failed upgrade
• Post upgrade tasks
• Deprecated database features and parameters
• Carry out post upgrade tasks
• Upgrade a PDB

Session 14: MIGRATE DATA TO AND FROM A PDB WITH DATA PUMP

• Migrate data to and from a PDB with Data Pump
• Transport a database
• Import data using a Data Pump network link