This course offers a deep dive into the Oracle Database Multitenant architecture, providing you with the necessary tools and knowledge to manage both Container Databases (CDBs) and Pluggable Databases (PDBs). You’ll begin by understanding the fundamentals of Oracle Multitenant, exploring the business challenges it addresses, and the architecture's structural components. As you progress, the course will guide you through the creation and management of CDBs and PDBs, emphasizing hands-on practice sessions that reinforce your learning.
You’ll also delve into advanced topics such as PDB cloning, relocation, and the effective use of Oracle Recovery Manager (RMAN) for backup and recovery within the Multitenant environment. The course emphasizes practical skills, with multiple practice sessions that allow you to create and manage PDBs using different methods, ensuring you gain confidence in your ability to handle real-world scenarios.
By the end of this course, you will have a thorough understanding of Oracle Multitenant’s advanced features, such as managing application containers, performing application maintenance, and leveraging the new features in Oracle 18c and 19c. Whether you’re preparing for certification or aiming to enhance your database administration skills, this course will prepare you to manage Oracle Multitenant environments with proficiency and ease.
This course is ideal for Oracle database administrators and IT professionals who are responsible for managing Oracle environments. Participants should have a basic understanding of Oracle Database administration and SQL. Familiarity with database concepts and experience with Oracle 12c or later is recommended.
Overview
Syllabus
- Introduction
- In this module, we will introduce you to the Oracle Database Multitenant architecture and outline the course objectives. You'll gain an understanding of the key topics that will be explored and how they relate to multitenant database administration.
- Oracle Database Multitenant Architecture
- In this module, we will delve into the Oracle Database Multitenant Architecture, covering both the 12.1 and 12.2 versions. You will explore the architecture’s key components and examine the improvements and new features introduced in the 12.2 version.
- Create CBD Containers and PDB Containers
- In this module, we will guide you through the process of creating Container Databases (CDBs) and Pluggable Databases (PDBs). You will engage in hands-on practice to build a CDB, starting with preparing the environment and then creating and managing CDBs and PDBs in multiple parts.
- Basic Oracle Multitenant Database Administration
- In this module, we will explore fundamental concepts of Oracle Database Multitenant administration and cover essential tasks such as managing CDBs and PDBs. You will also participate in practical exercises to reinforce your understanding and skills in performing basic administration tasks.
- Creating PDBs, All the Methods
- In this module, we will explore the multiple methods available for creating Pluggable Databases (PDBs) within the Oracle Multitenant framework. You’ll gain practical experience by cloning PDBs, plugging in unplugged PDBs, converting non-CDBs, and creating proxy and refreshable PDBs using advanced techniques.
- Managing Connectivity and Services in Oracle Multitenant
- In this module, we will focus on the management of connectivity and services within Oracle Multitenant environments. You will learn about different connectivity options, how to set up and manage services for effective communication, and techniques for troubleshooting common connectivity issues.
- Managing Security in Oracle Multitenant Database
- In this module, we will delve into the security aspects of Oracle Multitenant databases, focusing on user management and lockdown profiles. You’ll learn how to manage both local and common users and apply PDB lockdown profiles to enhance security. Hands-on exercises will solidify your understanding of these critical security practices.
- Managing Backup, Recovery, and Flashback Database
- In this module, we will cover essential strategies for managing backup, recovery, and flashback operations within Oracle Multitenant databases. You will learn how to perform backups, recover from failures, and utilize flashback and point-in-time recovery features. Hands-on practices will reinforce your ability to protect and restore both CDBs and PDBs efficiently.
- Using Resource Manager in Oracle Multitenant Database
- In this module, we will explore the use of Oracle Resource Manager within a multitenant database environment. You will learn how to configure and manage Resource Manager plans to ensure optimal resource distribution among CDBs and PDBs, enhancing overall database performance and efficiency.
- Miscellaneous Topics on Oracle Multitenant Database
- In this module, we will cover a range of miscellaneous topics related to Oracle Multitenant databases, including advanced features and tools. You will engage in practical exercises to apply these topics, such as using the Data Pump utility for data export and import within PDBs, to further refine your multitenant database administration skills.
- Managing Applications and Application Containers
- In this module, we will focus on managing applications and application containers within Oracle Multitenant databases. You will learn how to handle application common objects, perform essential maintenance tasks, and manage applications effectively. Hands-on practices will solidify your skills in administering applications within a multitenant environment.
- Introduction to Oracle Database Multitenant New Features in 18c and 19c
- In this module, we will explore the latest features introduced in Oracle Database Multitenant with versions 18c and 19c. You will learn how to prepare and configure the Oracle Database 19c environment to take full advantage of these enhancements through step-by-step practice sessions.
- Managing CDB Fleet
- In this module, we will cover the management of a CDB fleet, focusing on how to oversee multiple Container Databases within a multitenant architecture. You will learn strategies for effective fleet management and engage in hands-on practices to administer and monitor a CDB fleet successfully.
- Managing a PDB Snapshot Carousel
- In this module, we will dive into the PDB Snapshot Carousel feature, which allows you to manage and maintain snapshots of Pluggable Databases (PDBs) over time. You’ll learn how to set up and configure a snapshot carousel, manage snapshots effectively, and practice restoring PDBs from these snapshots through a series of practical exercises.
- Switching Over a Refreshable Clone PDB
- In this module, we will explore the process of switching over a refreshable clone Pluggable Database (PDB) within Oracle Multitenant. You will learn the scenarios where this feature is beneficial, and through practical exercises, you’ll gain the skills to perform a switchover, ensuring continuous availability and data integrity.
- PDB Cloning and Relocation Using DBCA
- In this module, we will cover the process of cloning and relocating Pluggable Databases (PDBs) using the Database Configuration Assistant (DBCA). You will learn how to effectively use DBCA for these tasks, and through practical exercises, you’ll gain the skills to clone and relocate PDBs in different environments, ensuring smooth database operations.
Taught by
Packt - Course Instructors
