English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 30m | 247 MB
Oracle introduced the multitenant architecture in version 12.1.0.2 as an available option, but starting with 19c, creating a multitenant database is the only option for a new database. In this course, Oracle database administrator Bob Bryla helps DBAs create and effectively utilize resources within multitenant databases. Bob shows how to manage one or more 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 also covers how to create and manage a special type of PD called an application PDB, also known as an application container, and shows how to leverage the versioning capabilities included with application containers.
Table of Contents
Introduction
1 Multitenant
2 What you should know
1. Multitenant Architecture
3 Components of a multitenant environment
4 CDB root
5 PDB seed
6 Connecting to CDBs and PDBs
7 Multitenant data dictionary views
8 Challenge Connect to the CDB and PDB
9 Solution Connect to the CDB and PDB
2. Create and Clone PDBs and Users
10 Creating a container database
11 Creating a PDB from the seed database
12 Copying a PDB
13 Dropping a PDB
14 Creating and managing local and common users
15 Moving a PDB
16 Upgrading a PDB to a new database version
17 Challenge Move a PDB to a new container with SQL Developer
18 Solution Move a PDB to a new container with SQL Developer
3. Application PDBs
19 Creating application containers and application PDBs
20 Installing an application in an application PDB
21 Challenge Upgrade an application PDB
22 Solution Upgrade an application PDB
4. Multitenant Backup and Recovery
23 Back up a CDB and PDB with RMAN
24 Recover a CDB or one of the PDBs
25 Challenge Recover a PDB tablespace
26 Solution Recover a PDB tablespace
Conclusion
27 Next steps
Resolve the captcha to access the links!