Overview
-
This course teaches database administrators to create and effectively utilize resources within multitenant databases.
Syllabus
-
Introduction
- Multitenant
- What you should know
- Components of a multitenant environment
- CDB root
- PDB seed
- Connecting to CDBs and PDBs
- Multitenant data dictionary views
- Challenge: Connect to the CDB and PDB
- Solution: Connect to the CDB and PDB
- Creating a container database
- Creating a PDB from the seed database
- Copying a PDB
- Dropping a PDB
- Creating and managing local and common users
- Moving a PDB
- Upgrading a PDB to a new database version
- Challenge: Move a PDB to a new container with SQL Developer
- Solution: Move a PDB to a new container with SQL Developer
- Creating application containers and application PDBs
- Installing an application in an application PDB
- Challenge: Upgrade an application PDB
- Solution: Upgrade an application PDB
- Back up a CDB and PDB with RMAN
- Recover a CDB or one of the PDBs
- Challenge: Recover a PDB tablespace
- Solution: Recover a PDB tablespace
- Next steps
