Oracle Essential Multitenant Administration

Course Code: OEMA

Duration: 2 days

 
 

Oracle Essential Multitenant Administration Course Overview

Prior to 19c, Oracle only allowed a single user-defined pluggable database (without having to license the full multitenant option). Oracle have announced that from 19c onward there can be 3 user-defined PDBs, without having the multitenant option. The non-CDB architecture has been deprecated from 12.1.0.2. From Oracle 20c the non-CDB architecture will be de-supported. An upgrade to 20c will also include a migration to the multitenant architecture. Now is the time for DBAs to move to Oracle 19c multitenant. When the move to the next long term Oracle 20c support release is made, the basic multitenant features will be understood by the DBAs and can be taken advantage of immediately.

This Oracle Essential Multitenant Administration course is designed to give experienced Oracle Database Administrators practical experience creating Container and Pluggable databases, upgrading a non-container database to a Pluggable database and carrying out essential administration tasks in a multitenant environment. Delegates will also gain an appreciation of how the Multitenant features may be implemented at their own sites.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Notes: The focus of this course is on the basic functionality of container and pluggable databases. Delegates who require a more comprehensive understanding of all the Multitenant Architecture functionality should attend the 4 day Oracle Multitenant Administration course. The Oracle Database 12cR2, 18c and 19c New Features for Administrators course covers the general new features that have been introduced in Oracle Database 12cR2, 18c and 19c.

Versions supported 19c, 18c, 12c.

Course Objectives

The course aims to provide the delegate with practical experience of carrying out essential tasks in administering and managing container and pluggable databases.

Who will the Course Benefit?

This Oracle Essential Multitenant Administration course is designed for Oracle professionals who need to upgrade their database skills to implement the essential Multitenant Architecture features and functionality in Oracle 19c.

Skills Gained

The delegate will learn and acquire skills as follows:

  • Understand Oracle Multitenant licensing
  • Create a container and pluggable database with the DBCA
  • Use different methods to create Pluggable databases
  • Upgrade a non-CDB database to a 19c PDB
  • Configure a CDB and PDBs
  • Manage container and pluggable databases
  • Administer tablespaces and data files in container databases
  • Manage common and local users, roles and privileges at CDB and PDB level
  • Plug and unplug a database with a PDB XML or archive file
  • Backup a Container and Pluggable Databases
  • Restore, recover and flashback at CDB and PDB level

Oracle Essential Multitenant Administration Training Course

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

Session 4: CDB AND PDB ADMINISTRATION

  • Administer a CDB and PDBs using EM Express and 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)
  • Configure Unified Auditing
  • 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

Oracle Essential Multitenant Administration Training Course

Session 6: CREATE AND CLONE PLUGGABLE DATABASES

  • Create a new PDB from PDB$SEED
  • 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
  • Unplug a PDB using an XML metadata file
  • Unplug a PDB using a PDB archive file
  • Plug in a PDB
  • Drop a PDB
  • Clone a PDB into the same CDB
  • Clone a PDB into the same CDB using database links
  • 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
Notes:
  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Requirements

Delegates who wish to attend this Oracle Essential Multitenant Administration course should have administration experience of Oracle Database. This knowledge can be gained by attendance on the pre-requisite Oracle Database 19c Administration course. Knowledge of using PL/SQL packages is strongly recommended.

This course is run on a Linux operating system, therefore a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Where Oracle 19c courses are listed in the Pre-requisite Courses section equivalent Oracle 18c or Oracle 12c courses would also suffice.

Pre-Requisite Courses

Public Scheduled Events

Classroom & Live Virtual Instructor-Led Training

Duration: 2 days

Price: £990.00 exc. VAT 


Start Date Options Spaces  
01 Sep 2022
StayAhead Virtual Courses available 
Spaces Book Now 
24 Oct 2022
StayAhead Virtual Courses available 
Spaces Book Now 
22 Dec 2022
StayAhead Virtual Courses available 
Spaces Book Now 
02 Mar 2023
StayAhead Virtual Courses available 
Spaces Book Now 
02 May 2023
StayAhead Virtual Courses available 
Spaces Book Now 
 

Live Virtual Classroom

 
Join live instructor-led classroom training from the comfort of your home or office.
All the convenience and benefits of the classroom experience without the hassle and costs of travel and accommodation.
 
 



Our Customers Include

 
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
missing image
 
 



Our Course Curriculum

 
 
 
 
Facebook LinkedIn Twitter Instagram E-Mail
 
+44 (0)20 7600 6116
Enquiries@StayAhead.com
Copyright © 2022 StayAhead Training Ltd
Cookies   /   Privacy Policy