Oracle Database Multitenant Administration (12c to 19c)

Obtain the skills to mater Oracle Multitenant Architecture (in releases 12c, 18c, and 19c)

What you'll learn
Describe the Oracle multitenant architecture
Create multitenant container database
Create a pluggable database using different methods
Create and manage common and local user accounts
Manage PDB lockdown profiles
Perform backup and recovery
Perform PITR and flashback
Use the Resource Manager in a container database
Use Data Pump utility with PDBs
Manage the applications and application containers
Manage the Oracle 18c and 19c Multitenant New Features


Requirements
Oracle Database Administration fundamentals
Linux operating system basics
PC with 16 GB, 100 GB HDD, Windows 7,8,or 10 64-bit , Oracle VirtualBox installed in it
Description
Learn how to build and manage Oracle Multitenant Architecture (including releases 12.1, 12.2, 18c, and 19c)
Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them.
Describe the Oracle multitenant architecture
Create multitenant container database
Create a pluggable database using different methods:
Creating a PDB from the seed
Cloning PDBs from local or remote PDBs including the refreshable PDBs
Plugging in an Unplugged PDB
Relocating a PDB
Creating a PDB from a non-CDB database
Creating Proxy PDBs
Manage the security in a multitenant container:
Create and manage common and local user accounts and roles
Manage PDB lockdown profiles
Perform backup and recovery, PITR and flashback database in a multitenant container
Use the Resource Manager in a multitenant container
Use Data Pump utility with PDBs
Manage the applications, application containers, application PDBs, and common objects
Manage Oracle database 18c and 19c multitenant new features:
Manage CDB fleet
Managing a PDB Snapshot Carousel
Switching Over a Refreshable Clone PDB
PDB Cloning and Relocation using DBCA
Content and Overview


Information presented in this course, will get the Oracle Database Administrators ready for the next generation of Oracle database. Through this course of 72 lectures and more than 13 hours of video-based sessions, you’ll learn all of the managing Oracle Multitenant Architecture. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.
Starting with introducing the Oracle Multitenant Architecture, this course will take you all the away from creating an Oracle 12c multitenant CDB container on a Linux platform, creating new PDBs using all the possible methods of creating them, managing the security in a multitenant container, implementing the backup and recovery, flashback database, PITR, using the Resource Manager, applying the auditing policies, using the data pump utility, up to managing the applications, application containers, and common objects. The course will cover the multitenant capabilities in the releases: 12.1, 12.2, 18c, and 19c.
This is an opportunity for the students to gain practical experience on this new Oracle cutting-edge technology, and get themselves ready for managing Oracle databases on the cloud.
Upon completing this course, you will be able to build up an Oracle multitenant container and have the knowledge and experience to manage it.
Join the author in this learning journey to experience this amazing technology!
Who this course is for:
Oracle Database Adminisrators

More Info