Oracle Database 19c: Multitenant Architecture

Focused View

Bob Bryla

1:30:51

0 View

[1] Introduction

[1] Multitenant.mp4

00:44

[2] What you should know.mp4

01:21

[2] 1. Multitenant Architecture

[1] Components of a multitenant environment.mp4

05:09

[2] CDB root.mp4

03:29

[3] PDB seed.mp4

03:33

[4] Connecting to CDBs and PDBs.mp4

06:35

[5] Multitenant data dictionary views.mp4

03:47

[6] Challenge Connect to the CDB and PDB.mp4

01:41

[7] Solution Connect to the CDB and PDB.mp4

03:05

[3] 2. Create and Clone PDBs and Users

[1] Creating a container database.mp4

03:58

[2] Creating a PDB from the seed database.mp4

05:01

[3] Copying a PDB.mp4

06:38

[4] Dropping a PDB.mp4

03:13

[5] Creating and managing local and common users.mp4

06:02

[6] Moving a PDB.mp4

04:18

[7] Upgrading a PDB to a new database version.mp4

04:06

[8] Challenge Move a PDB to a new container with SQL Developer.mp4

01:02

[9] Solution Move a PDB to a new container with SQL Developer.mp4

02:18

[4] 3. Application PDBs

[1] Creating application containers and application PDBs.mp4

04:06

[2] Installing an application in an application PDB.mp4

05:25

[3] Challenge Upgrade an application PDB.mp4

00:52

[4] Solution Upgrade an application PDB.mp4

02:44

[5] 4. Multitenant Backup and Recovery

[1] Back up a CDB and PDB with RMAN.mp4

03:25

[2] Recover a CDB or one of the PDBs.mp4

03:20

[3] Challenge Recover a PDB tablespace.mp4

00:43

[4] Solution Recover a PDB tablespace.mp4

02:58

[6] Conclusion

[1] Next steps.mp4

01:18

Description

Oracle introduced the multitenant architecture in version 12.1.0.2 as an available option, but after 19c, creating a multitenant database is the only option for a new database. Bob shows how to manage multitenant databases on the same server, how to create the CDB, create a PDB from the seed database, and clone a PDB to the same or another container. The multitenant architecture also has several new options when backing up and recovering databases and individual tables with the existing RMAN utility, so Bob explains new RMAN scenarios and details when to back up just the CDB root, the entire CDB, or individual PDBs. He covers how to create and manage a special type of PDB called an application PDB and shows how to leverage the versioning capabilities included with application containers.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Oracle SQL

Bob Bryla

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.