|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/oracle-multitenant-database-administration/
课程评论：没有评论
课程名称：Oracle多租户架构与数据库管理 概述：欢迎参加Uplatz提供的Oracle多租户架构与数据库管理课程。自Oracle 12c之后，Oracle推出了一种新的架构—多租户架构。在早期的Oracle数据库版本中，当用户启动新实例时，每个实例都会产生特定的后台进程，造成大量内存和资源浪费，严重影响系统性能。因此，Oracle提出了将不同数据库连接到一个数据库的理念，这就是“多租户架构”。主要数据库称为CDB（容器数据库），而连接主要数据库的其他数据库称为PDB（可插拔数据库）。PDB与非CDB完全兼容，确保了在多租户架构中，任何在非CDB中执行的操作在PDB中也能正常工作。 在Oracle 12c中创建多租户数据库环境时，必须将数据库指定为CDB或非CDB，以支持多租户架构。该课程涵盖了通过DBCA（数据库配置助手）创建容器数据库的步骤。多租户架构允许在单个Oracle数据库实例中拥有多个PDB，CDB实例的架构使用相同的后台进程和系统全局区域（SGA）来维护更多的PDB。 主要概念： 1. **容器数据库（CDB）**：包含多个可插拔数据库（PDB）的主要数据库。 2. **可插拔数据库（PDB）**：一个自包含的数据库，可以从CDB中插入或拔出。 3. **根容器（CDB$ROOT）**：保存共享元数据、用户和组件的中央容器。 4. **样本PDB（PDB$SEED）**：用于创建新PDB的模板。 5. **应用程序容器**：用于将多个PDB作为一个单元进行管理。 Oracle多租户的优势： - **高效整合**：多个PDB共享同一数据库实例，减少资源开销。 - **简化管理**：如补丁、备份和恢复等DBA任务在CDB级别执行。 - **快速配置**：通过克隆PDB，快速创建新数据库。 - **资源管理**：可为各个PDB分配CPU、内存和存储。 - **高可用性**：与Oracle Data Guard和RAC配合实现灾难恢复和性能优化。 该课程将帮助学员理解多租户架构及不同类型的PDB，学习Oracle数据库19c的安装和CDB与非CDB数据库的创建，掌握PDB的创建、用户管理和CDB/PDB的备份与恢复流程。还将了解资源管理器、数据泵等多种实用工具。通过学习，学员将掌握Oracle多租户DBA所需的全套技能，并能有效管理应用程序和应用容器。 课程内容包括： - Oracle多租户DBA概述 - 在Oracle虚拟框中安装Oracle Linux 7.8 - 安装Oracle数据库19c软件 - 创建CDB和非CDB数据库 - 从种子创建PDB - 执行基本CDB管理任务 - 从本地和远程PDB克隆创建PDB - 插入已拔出的PDB - 从非CDB创建PDB - 迁移PDB - 管理公共和本地用户 - CDB和PDB的备份与恢复 - 闪回和时间点恢复 - 与CDB和PDB一起使用资源管理器 - 使用PDB的数据泵工具 - 管理应用程序和应用程序容器 - 在Oracle VM上安装Oracle Linux 8 - 介绍Oracle 21c DBA - Oracle 21c架构 通过以上的学习，学员将能够创建和管理Oracle多租户数据库环境。
A warm welcome to the Oracle Multitenant Architecture and Database Administration course by Uplatz.Post Oracle 12c, Oracle came up with new architecture called Multitenant Architecture.In previous versions of Oracle database versions, there was a major problem - if the user starts a new instance there are particular background processes for each instance and each of these process wasted a lot of memory and resources thus affecting the system performance badly. Hence, Oracle came up with a new idea to connect different databases into one database technique. That idea is called "Multitenant Architecture."That one main database is called CDB (Container Database) and other databases which are used to connect the main database are called PDB (Pluggable Database). A pluggable database is fully compatible with a non-CDB. In fact, Oracle has something called the PDB/non-CDB compatibility guarantee, which states that anything you would do in a non-CDB would also work in a PDB. This compatibility guarantee is important when it comes to certifying things like third-party vendor products to work in a multitenant architecture.How to create a multitenant database environment in Oracle 12cWhen creating a database, you must designate it as a CDB or non-CDB for it to be able to support the multitenant architecture. The next set of examples walks you through the steps to create a container database with the DBCA. There is only one step that differentiates a CDB from a non-CDB when using the DBCA.The multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. The Oracle Multitenant Database Architecture is designed to host multiple "PLUGGABLE DATABASE" PDB databases within a single CDB "CONTAINER DATABASE" container instance. The architecture of the CDB instance maintains more PDBs within it, using the same set of processes and the same SGA (System Global Area).Key Concepts of Oracle Multitenant ArchitectureContainer Database (CDB) - The main database that contains multiple Pluggable Databases (PDBs).Pluggable Database (PDB) - A self-contained database that can be plugged into or unplugged from a CDB.Root Container (CDB$ROOT) - The central container that holds common metadata, users, and shared components.Seed PDB (PDB$SEED) - A template used for creating new PDBs.Application Containers - Used for managing multiple PDBs as a single unit.Advantages of Oracle MultitenantEfficient Consolidation - Multiple PDBs share the same database instance, reducing resource overhead.Simplified Management - DBA tasks like patching, backup, and recovery are performed at the CDB level.Rapid Provisioning - New databases can be created quickly by cloning PDBs.Resource Management - CPU, memory, and storage can be allocated to individual PDBs.High Availability - Works with Oracle Data Guard and RAC for disaster recovery and performance.The Multitenant architecture facilitates the following:High consolidation density: Many databases can share memory and background processes.Provisioning: A database can be unplugged from one environment and plugged into another or cloned with SQL commands in just a few seconds. They can even be plugged across operating systems and chipsets.Patching and upgrades: You can patch a database simply by unplugging from one unpatched container and plugging it into another patched container.Manage many databases concurrently: You can do tasks such as backing up and patching on the primary container database instead of the individual pluggable databases.Resource management: The Oracle Resource Manager feature can work at the pluggable database level for you to manage resource competition among the databases in your environment.This Oracle Multitenant Architecture and Database Administration course by Uplatz will help you learn the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). You will understand the process of installing Oracle Database 19c followed by the creation of CDB and non-CDB databases. Oracle Database 19c Multitenant Architecture course explores the multitenant architecture and the different types of pluggable databases (PDBs) in multitenant container databases (CDBs). In this Oracle Multitenant Database Administration course, you will be creating a PDB through different methods, managing users, understanding the back-up and recovery processes in CDB and PDBs. You will also gain knowledge of the various utilities used for e.g. resource manager, data pump utility, and so on. Overall, you'll become a professional Oracle Multitenant DBA with end-to-end skills on managing applications and application containers.Oracle Multitenant Architecture and Database Administration - Course CurriculumOverview of Oracle Multitenant DBAInstalling Oracle Linux 7.8 in Oracle Virtual BoxInstalling Oracle Database 19c SoftwareCreating CDB and non-CDB databasesCreating PDBs from the SeedPerforming Basic CDB Administration TasksCreating a PDB by Cloning from Local and Remote PDBsCreating PDB by Plugging in an Unplugged PDBCreating a PDB from non-CDBCreating a PDB by Relocating a PDBManaging Common and Local UsersBackup and Recovery in CDB and PDBsFlashback and Point-in-time RecoveryUsing Resource Manager with CDB and PDBsUsing Data Pump Utility with PDBsManaging Applications and Application ContainersInstallation Of Oracle Linux 8 on Oracle VMIntroduction to Oracle 21c DBAOracle 21c ArchitecturePractice 1 - Creating a CDBPractice 2 - Creating PDBs from the SeedPractice 3 - Performing Basic CDB Administration TasksPractice 4 - Managing Common and Local UsersPractice 5 - Backup and Recovery in CDB and PDBsPractice 6 - Flashback and Point-in-time Recovery
